SAP on Oracle Backup Using RMAN_UTIL

In this article

    The rman_util parameter allows 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

    Important

    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:

    rman_filesperset = 10

    rman_filesperset_arch = 100

    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.
    1. Add the following line in the veeam_initSID.sap file:

    rman_parms = 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so'

    How It 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, deduplicates 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.
    1. BR*Tools launches the Veeam Plug-in for SAP on Oracle services.
    2. BR*Tools start the control data files backup:
    1. Control file, BR*Tools logs are compressed and sent to a backup repository.
    1. 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.

    SAP on Oracle Backup Using RMAN_UTIL