ORA-00308 And ORA-27037 Were Reported In The Alert.log (Doc ID 464134.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 20-Sep-2016***

Symptoms

The below errors were reported in the Alert log . This is not a standby database and the database is not in recovery mode.

Errors in file /oracle/CMP/saptrace/usertrace/cmp_ora_2011164.trc:
ORA-00308: cannot open archived log '/oracle/CMP/oraarch/CMParch1_77453_511022248.dbf'
ORA-27037: unable to obtain file status

There was a structure validation check running (analyze table validate structure) during the time when those errors appeared.

The file mentioned in the error message was saved hours earlier and moved to a tape. The generated trace file cmp_ora_2011164.trc contains dumps of log/archive log files:

DUMP OF REDO FROM FILE '/oracle/CMP/origlogA/log_g15m1.dbf'
Opcodes *.*
DBAs (file#, block#):
(1, 34315)
RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
.................

DUMP OF REDO FROM FILE '/oracle/CMP/oraarch/CMParch1_77454_511022248.dbf'
Opcodes *.*
DBAs (file#, block#):
(1, 34315)
RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
........................
..........
Dumping redo log for archive log /oracle/CMP/oraarch/CMParch1_77453_511022248.dbf
Error 308 occurred while dumping log
ORA-00308: cannot open archived log '/oracle/CMP/oraarch/CMParch1_77453_511022248.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

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