Re: Recover db with missing redo logs....

River wrote:
>
> Is recovering from on-line backup datafiles the only way??
> (BTW, will that be ALL datafiles copies??) Since
> ours is a warehouse database (over 150 Gigs), that's why
> we don't care about the transactions in the missing
> redo log files. Is there a way to just tell the database to
> "ignore" the missing redo log file??
>
> Thanks again....
>
> River
>

Look at the ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP n;

Try this on a test database first to see if it does what you want! Let us know what you find.

> "John P. Higgins" <jh33378nospam_at_deere.com> wrote:
> >
> >Sure!
> >
> >Restore a prior backup: datafiles and archive log files.
> >svrmgrl
> >connect internal
> >startup mount
> >recover database until cancel
> >
> >Watch the prompts. When Oracle asks for the missing file, enter CANCEL.
> >
> >alter database open resetlogs;
> >
> >shutdown
> >cold backup
> >startup
Received on Mon Nov 24 1997 - 00:00:00 CST