Re: why did this recover scenario fail ?

From your description you had
enough bits to get going again.
It's always a bit hard to get it right
remotely but:

You didn't need to create a new control
file, as far as Oracle was concerned
you had a crashed database which could
have done a normal crash recovery if
half the datafiles had not been missing.

I think you should have mounted the
database, put the datafiles offline
with the offline drop syntax,

    alter database datafile 'xxx' offline drop; so that Oracle wouldn't try to recover them, opened the database and dropped the
relevant tablespaces including contents.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

NeilC wrote in message <38E372FC.C6C7CDE5_at_btinternet.com>...


>Has anyone an explanation of what went wrong with this recovery scenario

>?

>

>Oracle 8.0.5 on NT

>noarchivelog mode

>

>A small test database that had just been created with 5 tablespaces

>(system, temp, rbs, data and indx) was populated with data - all ok.

>Shortly afterwards one of the 2 disks failed. This disk contained the

>temp and indx tablespace and the second members of a set of 4 redo log

>groups and the second of two controlfiles.

>So, I was left with one control file, system, rbs and data tablespaces

>and 4  redo logs.

>As the temp tablespace wasn't needed, and the indx tablespace wasn't

>needed (indexes could be re-created) I thought I might be able to

>re-create the controlfile to only include the 4 redo log members, the

>three tablespaces datafiles and the current control file.

>So, I mounted the database issued a backup controlfile to trace and

>recreated the control file - all seemed to be going well.

>I now thought i'd be able to open the database, reset the redo logs and

>then go about recreating the temp and indx tablespaces. But, when trying

>to open the database, it wanted to do media recovery on the system

>tablespace. I tried an recover database until cancel, but it said that

>the datafile would still require recovery.

>So, disappointedly, I gave up, re-created the DB and reloaded my data.

>What did I do wrong ?

>

>Cheers

>

>Neil