Re: Help - lost rollback files

I think you can proceed this way.
1) Modify your init.ora and remove the entry for those rollback segments. 2) Mount the database and do
alter database datafile offline drop;
3) May be you have to drop the tablespace also once you open the database. I dont remember exactly.
You wont be able to recover anything, but atleast you can open your database.

Pete wrote:

> I forgot to say.
>
> It's Oracle 7
>
> Cheers
> Pete <peter_bruton_at_yahoo.com> wrote in message
> news:7dac29$fv9$1_at_starburst.uk.insnet.net...
> > hope someone can help. I'm new to DBA stuff, and I've hit a problem. One
> > of my hard drives failed and needed replacing. The disk that failed
> > contains my rollback info and I've discovered to my horror that NTbackup
> > failed to backup anything from that drive (I assume it's because the
> > database was never shutdown). None of the other disks were affected so
> all
> > other datafiles are OK
> >
> > As a result of this Oracle won't start, I'm assuming that this is because
> of
> > the missing files. Is there any way for me to start Oracle without the
> > rollback files and recreate them? Or is there another solution.
> >
> > Thanks for your help
> >
> > Pete
> >
> >
Received on Wed Mar 24 1999 - 13:33:31 CST