ACTIVE DATABASE DUPLICATION

posted Feb 1, 2012, 6:40 PM by Sachchida Ojha   [ updated Feb 2, 2012, 1:40 AM ]
With Oracle database 11G you don't even need a current backup to duplicate your database, and you don't need to worry about having to move copies of your backups or shared drives! What makes this possible is " ACTIVE DATABASE DUPLICATION".

ACTIVE DATABASE DUPLICATION can be done on both the local box and over the network. We will explain the "over the network" to  add more complexity.
 
Steps for active database duplication over the network:

1. Preparing the AUXILIARY instance on the remote node

  • Install Oracle 11G on the remote HOST if not installed
  • Create the Oracle database directory structures
  • Create the password file for AUXILIARY instance
  • Configure networking for the AUXILIARY instance
  • Create the parameter file for AUXILIARY instance
  • Start the AUXILIARY instance

2. Duplicate the database

$rman target / auxiliary=sys/password@remotedb

Once successfully connected

RMAN>DUPLICATE TARGET DATABASE to auxdb FROM ACTIVE DATABASE
SPFILE NOFILENAMECHECK;



Comments