Restore-VEORDatabase

Short Description

Restores a backed-up Oracle database.

Applies to

Veeam Backup & Replication

Product Edition: Enterprise, Enterprise Plus, Veeam Universal License

Syntax

Restore-VEORDatabase [-Database] <VEORDatabase> [-Server <String>] [-OracleHome <String>] [-GlobalDatabaseName <String>] [-OracleSid <String>] [-WindowsCredentials <PSCredential>] [-OracleHomePassword <SecureString>] [-LinuxCredentials <VEORLinuxCredential>] [-SshPort <Int32>] [-ToDateTime <DateTime>] [-File <VEORDatabaseFile[]>] [-TargetPath <String[]>] [-Force <SwitchParameter>] [<CommonParameters>]

Detailed Description

This cmdlet restores a backed-up Oracle database. You can restore an Oracle database to a Windows or a Linux machine.

Parameters

Parameter	Description	Type	Required	Position	Accept Pipeline Input
Database	Specifies an Oracle database that the cmdlet will restore.	Accepts the VEORDatabase object. To get this object, run the Get-VEORDatabase cmdlet.	True	0	True (ByValue)
LinuxCredentials	For restore to a Linux machine. Specifies Linux credentials that the cmdlet will use to connect to a Linux machine.	Accepts the VEORLinuxCredential object. To get this object, run the New-VEORLinuxCredential cmdlet.	True	Named	False
Server	For restore to another server. Specifies the name of the target Oracle server that the cmdlet will restore a database to. Note: Do not provide this parameter if you want to restore to the original server.	String	False	Named	False
OracleHome	For restore to another location. Specifies the target Oracle home path. The cmdlet will restore an Oracle database to the location specified in the Oracle home path. Note: Do not provide this parameter if you want to restore to the original location.	String	False	Named	False
GlobalDatabaseName	For restore to another location. Specifies the global database name. The cmdlet will restore an Oracle database with the specified name. Note: Do not provide this parameter if you want to restore to the original location.	String	False	Named	False
OracleSid	For restore to another location. Specifies target SID for an Oracle database. The cmdlet will restore the database with the specified SID. Note: Do not provide this parameter if you want to restore to the original location.	String	False	Named	False
WindowsCredentials	For restore to a Windows machine. Specifies Windows credentials that the cmdlet will use to connect to a Windows machine.	Accepts the PSCredential object. To get this object, run the Get-Credential cmdlet.	False	Named	False
OracleHomePassword	For restoring Oracle Database 12c or later to a Windows machine. Specifies Oracle home credentials that the cmdlet will use for starting Oracle Services on the guest OS. Note that this parameter is required in case you use the following types of Oracle home User: Existing Windows user New Windows user	SecureString	False	Named	False
ToDateTime	Specifies a point in time within the restore interval of an Oracle database. The cmdlet will restore the database to the state of the specified point in time. Note: Make sure that the value you assign to this parameter is converted to Universal Coordinated Time (UTC).	DateTime	False	Named	False
File	Specifies an array of Oracle database files.	Accepts the VEORDatabaseFile[] object. To get this object, run the Get-VEORDatabaseFile cmdlet.	False	Named	False
TargetPath	Specifies the target path array. The cmdlet will restore the Oracle database files to the locations specified in the array. Note: You must assign a specific file path for each Oracle database file.	String[]	False	Named	False
Force	Defines that the cmdlet will overwrite the existing Oracle database with the database from the backup. Note: The cmdlet will show no prompt before executing the command.	SwitchParameter	False	Named	False
SshPort	For restore to a Linux machine. Specifies the SSH port number that the cmdlet will use to connect to the Linux machine. Default: 22	Int32	False	Named	False

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About CommonParameters section of Microsoft Docs.

Examples

Restore-VEORDatabase Example 1. Restoring Latest State of Oracle Database to Same Server

This example shows how to restore the latest state of an Oracle database to the original server.

$session = Get-VEORRestoreSession

$database = Get-VEORDatabase -Session $session[0] -Name "orcl"

Restore-VEORDatabase -Database $database -Server "Oracle_Server" -Force

Perform the following steps:

Run the Get-VEORRestoreSession cmdlet. Save the result to the $session variable.

The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session. In our example, it is the first restore session in the array.

Run the Get-VEORDatabase cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session. Specify the Name parameter value. Save the result to the $database variable.
Run the Restore-VEORDatabase cmdlet. Set the $database variable as the Database parameter value. Specify the Server parameter value. Provide the Force parameter to overwrite the database on original server with the restored database.

Restore-VEORDatabase Example 2. Restoring Oracle Database to Another Windows Server

This example shows how to restore an Oracle database to another Windows machine with Oracle.

$session = Get-VEORRestoreSession

$database = Get-VEORDatabase -Session $session[0] -Name "orcl"

$windowscreds = Get-Credential

$orahomepass = Read-Host -Prompt "Enter your password" -AsSecureString

$pit = Get-Date -Date "2024-02-25 15:00:00"

$pitutc = $pit.ToUniversalTime()

Restore-VEORDatabase -Database $database -WindowsCredentials $windowscreds -Server "Oracle_Server" -OracleHome "C:\app\Administrator\product\19.0.0.\dbhome_1" -OracleHomePassword $orahomepass -GlobalDatabaseName "orcl_res.tech.local" -OracleSid "orcl" -ToDateTime $pitutc

Perform the following steps:

Run the Get-VEORRestoreSession cmdlet. Save the result to the $session variable.

The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session. In our example, it is the first restore session in the array.

Run the Get-VEORDatabase cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session. Specify the Name parameter value. Save the result to the $database variable.
Run the Get-Credential cmdlet to create a credential object. Enter the credentials that will be used for authenticating to the target Windows machine. Save the result to the $windowscreds variable.
Run the Read-Host cmdlet. Specify the Prompt parameter value. Provide the AsSecureString parameter. Save the result to the $orahomepass variable.
Run the Get-Date cmdlet and specify the date and time of the point in time state that you want to restore your database to. Save the result to the $pit variable.
Convert the $pit variable to the UTC format using the ToUniversalTime() method. Save the result to the $pitutc variable.

Note that you can use the Get-VEORDatabaseRestoreInterval cmdlet to get the restore interval of the necessary database in UTC.

Run the Restore-VEORDatabase cmdlet. Specify the following settings:

Set the $database variable as the Database parameter value.
Set the $windowscreds variable as the WindowsCredentials parameter value.
Specify the Server parameter value.
Specify the OracleHome parameter value.
Set the $orahomepass variable as the OracleHomePassword parameter value.
Specify the GlobalDatabaseName parameter value.
Specify the OracleSid parameter value.
Set the $pitutc variable as the ToDateTime parameter value.

Restore-VEORDatabase Example 3. Restoring Oracle Database to Another Linux Server

This example shows how to restore an Oracle database to another Linux machine with Oracle.

$session = Get-VEORRestoreSession

$database = Get-VEORDatabase -Session $session[0] -Name "orcl"

$securepassword = Read-Host -Prompt "Enter password" -AsSecureString

$linuxcreds = New-VEORLinuxCredential -Account "root" -Password $securepassword

$pit = Get-Date -Date "2024-02-24 15:00:00"

$pitutc = $pit.ToUniversalTime()

Restore-VEORDatabase -Database $database -LinuxCredentials $linuxcreds -Server "linorcl01" -OracleHome "/u01/app/oracle/product/19.0.0/dbhome_1/" -GlobalDatabaseName "orcl_res.tech.local" -OracleSid "orcl" -ToDateTime $pitutc -SshPort 26

Perform the following steps:

Run the Get-VEORRestoreSession cmdlet. Save the result to the $session variable.

The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session. In our example, it is the first restore session in the array.

Run the Get-VEORDatabase cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session. Specify the Name parameter value. Save the result to the $database variable.
Run the Read-Host cmdlet. Specify the Prompt parameter value. Provide the AsSecureString parameter. Save the result to the $securepassword variable.
Run the New-VEORLinuxCredential cmdlet. Specify the Account parameter value. Set the $securepassword variable as the Password parameter value. Save the result to the $linuxcreds variable.
Run the Get-Date cmdlet and specify the date and time of the point in time state that you want to restore your database to. Save the result to the $pit variable.
Convert the $pit variable to the UTC format using the ToUniversalTime() method. Save the result to the $pitutc variable.

Note that you can use the Get-VEORDatabaseRestoreInterval cmdlet to get the restore interval of the necessary database in UTC.

Run the Restore-VEORDatabase cmdlet. Specify the following settings:

Set the $database variable as the Database parameter value.
Set the $linuxcreds variable as the LinuxCredentials parameter value.
Specify the Server parameter value.
Specify the OracleHome parameter value.
Specify the GlobalDatabaseName parameter value.
Specify the OracleSid parameter value.
Set the $pitutc variable as the ToDateTime parameter value.
Specify the SshPort parameter value.

Related Commands