Restore Oracle Databases

Veeam Plug-In for SAP on Oracle allows you to restore databases using the BRRESTORE tool functionality. When you launch the restore, BRRESTORE restores the selected database from backup files stored on the backup repository.

By default, BRRESTORE uses the initSID.sap initialization profile. Thus, you must specify the -p $Oracle_HOME/dbs/veeam_initSID.sap parameter in the restore commands.

For details on all restore options, see this SAP article.

Example: Performing Full Restore of SAP on Oracle Database

brrestore -d util_file -p $Oracle_HOME/dbs/veeam_initSID.sap -b last -m full

Run the brrestore command with the following parameters:

Depending on which backup you want to restore from, use the util_file or rman_util option as the argument for the -d (-device) parameter:

If the backup was created by SAP Backint, use util_file.
If the backup was created by RMAN, use rman_util.

If you use rman_util, you must specify the ID of the backup you want to restore from in the initialization profile file. To do so, open the initialization profile file ($Oracle_HOME/dbs/veeam_initSID.sap) and specify the backup ID as the parameter for the rman_send command:

rman_send = "srcBackup=<backup_ID>'"

where <backup_ID> is the ID of the backup you want to restore from.

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.

For example:

rman_send = "'srcBackup=665ff3d5-d575-5555-bcf5-b1d369bdf41b'"

After the restore, make sure to delete the rman_send command. Otherwise, all subsequent backup and restore operations will use the specified backup as their source.

Specify the path to the initialization profile file ($Oracle_HOME/dbs/veeam_initSID.sap) as the argument for the -p (-profile) parameter.

Specify last as the argument for the -b (-backup) parameter. With this option, BRRESTORE uses the last successful database backup for the restore.
Specify full as the argument for the -m (-mode) parameter. With this option, BRRESTORE performs restore of files in all tablespaces, control files and redo log files.