Wednesday, 12 August 2015

Adding multiple oracle datagaurd standby database

We got DR site where real time data sync is happening from Production and DR and I got another requirement for building 2nd standby database from the primary data-center.

Steps:

Follow the below link to copy the data from existing DR or build new standby from prod.

<< http://oracletechdba.blogspot.com/2015/05/migrating-oracle-database-using-rman.html >>

Once you are done with the copy or restoration of data for standby below steps needed in the primary database for archive logs to ship.


SQL>alter system set FAL_SERVER=SIDSTD1,SIDSTD2 SCOPE=BOTH sid='*';
SQL>alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(SIDPRD,SIDSTD1,SIDSTD2)'scope=both sid='*';
SQL>alter system set LOG_ARCHIVE_DEST_3='SERVICE=SIDSTD2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=SIDSTD2' SCOPE=BOTH sid='*';
SQL>alter system set LOG_ARCHIVE_DEST_STATE_3=ENABLE SCOPE=BOTH sid='*';

After adding above parameter in PROD then mount the standby2 and start the recovery.

In Standby2:
SQL>shut immediate
SQL>startup mount
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Check the alert log of both primary and standby for archive log shipping and recovery.

No comments: