Disaster Recovery Exercise

Hi all,

I'm just playing with a test database and trying different DR scenarios. My database is in archive log mode.

I'm simulating a total loss of online redo logs. I have only 2 logfiles and I've put both of them on a thumb drive.

I've made a full online / hot backup (ts begin backup; copy dbf; ts end backup). I have all archived redos online.

So far:

1. pulled the thumb drive out (sorry Windows people, but itrs a good way to simulate a disk failure) - so loose online redos
2. shutdown abort
3. startup and try to open, get the error that the redo are unavailable.

Normally here, I'd have to make sure the disk that failed was operational ready for my "reset redos". Then recover the datafiles from backup and do a "recover database until cancel", CANCEL, "open database resetlogs"

But, I want to assume that the drive that failed is totally buggered (dead, kaput etc for the non-English out there :-) ), so I proceed as follows:

d)   add to new redo logs on another drive.
e)   restore dbf from backup
f)    recover database until cancel... RETURN, RETURN, CANCEL (at missing archive redo)

This is where my knowledge lets me down... I wanted to open reset logs, but obviously Oracle wants to re-create the redo logs that was on the dead drive. I tried to drop it, but (again obviously) Oracle complains that its required for recovery.

How do I tell Oracle that I'm trying to do a Point In Time recovery and to force the drop of the lost redo?

Cheers
Tony
PS : Oracle 9.2.0.7 on WinNT
PPS : please no posts about how stupid my setup is. I know that, its just an exercise in DR. Thanks.

--
http://www.freelists.org/webpage/oracle-l