Tips & Codes Database Cloning Steps for cloning from hot backup 1. Login to source database and create a control file trace alter database backup controlfile to trace; 2. Login to target database and create a control file trace as well alter database backup controlfile to trace; 3. Copy all datafiles from source to target database server ftp or rcp 4. Copy the control trace file from source database as well 5. Shutdown target database 6. Remove control files and redo log files and datafiles 7. Uncompress all datafiles from source database to the location in source database control file trace Salzburg hotels 8. Change the target database control file trace and use the keyword set instead of reuse. change the database name as well e-g hôtels Pise CREATE CONTROLFILE SET Schwechat hotel rooms DATABASE "DB_NAME" RESETLOGS ARCHIVELOG 9. After creating control file do incompelete recovery of the database recover database until cancel 10. Open the database after recovery alter database open resetlogs; 11. Shutdown database 12. Mount database to stop archiveing Hotels Portugal startup mount alter database noarchivelog; alter databse open; |