Re: Strange sequence of error messages during recovery

On Oct 24, 7: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.

I think what you are seeing is evidence that Oracle knows where the next thread will continue, if it had been continued. See metalink Note:161742.1 for a similar example.

Look at the max values of columns named like change# in v $archived_log. Think about what that is a view of.

jg

--
@home.com is bogus.
Bad code!  Bad, bad code!  http://catless.ncl.ac.uk/Risks/25.42.html#subj1