Intermittent lost sync between Primary and Standby
edited Mar 21, 2013 5:47AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 14 commentsAnswered
i have recently implemented RAC standby with RAC Primay(10.2.0.4) running on IBM AIX6.1. distance b/w primary and DR is about 10KM. However there is a intermittent loosing sync b/w Primary and Standby, The problem is
Data Guard cannot restore the sync automatically and fix the sequence
gap of redo logs as in the Oracle Data Guard document. Currently we have
to fix the gap manually every days.i have enabled trace by setting below parameter on primary and standby
ALTER SYSTEM SET log_archive_trace=3807;
and alert log of Primary node1 showing this Error
Tue May 29 18:42:16 2012
ARC7: Closing remote archive destination LOG_ARCHIVE_DEST_2: 'teststdby'
ALTER SYSTEM SET log_archive_trace=3807;
and alert log of Primary node1 showing this Error
Tue May 29 18:42:16 2012
ARC7: Closing remote archive destination LOG_ARCHIVE_DEST_2: 'teststdby'
0