Enabling Multiple Oracle RAC Backup Copies

Updated

You can take multiple copies of the data or log backups using RMAN command line. During restores, even if one of the copies is missing or corrupted, the restore operation will automatically failover to the other copy and restore the data.

1.

To use the PARALLELISM option, you need to set the initial parameter in pfile or spfile.

Example:

BACKUP_TAPE_IO_SLAVES=TRUE
    

2.

Configure device type.

Example:

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    

3.

Specify two copies of data.

Example:

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
    

4.

Specify two copies of log backups.

Example:

RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
    

5.

Add the environmental variables for the client and instance on which the iDataAgent is installed.

Example:

allocate channel ch1 type 'sbt_tape'
    

PARMS="<software_install_path>/Base/libobk.so,

ENV=(CvClientName=<client_name>,

CvInstanceName=<instance_name>)"

6.

Once you set the parameters, restart the Oracle database and perform backup operations from the CommCell Console.

Example: To restart the database,

  1. Connect to the database.

    SQL> connect admin/admin@orcl as sysdba
        
    
  2. Shutdown the database.

    SQL> shutdown
        
    
  3. Mount the database.

    SQL> startup mount;
        
    
  4. Change to archivelog mode.

    SQL> alter database archivelog;
        
    
  5. Open the database.

    SQL> alter database open;
        
    

Was this page helpful?