Hi guys,
I am testing my Data Guard configuration which has a primary database and a standby database running in Maximum Protection mode and the Broker is configured.
To best of my knowledge, when running in this mode, the primary database will shutdown when the standby database becomes unavailable.
Here's an excerpt from the documentation:
... maximum protection shuts the primary database down rather than allowing it to continue processing transactions that are unprotected.
I have tested that and what happened is that the sessions in the primary database hang, and the primary database doesn't shutdown... it keeps retrying to re-connect to the standby database. I waited for about 6 minutes, and still the primary database is up and trying to re-connect to the standby database. When I started up the Standby database again, the primary database proceeds it operation as normal.
Could anyone please clarify this to me?
Following is the alert log file output when the primary database was trying to re-connect and when it got connected after I started up the standby database:
Sun Jul 03 15:15:47 2016
Error 1034 received logging on to the standby
Sun Jul 03 15:15:47 2016
LGWR: Error 1034 attaching to RFS for reconnect
Sun Jul 03 15:15:49 2016
Error 1034 received logging on to the standby
Sun Jul 03 15:15:49 2016
Errors in file /u01/app/oracle/diag/rdbms/oradb/ORADB/trace/ORADB_arc2_6392.trc:
ORA-01034: ORACLE not available
PING[ARC2]: Heartbeat failed to connect to standby 'oradb_s2'. Error is 1034.
Sun Jul 03 15:15:52 2016
Error 1034 received logging on to the standby
Sun Jul 03 15:15:52 2016
LGWR: Error 1034 attaching to RFS for reconnect
Sun Jul 03 15:15:57 2016
Error 1034 received logging on to the standby
Sun Jul 03 15:15:57 2016
LGWR: Error 1034 attaching to RFS for reconnect
Sun Jul 03 15:16:02 2016
Error 1034 received logging on to the standby
Sun Jul 03 15:16:02 2016
LGWR: Error 1034 attaching to RFS for reconnect
Sun Jul 03 15:16:07 2016
Error 1034 received logging on to the standby
Sun Jul 03 15:16:07 2016
LGWR: Error 1034 attaching to RFS for reconnect
LGWR: Error 1094 attaching to RFS for reconnect
Starting background process NSS2
Sun Jul 03 15:16:18 2016
NSS2 started with pid=47, OS id=1445
Sun Jul 03 15:16:22 2016
LGWR: RFS network connection re-established at host 'oradb_s2'
Sun Jul 03 15:16:22 2016
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';
LGWR: Standby redo logfile selected to archive thread 1 sequence 214
LGWR: Standby redo logfile selected for thread 1 sequence 214 for destination LOG_ARCHIVE_DEST_2
LGWR: RFS destination opened for reconnect at host 'oradb_s2'
Sun Jul 03 15:16:23 2016
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';
Sun Jul 03 15:16:25 2016