RECOVERY FAILS WITH ORA-00308 ORA-27037 WITHOUT PAUSING TO ENTER ARCHIVE LOG (Doc ID 417577.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.2.0.2 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2014***



Symptoms

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.

 

SQL> recover database using backup controlfile until cancel ;
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.

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