Unable to drop rollback segment

[nkakrani]

Hi,

I am unable to drop one RBS tablespace, because it is having some Rollback segment.

I have tried to make these rollback segment offline, even than it is not getting drop that tablespace and rollback segment.

In the Storage manager it is showing rollback segment offline [need to recover].

Please help me how to remove these tablespace and rollback segment.

If it is in existing then there will be any problem in the future.

Thanks in adv.

Naresh

[drishti]

hello,
what error do u get when trying to drop RBS tbsp after making all rollback segments offline.

[aracnid]

1. put offline rbs
2. drop rollback segment
3. drop tablespace rbs

p.s if rbs are current active (within uncomited trasaction) thay will take a while to go offline

[denevge]

If you can not put rbs offline.
--> init.ora : _corrupted_rollback_segments=(rbsname)

shutdown db
add parameter to init.ora. Use the name of the rbs you want to drop.
remove the name of the rbs you want to drop from the 'rollback_segments' parameter.
startup db
drop rbs
shutdown db
remove _corrupted_rollback_segments parameter
startup db
if possible. drop the tablespace that stored the rbs.

Hope this helps
Gert

[nkakrani]

Drishti..

Whenever I am trying to drop tablespace, it is showing rollback segment active.

I have enen made it offline through the sql statement from svrmgrl and it was showing statement processed.

But when we see throught the sql statement through the DBA_ROLLBACK_SEG, it shows that rollback segment online.


Please advise.

naresh

[aracnid]

your rbs is market to go offline (statement processed)
but still takes information (uncomited or rollbacked). So try to see who is the user getting the rollback active (kill if necessary) then your rbs will go realy offline.