Re: Strange sequence of error messages during recovery
Date: Mon, 27 Oct 2008 10:44:37 -0700 (PDT)
On Oct 24, 7:30 am, Raghuram Devarakonda <draghu..._at_gmail.com> wrote:
> 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
> 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.
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.
-- @home.com is bogus. Bad code! Bad, bad code! http://catless.ncl.ac.uk/Risks/25.42.html#subj1Received on Mon Oct 27 2008 - 12:44:37 CDT