RECOVERY FAILS WITH ORA-00308 ORA-27037 WITHOUT PAUSING TO ENTER ARCHIVE LOG
(Doc ID 417577.1)
Last updated on JULY 09, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.2.0.2 [Release 9.2 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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 : /<path>/arch_1_5379.dbf
ORA-00280: change 9137878755498 for thread 1 is in sequence #5379
ORA-00308: cannot open archived log '/<path>/arch_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: '/<path>/system01.dbf'
NOTE: You will see above that recovery suggests ‘/<path>/arch_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.
ORA-00279: change 9137878755498 generated at 02/22/2007 14:55:06 needed for thread 1
ORA-00289: suggestion : /<path>/arch_1_5379.dbf
ORA-00280: change 9137878755498 for thread 1 is in sequence #5379
ORA-00308: cannot open archived log '/<path>/arch_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: '/<path>/system01.dbf'
NOTE: You will see above that recovery suggests ‘/<path>/arch_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 |