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.
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:
Post a Comment