Re: Strange sequence of error messages during recovery

On Oct 24, 10:30 am, Raghuram Devarakonda <draghu..._at_gmail.com> wrote:
> 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.

What version of Oracle?
 RAC or non-RAC?
Which tool is being used to perform recovery? What was done prior to issuing the recovery command? Where did you get the SCN number you are using? Are you sure it is older than the SCN recorded in all database data files in use?

HTH -- Mark D Powell -- Received on Fri Oct 24 2008 - 14:02:23 CDT