My Oracle Support Banner

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 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

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
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.