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;