RMAN Database Cloning:

RMAN Database Cloning:

               Target DB                                                                 Auxiliary DB  

 192.168.1.100                                                              192.168.1.101

  PROD                                                                          TEST

 <--------------------------------

    <--------------------------------   

Target DB Server: 

$export ORACLE_SID=PROD

$rman target / catalog rman/rman123@apps123

RMAN> backup database;

RMAN> backup archivelog all;

RMAN> backup current controlfile;

RMAN> backup spfile;

RMAN> resync catalog;

RMAN> exit;

Auxiliary DB Server:

$ mkdir /u01/admin/test

$ cd /u01/admin/test

$mkdir pfile bdump udump cdump create

$mkdir /u01/oradata/test

Target DB Server:

$scp –r $ORACLE_HOME/dbs/initprod.ora oracle@192.168.1.101:/u01/admin/test/pfile

Target DB Server:

$mv /u01/admin/test/pfile/initprod.ora /u01/admin/test/pfile/inittest.ora

$ vi /u01/admin/test/pfile/inittest.ora

      db_unique_name=test

      db_name=test

      control_files=’/u01/oradata/test/control01.ctl’

      background_dump_dest=/u01/admin/test/bdump

      user_dump_dest=/u01/admin/test/udump

      core_dump_dest=/u01/admin/test/cdump

      audit_dump_dest==/u01/admin/test/adump

      db_file_name_convert=(‘/opt/oradata/prod’,’/u01/oradata/test’)

      log_file_name_convert=(‘/opt/oradata/prod’,’/u01/oradata/test’)

$export ORACLE_SID=test

$orapwd file=$ORACLE_HOME/dbs/orapwtest password=sys

$ sqlplus “ / as sysdba”

SQL> startup nomount pfile=’/u01/admin/test/pfile/inittest.ora’;

SQL> create spfile from pfile=’/u01/admin/test/pfile/inittest.ora’;

SQL> shutdown immediate;

SQL> startup nomount;

$cat>> $ORACLE_HOME/network/admin/tnsnames.ora

 test=

      (DESCRIPTION=

          (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521))

            (CONNECT_DATA=

               (SERVICE_NAME=test)

            )

       )

Target DB SERVER:

$cat>> $ORACLE_HOME/network/admin/tnsnames.ora

 test123=

      (DESCRIPTION=

          (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521))

            (CONNECT_DATA=

               (SERVICE_NAME=test)

            )

       )

$ export ORACLE_SID=PROD

$ rman target /

RMAN> connect catalog rman/rman123@apps123

RMAN> connect auxiliary sys/sys@test123

RMAN> run {

                         Set until time to_date(‘2013-Jan-22 10:10:00’);

                         #set until scn 12345;

                         #set until sequence 170;

                         Duplicate target database to test;

                      }

RMAN> exit;