Strange sequence of error messages during recovery

From: Raghuram Devarakonda <draghuram_at_gmail.com>
Date: Fri, 24 Oct 2008 07:30:30 -0700 (PDT)
Message-ID: <74294250-3f0b-45ee-a389-0813babd9dce@d1g2000hsg.googlegroups.com>

Hi,

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.

Thanks,
Raghu

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