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