RMAN Active Database Cloning: 11g New feature

RMAN Active Database Cloning: 11g New feature

               Target DB                                                                 Auxiliary DB  

 192.168.1.100                                                             192.168.1.101

  PROD                                                                          TEST

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

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

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> duplicate target database to test from active database;

 èDUPLICATE TARGET DATABASE TO test FROM ACTIVE DATABASE PASSWORD FILE SPFILE    NOFILENAMECHECK;(Don’t check directory structure – what u mention in dbfilenameconvert that can be take)

èDUPLICATE DATABASE TO test UNTIL TIME “TO_DATE (‘11/01/2013 14:00:00’,’MM/DD/YYYY HH24:MI:SS’) SPFILE BACKUP LOCATION ‘/prod_backups’ NOFILENAMECHECK; (In target DB presented spfile to be cloned , and then testDB spfile backup)

RMAN>exit;