2 physical standby databases - after 2 hours log shipping is speratic and both standby nodes are out
edited Sep 20, 2012 1:47AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 2 commentsAnswered
I have a 5 node EE setup as primary on SLES 10, with oracle 10.2.0.4standby database on SLES 10 and 11, running 10.2.0.4.
I'm trying to add a second physical standby database at a new datacenter.
Log shipping works for about 2 hours and both standby db's are being updated, after that log shipping is sporadic and standby's fall behind.
I had update the primary with the below parameter for the new standby.
alter system set log_archive_config='dg_config=(ampfcrm, cm, denver)' scope=both;
alter system set log_archive_dest_3='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=cmproddb4)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=CM_XPT)(INSTANCE_NAME=CM)(SERVER=dedicated)))"','ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=60 db_unique_name="CM" register net_timeout=180 valid_for=(online_logfile,primary_role)' scope=spfile;
I'm trying to add a second physical standby database at a new datacenter.
Log shipping works for about 2 hours and both standby db's are being updated, after that log shipping is sporadic and standby's fall behind.
I had update the primary with the below parameter for the new standby.
alter system set log_archive_config='dg_config=(ampfcrm, cm, denver)' scope=both;
alter system set log_archive_dest_3='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=cmproddb4)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=CM_XPT)(INSTANCE_NAME=CM)(SERVER=dedicated)))"','ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=60 db_unique_name="CM" register net_timeout=180 valid_for=(online_logfile,primary_role)' scope=spfile;
0