Restore to Another Server
If you want to restore Oracle databases from a Veeam Plug-in backup to another server, see this Oracle article and consider the specifics described in this section.
To restore an Oracle database to another server, use the following commands:
- ALLOCATE CHANNEL. Use this command to manually allocate a channel or channels between RMAN and the database instance. Specify the following parameters:
- Assign an ID for the channel. For example: ch1.
- Specify the SBT_TAPE option for the DEVICE TYPE or TYPE parameter.
- Specify PARMS to define other parameters for the sbt_tape channel.
- Specify which media library must be used for this sbt_tape channel. For Linux or Unix, set the path to the libOracleRMANPlugin.so file as the SBT_LIBRARY. For Windows, set the path to %PROGRAMFILES%\Veeam\VeeamPluginforOracleRMAN\OracleRMANPlugin.dll.
- SEND. Use this command with the srcBackup=BackupID parameter to specify the ID of the backup from which you want to restore a database. For example: "srcBackup=6109d377-93b5-4741-a796-03471d2795cd".
To obtain a backup ID, do the following:
- Specify an authentication method to access the backup created for the original server. For details, see Specifying Authentication Settings.
- Select the backup from which you want to restore a database. For details, see Selecting Backup.
Important |
Consider the following:
|
The following example shows a script for restoring the control file and restoring the Oracle database to another server using the SEND command:
rman TARGET / RUN { ALLOCATE CHANNEL a1 TYPE sbt_tape PARMS "SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so" SEND "srcBackup=6109d377-93b5-4741-a796-03471d2795cd"; SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F_RMAN_AUTOBACKUP.vab'; RESTORE controlfile FROM 'c-4097408439-20200410-00_RMAN_AUTOBACKUP.vab'; } EXIT; |
Consider the following:
- If you do not use the SEND command, Veeam Plug-in will restore data from a backup created for the server on which Veeam Plug-in is currently running instead of restoring data from a backup created on another server.
- For restore to another server, you can use either backups or backup copies of Oracle databases.
- If you perform restore from a backup that was imported to Veeam Backup & Replication, Veeam Plug-in will automatically create the backup job in Veeam Backup & Replication.
- During the restore process, backup operations are not disabled on the Oracle server.
Specifying Authentication Settings
To restore databases to another server, you must specify an authentication method to access the backup created for the original server. Veeam Plug-in for Oracle RMAN supports the following authentication methods to access backups:
- Using credentials of the account under which the backup was created. For more information, see Specifying Credentials.
This option is intended for backups created using Oracle RMAN commands on the Oracle server.
- Using a recovery token. For more information, see Specifying Recovery Token.
This option is intended for backups created using an application backup policy configured in Veeam Backup & Replication. To use this option, a backup administrator must create a recovery token for the backup in Veeam Backup & Replication.
To restore a database to another server, you can specify credentials of a user account under which the backup was created. To do this, do the following:
- Run the following command:
OracleRMANConfigTool --set-auth-data-for-restore |
- Veeam Plug-in will prompt you to select an authentication method to access the backup.
If you want to access the backup using account credentials, the account must meet the following requirements:
- The account must either have the Veeam Backup Administrator, or both the Veeam Backup Operator and Veeam Restore Operator roles. You can also use the account under which the backup was created. For more information on how to assign Veeam Backup & Replication roles, see the Users and Roles section in the Veeam Backup & Replication User Guide.
- The account must have access permissions to the backup repository where the backup is stored. For more information, see Access and Encryption Settings on Repositories.
To access the backup using account credentials, type 1:
Select authentication type or disable the functionality: |
- Veeam Plug-in will prompt you to provide credentials of the user account that under which the backup was created. Enter a user name and password of the account:
Enter username: |
You can restore a database to another server using a recovery token generated in Veeam Backup & Replication and provided to you by a backup administrator. To do this, do the following:
- Run the following command:
OracleRMANConfigTool --set-auth-data-for-restore |
- Veeam Plug-in will prompt you to select an authentication method to access the backup. To access the backup using a recovery token, type 2:
Select authentication type or disable the functionality: |
- Veeam Plug-in will display the fingerprint of the Veeam Backup & Replication server and prompt you to provide a recovery token:
Veeam Backup & Replication server fingerprint: CA4F820F164C02A9AAC75562FC35330A93CDAA3C. |
After you specify authentication settings to access the backup from which you want to restore a database on another server, you can select the backup. To do this, do the following:
- Run the following command:
OracleRMANConfigTool --get-backup-for-restore |
- Veeam Plug-in will display backups available for restore. The list of backups depends on the authentication settings that you specified:
- If you specified credentials of a user account that has the Veeam Backup Administrator or Veeam Restore Operator role assigned in Veeam Backup & Replication, Veeam Plug-in displays all backups that reside in the backup repository. Otherwise, Veeam Plug-in displays backups created under the specified user account.
- If you specified a recovery token, Veeam Plug-in displays backups for which the recovery token was generated.
Select the backup to obtain the backup ID:
Select backup to be used: |