Strange sequence of error messages during recovery

From: Raghuram Devarakonda <>
Date: Fri, 24 Oct 2008 07:30:30 -0700 (PDT)
Message-ID: <>


I am trying to do an incomplete recovery as follows:

"alter database recover automatic from 'C:\logsdir' using backup controlfile until change 2192315;"

which results in the following error messages:

ERROR at line 1:
ORA-00279: change 2169480 generated at 10/22/2008 20:17:28 needed for thread 1
ORA-00289: suggestion : C:\LOGSDIR\ARC00079_0668630851.001
ORA-00280: change 2169480 for thread 1 is in sequence #79
ORA-00278: log file 'C:\LOGSDIR\ARC00079_0668630851.001' no longer
needed for this recovery
ORA-00308: cannot open archived log 'C:\LOGSDIR \ARC00079_0668630851.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified."

If 'C:\LOGSDIR\ARC00079_0668630851.001' is not needed for recovery, why is it being opened (as can be seen in the ORA-00308 error)? Any help is appreciated.


ps. I posted this in Oracle's Database forum as well. In case you have seen it there, sorry for duplication. Received on Fri Oct 24 2008 - 09:30:30 CDT

Original text of this message