Re: Consistent Whole Database Restore

From: <fitzjarrell_at_cox.net>
Date: 21 Sep 2005 22:21:26 -0700
Message-ID: <1127366486.551358.80110@g47g2000cwa.googlegroups.com>

Gump wrote:
> Thanks David.
>
> > That depends entirely upon whether you have your old redo logs or not.
> > Should they be missing you would need to:
> >
> > startup mount;
> > alter database open resetlogs;
> >
> > to recreate the missing redo log files.
>
> I am guessing by "old redo logs" you mean the "online redo logs", not
> archived redo logs.
>
> Assuming I haven't lost any files, I don't need to do a RECOVER
> DATABASE. Correct?

You obviously missed the rest of my post, which answered that question:

| Recover database in this situation is unnecessary as the datafiles are
| consistent and up-to-date with respect to the date of the backup.

David Fitzjarrell Received on Thu Sep 22 2005 - 00:21:26 CDT