SAP on Oracle Backup (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 also used to back up profiles, log files and control files.

    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

    Before you back up the Oracle database with the rman_util parameter, you must install and configure Veeam Plug-in for Oracle RMAN on the SAP on Oracle server.

    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_initODB.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_initODB.sap file:

    1. In the SAP on Oracle server, open the /oracle/ODB/sapprof/veeam_initODB.sap file using a text editor.
    1. Add the following line in the veeam_initODB.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 (RMAN_UTIL) 

    Example: Performing Full Backup with RMAN_UTIL Parameter

    To backup an SAP on Oracle database using RMAN, you must use the brbackup tool with the rman_util parameter and with the defined directory for SBT library.

    brbackup -p $Oracle_HOME/dbs/veeam_initODB.sap -t online -d rman_util -m full -u /

    1. Specify the path to the initialization profile file (veeam_initODB.sap) as the argument for the -p (-profile) parameter.
    2. Specify rman_util as the argument for the -d (-device) parameter. This option defines that the backup will be performed using Oracle RMAN.
    3. Specify online as the argument for the -t (-type) parameter. With this option, BRBACKUP performs backup of the database in the online state.
    4. Specify full as the argument for the -m (-mode) parameter. With this option, BRBACKUP performs backup of files in all tablespaces, control files and redo log files.
    5. Specify / as the argument for the  -u (-user) parameter. With this option BRBACKUP uses the $OPS user to log on to the database.

    For the fill list of BRBACKUP parameters, see the Command Options for BRBACKUP section of the SAP Database Guide: Oracle.

    I want to report a typo

    There is a misspelling right here:

     

    I want to let the Veeam Documentation Team know about that.