Active Database duplication

Oracle 11g introduced the ability to create duplicate databases directly without the need for a backup. This is known as active database duplication. The process is similar to the backup-based duplication

• You don't need a backup of the source system, but it does have to be in archive mode
• The passwords in the password files must match for both servers
• Both the source and destination database servers require a "tnsnames.ora" entry for the destination database
• The destination server requires static listener configuration in a "listener.ora" file
  SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
        (GLOBAL_DBNAME = DB11G.WORLD)
        (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
        (SID_NAME = DB11G)
      )
    )
  
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ol5-112-dup2.localdomain)(PORT = 1521))
      )
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
    )

The command are

RMAN > DUPLICATE DATABASE TO DB11G   FROM ACTIVE DATABASE   SPFILE   NOFILENAMECHECK;

To create a standby database from active database files:

DUPLICATE TARGET DATABASE   FOR STANDBY   FROM ACTIVE DATABASE   DORECOVER   SPFILE     SET "db_unique_name"="foou" COMMENT ''Is a duplicate''     SET LOG_ARCHIVE_DEST_2="service=inst3 ASYNC REGISTER      VALID_FOR=(online_logfile,primary_role)"     SET FAL_CLIENT="inst3" COMMENT "Is standby"     SET FAL_SERVER="inst1" COMMENT "Is primary"   NOFILENAMECHECK