ORA-03111 in Primary and standby shows ORA-00368 at around same time. (Doc ID 1385098.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Exadata Hardware - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 24-Sep-2013***
***Reviewed for relevance on 13-Jul-2015***

Symptoms

Often the primary alert log shows ORA-03111 like below:

*********************************************************************
WARNING: Detected remote instance standby database network disconnect
WARNING: Current instance standby database disconnect may be required
*********************************************************************
LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3111)
LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Errors in file /u01/app/oracle/diag/rdbms/jmqprd/jmqprd2/trace/jmqprd2_lgwr_4534.trc:
ORA-03111: break received on communication channel
Error 3111 for archive log file 7 to 'jmqprdsb'


and on Standby around same time ,you might notice


CORRUPTION DETECTED: In redo blocks starting at block 4097count 2048 for thread 2 sequence 6960
Deleted Oracle managed file +RECO/jmqprd/archivelog/2011_10_20/thread_2_seq_6960.2777.765039925
Errors in file /u01/app/oracle/diag/rdbms/jmqprd/jmqprd1/trace/jmqprd1_rfs_11705.trc:
ORA-00272: error writing archive log +RECO/jmqprd/archivelog/2011_10_20/thread_2_seq_6960.2777.765039925
ORA-00368: checksum error in redo log block
RFS[4294]: Possible network disconnect with primary database

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms