My Oracle Support Banner

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 to [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***


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.