ora-314....does not match 0 on primary database with standby using the same storage (Doc ID 376261.1)

Last updated on NOVEMBER 23, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 23-Nov-2011***

Symptoms

ora-314 can occur on primary database with physical standby using the same storage

Sat Jul 8 14:35:19 2006
Errors in file /u11/admin/PEASY/bdump/peasy1_lgwr_5869.trc:
ORA-00314: log 1 of thread 1, expected sequence# 202 doesn't match 0
ORA-00312: online log 1 thread 1: '/u11/oradata/PEASY/redo01.log'
Sat Jul 8 14:35:19 2006
Errors in file /u11/admin/PEASY/bdump/peasy1_lgwr_5869.trc:
ORA-00314: log 1 of thread 1, expected sequence# 202 doesn't match 0
ORA-00312: online log 1 thread 1: '/u11/oradata/PEASY/redo01.log'
Sat Jul 8 14:35:19 2006
LGWR: terminating instance due to error 314

Examination of the logfile on the primary database shows that the logfile contents have been "cleared" i.e:-

0002000 2201 0000 0002 0000 0000 0000 8000 a203
0002020 0000 0000 0000 0000 0000 0000 0000 0000
*
0003000 2201 0000 0003 0000 0000 0000 8000 a202
0003020 0000 0000 0000 0000 0000 0000 0000 0000
*
0004000 2201 0000 0004 0000 0000 0000 8000 a205
0004020 0000 0000 0000 0000 0000 0000 0000 0000

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