AKA Easy duplication
Duplication is easier then ever if you have backups of your source to disk that is mounted to the auxiliary database server. No connection to your source and no connection to your RMAN catalog are both positive factors.
Other duplication methods
Backup Duplication from Media
Source database – The source database instance is the instance that will be duplicated.
Auxiliary database – The database instance associated with the duplicate database is called the auxiliary instance.
- You have an auxiliary (development or test) instance running
- Both the source and the auxiliary database servers have the backup directory mounted in a fashion that allows the auxiliary database access to the source backups
- The auxiliary database server has enough space and memory for a duplicate of the source
Let's do it.
If you are running OEM on the Auxiliary instance, shut it down.
# emctl stop dbconsole
Stopping Oracle Enterprise Manager 11g Database Control ...
Login to your Auxiliary instance shut it down.
SQL> select name from v$database;
SQL> shutdown immediate;
ORACLE instance shut down.
Delete all archive log directories and archive log files.
# rm -rf 2013*