This is an archive version of the document. To get the most up-to-date information, see the current version.

Restore to Another Server

If you want to restore Oracle databases from a Veeam Plug-in backup to another server, follow instructions in the Restoring a Database on a New Host section of Oracle's Database Backup and Recovery User's Guide and mind the specifics described in this section.

Restore from Backup to Another Server

After you allocate channels, you must use the SEND command with the srcSrv=originalServerName parameter, where originalServerName is the hostname of the protected server. In case of RAC, use the cluster SCAN name as originalServerName.

TipS

Mind the following:

Veeam Plug-in backup job name contains the name of the original server. You can find out what to use as originalServerName if you look at the first part of the Veeam Plug-in backup job name.
The ALLOCATE CHANNEL and SEND commands must be issued only within a RUN block for a specific restore operation.

Example of a script to restore the control file and restore 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 "srcSrv=server01";
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;

Use the ALLOCATE CHANNEL 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.
Use the SEND command to specify the original server hostname (the srcSrv parameter). For example: "srcSrv=server01".

Restore from Backup Copy to Another Server

If you want to restore a database from a backup copy to another server, do the following:

On the Oracle server, go to the \Veeam\VeeamPluginforOracleRMAN folder (/opt/veeam/VeeamPluginforOracleRMAN/ for Linux OS).
Open the veeam_config.xml file with a text editor.
Change the <PluginParameters /> line as follows:

For a standalone Oracle Server:

For Oracle RAC:

Important

Mind the following:

Veeam Plug-in for Oracle RMAN must be installed and configured on the target server.
Before you perform any other backup or restore job, revert back the changes in the veeam_config.xml file. The default configuration is: <PluginParameters />

Enable the restore from backup copy option, as described in Restore from Backup Copy.
Perform the restore.

rman TARGET /

RUN {

ALLOCATE CHANNEL a1 TYPE sbt_tape PARMS "SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so";

RESTORE DATABASE;

RECOVER DATABASE;

}

EXIT;