Steps for RMAN CLONING

on Monday, 21 May 2012

Steps for RMAN CLONING

Step – 1

 Create a new init.ora(parameter file) file for the auxiliary database.  Create physical directories like udump, cdump, bdump.  If your target db datafiles and log files directories are different from source then mention following converters in parameter file

             . DB_file_name_convert

            . LOG_file_name_convert

 Step – 2

 Start the auxiliary db instance in nomount stage.  Target should be in mount or open stage

             Sql> startup nomount

 Step – 3

 Create network files.  Create listener at auxiliary side and tns at catalog

 Step – 4

 Connect to recovery catalog to target database and auxiliary database

             RMAN> connect catalog rman/rman target sys/sys@to-target auxiliary sys/sys@to-auxiliary

 Step – 5

After connecting all three databases take a backup of target database

            RMAN> backup database plus archivelog;

Step – 6

 Issue the RMAN duplicate command OS follows

             RMAN> duplicate target database to AUX (dbname)

 If you use above command, the files are restored to the target database, after which an incomplete recovery is performed and new database is opened with resetlogs command.

0 comments:

Post a Comment