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