RMAN Example: Duplicating Oracle RAC Databases

Duplicate an Oracle RAC RMAN database.

Before You Begin

1. If you run the RMAN script on a UNIX environment, use PARMS in the Allocate Channel Command.

2. To redirect data files, specify the DB_FILE_NAME_CONVERT init parameter in the PFILE.

Procedure

1. Set the number of automatic channels for a specific device type by using the CONFIGURE DEVICE TYPE ... PARALLELISM command.

    
   CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM number_of_automatic_channels
    BACKUP TYPE TO BACKUPSET;

2. On the RMAN command line, run the following sample script, substituting any required or optional Oracle SBT parameters.

   If you duplicate the database to a computer that is not part of the Oracle RAC pseudo client, set the CVOraRacDBClientName parameter to a client that is part of the Oracle RAC pseudo-client.

   For information on required and optional SBT parameters, see SBT Parameters.

    
   rman target account/password@servicename auxiliary account/password@servicename << EOF 
   run 
   { 
   allocate auxiliary channel ch1 type 'sbt_tape'
   PARMS="SBT_LIBRARY=/oracle/commvault/Base/libobk.so, BLKSIZE=262144, 
   ENV=(CvClientName=client_name, CVOraRacDBClientName=rac_node, CVOraSID=oracle_SID,CVOraRacDBName=asmdb)"
   TRACE 2; 
   duplicate target database to oracle_SID 
   PFILE= pfile_location/pfile
   SKIP TABLESPACE 'table_name' 
   nofilenamecheck; 
   } 
   EOF

Example

rman target sys/sys@asmdb1 auxiliary sys/sys@dupdb << EOF 
run 
{ 
allocate auxiliary channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/oracle/commvault/Base/libobk.so, BLKSIZE=262144, 
ENV=(CvClientName=dbserve5, CVOraRacDBClientName=dbserve10, CVOraSID=dupdb,CVOraRacDBName=asmdb)"
TRACE 2; 
duplicate target database to dupdb 
PFILE= /oracle/oracle10g/dbs/initdupdb.ora 
SKIP TABLESPACE 'DBTEAM' 
nofilenamecheck; 
} 
EOF