Wednesday, August 15, 2018

Creating Standby Database using Duplicate from Active Database


I already have articles written about how to create dataguard and creating dataguard in RAC environment. I used the DUPLICATE DATABASE command using backup, to build the standby database in aforementioned documents. In this article I would provide some tips about building standby database using DUPLICATE with ACTIVE DATABASE option.
Please also refer to this article about duplicate using ACTIVE DATABASE.
Follow all steps same as mentioned in how to create dataguard to build the standby, but remember following points/steps.
  • No need to take and copy backup of primary database to the standby site.
  • Copy password file from the primary database site to the standby database site.
  • Register standby database statically with the listener. It would mean adding following lines in listener.ora file on the standby site, and reload/restart the listener.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = standby_db)
      (ORACLE_HOME =/u01/app/oracle/product/11.2.0.4/dbhome_1)
      (SID_NAME = standby_db)
    )
  )

  • After standby is started in nomount mode, log into the primary and standby/auxiliary, and initiate duplicate.

$rman target sys/<password>@primary_db auxiliary sys/<password>@standby_db

RMAN>DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK;




No comments:

Post a Comment

Popular Posts - All Times