question regarding log_archive_dest
edited Jan 8, 2012 10:33PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 comment
Hii have simple question regarding data guard.in a production with 2 standby (physical)
i have set below parameters :
alter system set log_archive_dest_1='location=+DATAGRP/prm/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prm' scope=both;
SQL> alter system set log_archive_dest_2='service=std1 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=std1' scope=both;
SQL> alter system set log_archive_dest_3='service=std2 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=std2' scope=both;
now my question is in the second standby db (std2) should i have to set log_archive_dest_2 or log_archive_dest_3 to point to primary db ?
i have set below parameters :
alter system set log_archive_dest_1='location=+DATAGRP/prm/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prm' scope=both;
SQL> alter system set log_archive_dest_2='service=std1 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=std1' scope=both;
SQL> alter system set log_archive_dest_3='service=std2 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=std2' scope=both;
now my question is in the second standby db (std2) should i have to set log_archive_dest_2 or log_archive_dest_3 to point to primary db ?
0