Re: lost redo logs, but have consitent offline backup

On Thu, 12 Nov 1998, Chuck Hamilton wrote:
> >
> >in a offline backup you must include also all Online-Redologs, so that
> >you do not have a backup now. You can now only recreate the database and
> >an export file import in it.
>
> While it's true that an offline backup should include data files,
> control files, and redo log files, it's *not* true that you can't
> recover the database. It can be recovered quite easily.
>
> . Restore the data files and control files.
> . Bring the database up to the mount stage with STARTUP MOUNT
> . Drop and recreate each logfile group with:
> ALTER DATABASE DROP LOGFILE GROUP x
> ALTER DATABASE ADD LOGFILE GROUP x
> . When you get to the current log which is the one it won't let you
> drop, do ALTER DATABASE CLEAR LOGFILE GROUP.
> . Open the database with ALTER DATABASE OPEN;

Actually, you are both wrong. There is no reason to back up the online redologs of a database that was backed up cold after a normal or immediate shutdown. All the user needs to do after restoring the datafiles, controlfile, and parameter files, is ALTER DATABASE OPEN RESETLOGS; and the redologs will reinitialize.

Good luck,
--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Thu Nov 12 1998 - 14:36:43 CST