Oracle Database 11g New Feature - Backup-Based Duplication Without a Target Connection

We have Target Database name as TECH And we are creating a duplicate database using RMAN Auxiliary Instance with name as AUXDB by using the backup location but without making connection to target database but we will be accessing Recovery Catalog DB.

Note :- This practical assume you have same directory structures and it is performed on same server. Just the database name is different so we are converting the path with respect to dbname only.

  1. Check log_mode of Target Database. Target must be in archivelog mode. Otherwise put the database in archivelog mode.
  2. Now create a new database manually or via DBCA say CATDB. Then run the below command on CATDB to set this as the new Recovery Catalog for our Use.
  3. Connect to the newly created Recovery Catalog Via RMAN
  4. Now register your target database (tech) with newly created recovery catalog database (catdb)
  5. On Windows Platform You need to Create a new Instance for auxdb which also creates a password file for the same
  6. Create All the folders in Oracle Folder Structures.
  7. To create a pfile to start the database. You need to open a Notepad and Type db_name=auxdb and save in ORACLE_HOME\database folder and start the instance at nomount stage.
  8. Now run the below command to Duplicate Database without target connection but using Recovery Catalog.
  9. If all steps are done correctly you will have a new database clone created successfully without any connection made to target. But you need recovery manager backup for this scenario and connection to recovery catalog database.


  1. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.


Post a Comment

Popular posts from this blog

Oracle Architecture - Explained In Detailed - Administration I

Oracle Database SQL - Practise - Question - Scott Schema Examples

Step by Step - How to resolve redo log file corruption using ALTER DATABASE CLEAR UNARCHIVED LOGFILE command