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

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.