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

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

"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 Sun Nov 23 1997 - 00:00:00 CST