Cloning A Database On The Same Server Using Rman Duplicate From Active Database
- by alejandro.vargas
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:
Configure The Network
Create A Password File For The New Database
Create An Init.Ora For The New Database
Create The Admin Directory For The New Database
Shutdown And Startup Mount The Source Database
Startup Nomount The New Database
Connect To The Target (Source) And Auxiliary (New Clone) Databases Using Rman
Execute The Duplicate Command
Remove The Old Pfile
Check The New Database
A step by step example is provided on this file: rman-duplicate-from-active-database.pdf