Reviewing Oracle RMAN Parameters

Updated

Review RMAN parameters and modify them for your environment.

Procedure

  • Review the following RMAN parameters and verify if they are required in your environment.

    • SBT_LIBRARY

      Specify the SBT_LIBRARY parameter to direct to the Oracle Agent's SBT library during channel allocation and configuration.

      Note: Run the <software_installation_path>/iDataAgent/Ora_install.sh script to create the libobk.so link. This creates a symbolic link and does not pass the SBT_LIBRARY parameter in RMAN script. For more information on running the Ora_install.sh script, see Relinking SBT Library.

    • CvClientName

      This parameter is required in a clustered environment. Set the CvClientName parameter to the virtual client name in the CommCell Console when an Oracle Instance is running on a virtual machine in clustered environment. The parameter is optional in a non-clustered environment.

    • RMAN Retention

      To retain the data using the RMAN retention policy settings, configure the retention rules in the CommCell Console to infinite and set the RMAN retention policy. For more information, see Setting the Oracle RMAN Retention Policy.

    • Number of channels in the RMAN script

      Each allocate channel command in an RMAN script gets translated into a backup stream in the Media Manager. Allocate the optimum number of channels for resources to meet the backup window requirements.

    • RMAN block size

      Specify the block size for backup and restore used in allocate channel PARMS and the CvOraSbtParams parameter. If you do not include this parameter, RMAN uses the default block size value for backup and restores.

      An Oracle database administrator can use Oracle RMAN scripts to backup data using multi-stream backups. RMAN scripts can contain the FILESPERSET and BLOCKSIZE parameters to optimize their backup usage.

    • FILESPERSET

      Best Practice: Set the FILESPERSET parameter to a value between 4 and 8 so that the Oracle backups create identical backup images across the backups, which provides a greater deduplication ratio (the default is 8). The RMAN BLOCKSIZE parameter is set to a default of 1024K. When you run command line operation use this value for best deduplication and consistency with CommCell Console scheduled backups.