RMAN or HOT Cloning Steps of Database

 

RMAN Cloning in 10g :-

1.Create same(target) tree structure in clone server

2. windows: c:\>set oracle_sid=<clone db name>

Or

Linux $ export ORACLE_SID=<clone db name>

3.create pwd file

Windows :c:\>orapwd file=%ORACLE_HOME%\database\PWD<clonename>.ora password=sys

Linux:$orapwd file=$ORACLE_HOME/dbs/orapw<db name> password=sys

4.copy the target pfile and past clone server and edit name and add the db_file_name_convert, log_file_name_convert ..

5.Configure TNS and listener and checking the status use the command of ping

6.startup pfile nomount

{

7.open new terminal

8. $export ORACLE_SID=<target db name>

9.rman target

10.RMAN>backup database;

11.RMAN>backup current controlfile;

12. RMAN>backup archivelog all;

RMAN>connect auxiliary username/pwd@<clone net service name>;

RMAN>duplicate target database to ‘<clone db name>’;

Take time for minimum 1 ½ hr

}

OR

{

13. open new terminal

14. $export ORACLE_SID=<clone db>

15.rman target username/pwd@<net service name (target)> auxiliary /

16.RMAN>duplicate target database to ‘<clone name in caps>’;

Take time for minimum 1 ½ hr or after restore controlfile and datafile give ctl+c

}

17. shut immediate for target db and copy and past archivelog files

18.shu immediate for clone

19.startup mount clone

20. alter database open resetlogs; in clone

21.alter database open; in clone

 

 

Thanks

Srini