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

Run the brrestore command with the following parameters:

1. 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 Backint, use util_file. If the backup was created by RMAN, use rman_util.
2. Specify the path to the initialization profile file ($Oracle_HOME/dbs/veeam_initSID.sap) as the argument for the -p (-profile) parameter.
3. Specify last as the argument for the -b (-backup) parameter. With this option, BRRESTORE uses the last successful database backup for the restore.
4. 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.