RECOVERY FAILS WITH ORA-00308 ORA-27037 WITHOUT PAUSING TO ENTER ARCHIVE LOG
(Doc ID 417577.1)
Last updated on DECEMBER 05, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2014***
During point in time recovery, Oracle is not pausing to enter an archive log file to apply for recovery. Recovery continues and errors with ORA-00308.
ORA-00279: change 9137878755498 generated at 02/22/2007 14:55:06 needed for thread 1
ORA-00289: suggestion : /db22/Pams25p1/jou/_1_5379.dbf
ORA-00280: change 9137878755498 for thread 1 is in sequence #5379
ORA-00308: cannot open archived log '/db22/Pams25p1/jou/_1_5379.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/db01/Pams25p1/ts/system01_Pams25p1.dbf'
NOTE: You will see above that recovery suggests ‘/db22/Pams25p1/jou/_1_5379.dbf, which is this case is the current online redo log. However, the recover process does not pause to enter and apply the archive. The recovery process simply continues and errors with ORA-00308.
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