Clone DB using RMAN Active Database duplication feature !!!

Home »  11g »  Clone DB using RMAN Active Database duplication feature !!!

In this article we will see the steps to clone DB using RMAN Active Database duplication feature. Here, the source and target databases are on different server but sharing same disk groups.

======================================================================================================

 

• Follow below steps to clone database

Here, source and target databases version is 12.1.0.2. Below are the details of source and target databases.

Source DB – RCATDB (2 node RAC DB)
Target DB – ORCLDB (Will be restored as Single Instance DB)

– Create init.ora file and audit trace directory for target DB

$ mkdir -p /u01/app/oracle/admin/ORCLDB/adump

 

– Create temporary directory for TNS_ADMIN

$ mkdir $ORACLE_HOME/network/admin1
$ cd $ORACLE_HOME/network/admin1
$ export TNS_ADMIN=$PWD

 

– Create tnsnames.ora, listener.ora and sqlnet.ora in new TNS_ADMIN directory

For Active Database duplication, we need to register the database in listener. Since at nomount stage database does not get registered dynamically, we have to create a static entry in listener.ora file.

 

– Start the new listener and check tnsping, DB should point to above IP and PORT number

$ lsnrctl start LISTENER1525

$ lsnrctl status LISTENER1525

$ tnsping ORCLDB

 

– Start the target DB in NOMOUNT stage

$ export ORACLE_SID=ORCLDB
$ sqlplus “/ as sysdba”

SQL> startup nomount

 

– Add the entry of target DB in original source server’s tnsnames.ora file

$ cd $ORACLE_HOME/network/admin

$ vi tnsnames.ora

ORCLDB=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.25)(PORT=1525))
)
(CONNECT_DATA=
(SID=ORCLDB)
)
)

Make sure that you are able to connect as SYS user from SOURCE to TARGET and vice versa.

 

– Create below RMAN script on target server

[Save and Exit]

 

– Execute the above script to start cloning process

Monitor the log file for any errors. Rectify and resolve errors if any. If no errors occurred then the database will get cloned. The next step will be to convert the cloned database to RAC since it will restore the database as single instance. You can refer this link to convert the database to RAC.

That’s it, this ends the RMAN Active database duplication process.

======================================================================================================

Tags : ,,, ,

Leave a Reply

Your email address will not be published. Required fields are marked *