Re: cannot open resetlogs after recover

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
> If the point of all this is just to move the db to another node, just do
> recover AUTOMATIC UNTIL CANCEL
> When you're out of archiove logs, do CANCEL and try to open the db.
> If it does not work, your're still missing some, and they must be on the
> source machine.
>
> HTH
Received on Thu Aug 12 2004 - 17:35:23 CDT