Restore-VEORRMANDatabase

Short Description

Restores an Oracle database backed up with Veeam Plug-in for Oracle RMAN.

Applies to

Veeam Backup & Replication

Product Edition: Enterprise Plus, Veeam Universal License

Syntax

Restore-VEORRMANDatabase [-Database] <VEORRMANDatabase> [-ChannelsNumber <Int32>] [-Server <String>] [-OracleSid <String>] [-OracleHome <String>] [-GlobalDatabaseName <String>] [-ChangeDbId] [-Restore] [-Recover] [-RestoreAndRecover] [-WindowsCredentials <PSCredential>] [-OracleHomePassword <SecureString>] [-SysUserPassword <SecureString>] [-LinuxCredentials <VEORLinuxCredential>] [-SshPort <Int32>] [-ToCurrentPointInTime] [-UntilTime <DateTime>] [-UntilScn <BigInteger>] [-UntilSeq <BigInteger>] [-File <VEORDatabaseFile[]>] [-TargetPath <String[]>] [-SuppressResetLog] [-Force] [-ManualChannelsAllocation] [<CommonParameters>]

Detailed Description

This cmdlet restores an Oracle database backed up with Veeam Plug-in for Oracle RMAN.

Parameters

Parameter

Description

Type

Required

Position

Accept Pipeline Input

Database

Specifies an Oracle database. The cmdlet will start a restore of the specified database.

Accepts the VEORRMANDatabase object. To get this object, run the Get-VEORRMANDatabase cmdlet.

True

0

True (ByValue)

Server

For restore to another server.

Specifies DNS name or IP address of the target server to which the cmdlet will restore an Oracle database.

Note: Do not provide this parameter if you want to restore to the original server.

String

False

Named

False

OracleSid

For restore to another location.

Specifies a new 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

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

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.

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

SysUserPassword

For restore with database authentication.

Specifies the password for the SYS user of the target database.

Note: This parameter is required when OS authentication to Oracle databases is disabled on the target server.

SecureString

False

Named

False

OracleHomePassword

For restoring Oracle Database 12c or later on Windows server.

Specifies Oracle home credentials that the cmdlet will use for starting Oracle Services on the guest OS.

Note: 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

Recover

Defines that the cmdlet will restore the Oracle database to the latest available state.

SwitchParameter

False

Named

False

Restore

Defines that the cmdlet will restore the data files from a specific point in time without applying log files.

SwitchParameter

False

Named

False

RestoreAndRecover

Defines that the cmdlet will restore the data files from a specific point in time and will apply log files.

SwitchParameter

False

Named

False

ToCurrentPointInTime

Defines that the cmdlet will restore the data from the latest available point in time.

SwitchParameter

False

Named

False

UntilScn

Specifies the System Change Number (SCN). The cmdlet will restore the database from a consistent point.

BigInteger

False

Named

False

UntilSeq

Specifies the sequence from which the cmdlet will restore the database.

BigInteger

False

Named

False

UntilTime

Specifies the date and time from which the cmdlet will restore the database.

DateTime

False

Named

False

ChangeDbId

For restore to another location.

Defines that the cmdlet will generate a new database ID.

If you omit this parameter, the database will be restored with the current ID.

Note: The command will not run if you use this parameter together with the SuppressResetLog parameter.

SwitchParameter

False

Named

False

File

Specifies an array of Oracle database files.

Accepts the VEORRMANDatabaseFile[] object. To get this object, run the Get-VEORRMANDatabaseFile cmdlet.

False

Named

False

ChannelsNumber

Specifies the number of channels used to restore Oracle databases.

By default, the cmdlet will use the default channel configuration, specified in the Veeam Plug-in for Oracle RMAN settings.

Int32

False

Named

False

SuppressResetLog

Defines that Veeam Plug-in for Oracle RMAN will not run the ALTER DATABASE OPEN RESETLOG command after recovery or restore operations.

Note: Do not provide this parameter if you run the script with the following parameters:

  • OracleHome
  • OracleSid
  • GlobalDatabaseName
  • ChangeDBID

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.

Int32

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

ManualChannelsAllocation

This parameter is deprecated. Use the ChannelsNumber parameter instead.

SwitchParameter

False

Named

False

<CommonParameters>

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

Output Object

None.

Examples

Restore-VEORRMANDatabaseExample 1. Restoring Oracle Database to Another Location

Restore-VEORRMANDatabaseExample 2. Restoring Oracle Database to Linux Server to the Latest Available State

Restore-VEORRMANDatabaseExample 3. Restoring Oracle Database to Windows Server With Database Authentication

Related Commands

Page updated 3/25/2025

Page content applies to build 12.3.1.1139