Monthly Archives: November 2012

Clone Oracle Database Using Hot Backup

1.First get the details of datafiles and archivelog location that present in the original database using the below command. SQL> Select name from v$datafile; SQL> archive log list; 2.Get the latest SCN by using the below command. SQL> select max(first_change#) … Continue reading

Posted in Oracle | Tagged | 2 Comments

CLONE ORACLE DATABASE WITH COLD BACKUP:

1. Identify and copy the database files With the source database started, identify all of the database’s files. The following query will display all datafiles, tempfiles and redo logs: set lines 100 pages 999 col name format a50 select name, … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment