Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cannot open resetlogs after recover
"Howard J. Rogers" <hjr_at_dizwell.com> a écrit dans le message de
news:opscm409oi3d8uqx_at_shostakovich.dizwell.com...
> On Thu, 12 Aug 2004 16:42:23 -0400, Syltrem <syltremzulu_at_videotron.ca>
> wrote:
>
> > You have to roll forward further in time than '2004-08-06:12:00:00'
> > Your system.dbf datafile has a change number at a later point in time
>
> It has nothing, necessarily, to do with the system datafile.
>
> Try a little experiement. Take a fresh backup. Do some transactions. Drop
> a table. Restore all data files apart from, say, USERS01.DBF, and try an
> incomplete recovery. The error message will report that File 1 needs more
> recovery to be consistent. It doesn't, of course. The problem is that
> USERS is ahead of where all the other data files have been rolled forward
> to... but that is seen by the database as a problem with the first file
> which is out of synch with something else... which will always be file 1.
>
> The only problem here therefore is almost certainly (but I won't bet my
> life on it!) that he missed restoring some of the data files to the new
> machine.
>
> Regards
> HJR
>
>
As always, this shows how good a teacher you are. Good explanation. Thanks for pointing this out.
-- Syltrem OpenVMS 7.3-1 + Oracle 8.1.7.4 http://pages.infinit.net/syltrem (OpenVMS related web site, en français) ---zulu is not in my email address---Received on Fri Aug 13 2004 - 07:50:43 CDT