Thursday, September 27, 2012

Easy way to clone a ORACLE db

Refer to

http://www.dba-oracle.com/oracle_tips_db_copy.htm 

and

http://dbaforums.org/oracle/index.php?showtopic=2917

if you want to clone a database TEST -> DENEME 
1 take a backup of your controlfile 
2 take online / offline backup of all your datafiles 
3 make a relevant copy of your init.ora file or make changes to you are deneme initora
4 delete your control file, redo logs and datafiles on DENEME
5 move these files from TEST -> DENEME
6 using the back up of control file create the new control file for deneme 
NOTE the database name needs to be changed from TEST -> DENEME with the 
SET Clause and option resetlogs (depending on hot /cold backup)
7 create the redo log files 
8 startup mount 
9 recover the log files until cancel
10 open database

No comments:

Post a Comment