Re: Corrupt rollback segments

Hi,

    Thanks for the response, but unfortunately, this did not work either!

As soon as I attempt to drop a tablespace when the database is in exclusive mode, I get the error

drop tablespace RBS including contents
*
ORA-01109: database not open

and again, opening the database and trying to drop the tablespace yields the error:

SVRMGR> drop tablespace rbs including contents; drop tablespace rbs including contents
*
ORA-01548: active rollback segment 'R01' found, terminate dropping tablespace

Cheers

--
Mr. Lab
--
http://www.klingklang.co.uk
http://klingklang.dyndns.org
--
<oratune_at_aol.com> wrote in message news:8mnh6o$sle$1_at_nnrp1.deja.com...


> In article <8ma8vt$3jn$1_at_neptunium.btinternet.com>,

> My thoughts go to shutting down the instance (abort, if necessary),

> then starting the instance nomount:

>

> SVRMGR> startup nomount

>

> Mounting the database in exclusive mode:

>

> SVRMGR> alter database mount exclusive;

>

> Then make an attempt to drop the rollback tablespace, including

> contents:

>

> SVRMGR> drop tablespace RBS including contents;

>

> Presuming all has gone well up to this point create a new RBS

> tablespace with a new datafile:

>

> SVRMGR> create tablespace rbs datafile '...' size ...;

>

> Recreate your rollback segments:

>

> SVRMGR> create rollback segment r01 ...

>

> Open the database:

>

> SVRMGR> alter database open;

>

> Shut down the instance:

>

> SVRMGR> shutdown immediate

>

> Then start the instance normally:

>

> SVRMGR> startup

>

> Once this is accomplished remove the corrupted datafile.

>

> --

> David Fitzjarrell

> Oracle Certified DBA

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.