Re: Help: Can't remove rollback segment

Andre,

I didn't quite understand your problem. Did you loose the datafile containing the RBS ? I would like to know how to simulate this. ( I hope this is not your production machine. ) This is what I would try doing. Shutdown the database and include the undocumented parameter _offline_rollback_segments=(<list>) in the init<sid>.ora . Start the database and then drop the rollback segments. I have tried this on a test machine and this works. You can also try with _corrupted_rollback_segments=(<list>) . I have not tried this but I believe this marks the specified rollback segments corrupt for the life of the database. Both these methods are not supported. I would suggest taking a backup first before trying these out and then rebuilding the database to prevent any inconsistencies.

Denny

In article <36D2B25D.F484BC9E_at_xmission.com>,   "Andre M. J." <andreas_at_xmission.com> wrote:
> Hi,
> I can't remove corrupted rollback segment (WGS 8.0.3.0.0 on NT 4.0 SP3).
>
> Somebody was using large (1GB) rollback segment by deleting rows from a
> huge table and cross size of the rollback segment.
> The rollback segment has status "Need Recovery". I did try recover -
> didn't help. I can't drop the rollback segment, or
> the table space where it exist. I did create a other table space with
> new rollback segment and put everything off-line i the other where exist
> the corrupted rollback segment.
>
> What to do???
>
> Thanks in advance,
> AMJ
>
>

Denny Koovakattu

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 23 1999 - 20:27:05 CST