SAP on Oracle Backup Using RMAN_UTIL

The rman_util parameter allows you to back up Oracle databases using Oracle RMAN in combination with Veeam Plug-in for Oracle RMAN. BACKINT provides an interface for Veeam Plug-in for Oracle RMAN and is used to back up profiles, log files, control files and to perform incremental backups of databases.

For full description of the rman_util parameter, see RMAN Backup with an External Backup Library.

In the Veeam Backup & Replication console, the rman_util backup operation will create two backup jobs: Veeam Plug-in for Oracle RMAN backup job for database file backups and another Veeam Plug-in for SAP on Oracle backup job that backups up BR*Tools control data files. Note that if you want to create a backup copy job for SAP on Oracle database, make sure that you have added both jobs to the backup copy job.

Prerequisites

When you perform the backup using the RMAN_UTIL, RMAN_STAGE or RMAN_DISK parameter, by default, BR*Tools creates one backup set for each log or datafile. This means that every backup piece will contain only one file. This results in a large amount of backup files and significantly slows down backup and restore processes. To avoid this problem, do the following:

1. In the SAP on Oracle server, open the /oracle/ODB/sapprof/veeam_initSID.sap file using a text editor.
2. Change the default values for the following parameters:

For example: set the rman_filesperset value to 10 for datafiles and the rman_filesperset_arch value to 100 for logs.

Also, you must add the SBT_LIBRARY directory to the rman_parms setting in the veeam_initSID.sap file:

1. In the SAP on Oracle server, open the /oracle/ODB/sapprof/veeam_initSID.sap file using a text editor.

2. Add the following line in the veeam_initSID.sap file:

How SAP on Oracle Backup Using RMAN_UTIL Works

When you launch the BRBACKUP or BRARCHIVE tool with the RMAN_UTIL parameter, the following happens:

1. SAP BR*Tools launches the RMAN backup script.
2. Oracle RMAN launches Veeam Plug-in for Oracle RMAN services.
3. Oracle RMAN starts the backup process:

1. Veeam Plug-in compresses database backup files or redo logs and sends them to the target backup repository through one or multiple channels.
2. Veeam Plug-in for Oracle RMAN connects to Veeam Backup & Replication and creates a backup job object that shows the job progress and logs.

4. BR*Tools launches the Veeam Plug-in for SAP on Oracle services.
5. BR*Tools start the control data files backup:

1. Control file, BR*Tools logs are compressed and sent to a backup repository.

2. Veeam Plug-in for SAP on Oracle connects to Veeam Backup & Replication and creates a backup job object that shows the job progress and logs.