Re: lost redo logs, but have consitent offline backup

Thanks for all your help.
 What I found worked (was hacking away cuz I wasn't patient enough to wait for a response) was simply removing all of the redo log files from the OS. When I had the logs there a zero byte files oracle complained about bad blocks. So, when I was able to successfully open (with resetlogs option) I also cycled the log writer through each of my three log groups to make sure oracle could see (and write) to them all.
Next time I test a recovery scenario I'll have to be more careful ;). -Jeremy

On Wed, 11 Nov 1998 20:37:14 GMT, wwwebmaster_at_vt.edu wrote:

>I've lost my redo logs but have an offline consitent backup.
>I've restored the control and datafiles to the appropriate locations.
>How do I get oracle to start the instance w/o compliaining about the
>redo logs? I've tried startup force but this doesn't work.
>Error:
>ORA-00313: open failed for members of log group 1 of thread 1
>ORA-00312: online log 1 thread 1: '/usr/data/log1foo.dbf'
>ORA-00312: online log 1 thread 1: '/usr/local/data/log1afoo.dbf'
>TIA
>-Jeremy
Received on Thu Nov 12 1998 - 15:03:10 CST