Re: why did this recover scenario fail ?

Sorry, perhaps I should have said, but yes, that is what i did. I edited the trace file to only include those redo log and datafiles that I had.

NeilC

Jason Kratz wrote:
>
> Not sure about the system tablespace but mounting the database and doing a
> backup controlfile to trace would only give you a text version of what your
> system currently had (ie: the temp and index stuff included). unless it was
> edited to not include those things you'd just be recreating a control file
> for the same setup.
>
> Jason
>
> "NeilC" <nospam.neilc-olos_at_btinternet.com> wrote in message
> news: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
  Received on Fri Mar 31 2000 - 00:00:00 CST