Re: RBS01.dbf damaged

Great answer, thanks a lot.

And what if there were active transaction when the database failed (it will become impossible to drop the RBS tablespace) ?

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3a90df65$1_at_news.iprimus.com.au...
> Make sure the init.ora doesn't try to bring online any rollback segments
> contained within the relevant datafile, get the thing to mount stage,
> offline drop the datafile, open the database, create new rollback
> tablespace, create new rollback segments, shutdown, edit init.ora to bring
> new rollback segments online, open.
>
> Regards
> HJR
>
>
> offline drop the
> "Achille Carette" <achyl_at_infonie.be> wrote in message
> news:zEYj6.6358$pa.91224_at_news.chello.be...
> > Backup / recovery testing (Oracle 8.1.6 / NT) :
> >
> > U have a database created using default values (ORCL, etc), wich ran
 during
> > a good time without any problem.
> > Unfortunately, following a power outage, the datafile rbs01.dbf is
 damaged.
> > Of course, u don't have any backup (would be far too easy).
> >
> > How is it possible to open the database ?
> >
> >
>
>
Received on Mon Feb 19 2001 - 03:28:20 CST