RECOVERY FAILS WITH ORA-00308 ORA-27037 WITHOUT PAUSING TO ENTER ARCHIVE LOG
Last updated on OCTOBER 31, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [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.
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