Active Database Cloning Using RMAN in Oracle 12C

 RMAN(RECOVERY MANAGER):

                             In oracle,RMAN has the ablility to duplicate or clone a database using backup copies or active database using duplicate command to copy all the data in source database.

 

ACTIVE DATABASE DUPLICATION:

                                                                        In this method,RMAN connects the target to the source database and auxiliary to the auxiliary instance.Auxiliary is the

database instance used in the recovery process to perform work of recovery.RMAN copies the live source database over the network on the auxiliary instance.Here

there are no RMAN backup copies are required .

 

ACTIVE DATABASE DUPLICATION STEPS:

 

step1:First copy the source(dev) database pfile to clonedb database

 

make the changes in the pfile for clone db like dbname,db_file_name_convert,log_file_name_convert

 

Step2:create the password file for the clonedb as well as dev database

 

step3: configure listener and service name

 

  eg:SID_DESC =

      (GLOBAL_DBNAME = clone)

      (ORACLE_HOME = D:\oracle\product\11.1.0\db_1)

      (SID_NAME = clone)

    )

 

step4: now add the entries in tnsnames.ora

 

CLONE =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = clone)

    )

  )

 

step5: Now connect with Duplicate Database

 

   eg:

           export ORACLE_SID=clonedb

           sqplus / as sysdba

            startup nomount

 

step6:Now duplicate the target database

 

 

 eg:rman target sys/Pass#123@dev

 

connect auxiliary sys/Pass#123@clonedb

 

duplicate database to 'clonedb' from active database nofilenamecheck;

                                      (or)

duplicate target database to clonedb nofilenamecheck;

 

 

step7:check the duplicate clonedb database

 

sqlplus sys/Pass#123@clonedb nofilenamecheck;

 

PRACTICAL: