Re: HOWTO Delete a corrupted Rollback Segment

Startup your DB with these (undocumented) parameters as the last 2 lines in initSID.ora (note this is not supported, use at your own risk):

_offline_rollback_segments=(rs2)
_corrupted_rollback_segments=(rs2)

Where rs2 is the name of you corrupted rollback segment. After starting the db try to get rid of the corrupted rollback segment, shutdown, and remove these parmameters from init.ora.

M.Landa

Albert vd Sanden wrote:

> Hello,
> I have a problem on our Oracle 7.3.3 Workgroupserver, it's rapidly
> filling
> the
> orclalrt.log file because of a 'bad block' in Rollbacksegment #2. I
> tried to
> delete
> it by taking it offline, but this doesn't work either because of the
> bad
> block. I called
> Oracle support who suggested a restore. Does anybody have an
> alternative to
> this ?
>
> Thanks you.
>
> Albert vd Sanden, the Netherlands
>
> asanden_at_pi.net
Received on Thu Dec 04 1997 - 00:00:00 CET