ORA-00314: LOG 404 OF THREAD 4, EXPECTED SEQUENCE# 33808 DOESN'T MATCH 33543 (Doc ID 1077564.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.5 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Sep-2012***
***Checked for relevance on 06-Aug-2014***

Symptoms


Following errors are received when attempting to startup standby or while logs are being applied

ORA-00314: log 404 of thread 4, expected sequence# 33808 doesn't match 33543
ORA-00312: online log 404 thread 4: '+INDEX01/test/onlinelog/group_404.468.703522549'
ORA-00314: log 404 of thread 4, expected sequence# 33808 doesn't match 33543
ORA-00312: online log 404 thread 4: '+DATA01/test/onlinelog/group_404.450.703522549'

Changes

Standby redo is being used.
while archives are being transferred, network outage, instance crash occurred.

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