Alejandro Vargas' Blog

  • RMAN
    March 20, 2010

Cloning A Database On The Same Server Using Rman Duplicate From Active Database

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

To clone a database using Rman we used to require an existing Rman backup, on 11g we can clone databases using the "from active" database option.

In this case we do not require an existing backup, the active datafiles will be used as the source for the clone.

In order to clone with the source database open it must be on archivelog mode. Otherwise we can make the clone mounting the source database, as shown in this example.

These are the steps required to complete the clone:

  1. Configure The Network

  2. Create A Password File For The New Database

  3. Create An Init.Ora For The New Database

  4. Create The Admin Directory For The New Database

  5. Shutdown And Startup Mount The Source Database

  6. Startup Nomount The New Database

  7. Connect To The Target (Source) And Auxiliary (New Clone) Databases Using Rman

  8. Execute The Duplicate Command

  9. Remove The Old Pfile

  10. Check The New Database

A step by step example is provided on this file:


Join the discussion

Comments ( 1 )
  • Paul Alsemgeest Monday, August 2, 2010
    Cloning is also very easy with the Oracle Enterprise Manager grid control. With just a few clicks a cloning job is created. On a small database (<5Gb) it will be ready in less than ten minutes.
    Optionally, a post-cloning job to anonimize data ('Data Masking') can be executed in the same run.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.