Re: rollback segment doesn't exist

Bob Laurent wrote:
>
> I've tried calling Oracle tech support and spent 20+ minutes on hold
> before someone came on to tell me they'd call me back, so I'm trying
> here.
>
> In svrmgrl, when I try to startup my database, I get the error
> message:
> ORA-01534: rollback segment 'R01' doesn't exist
> Is there anything I can do to re-create this rollback segment?
>
> Thanks.
>
> Bob Laurent

Bob -

To add to Bo's comments... since the database won't come up without the rollback segment and, since you cannot create the rollback segment with the database down, the only solution that I'm aware of is to:

 (1) comment out the offending rollback segment from the init.ora, then 
 (2) startup the database, then
 (3) recreate the missing rollback segment, then
 (4) remove the comment from the init.ora so that next time the instance is started,
     the rollback segment will automatically be brought online.

Of course, you could consider using PUBLIC rollback segments in future. This obviates the need to specify the ROLLBACK_SEGMENTS parameter in your init.ora. If you are running Oracle7, you'll find the pain of managing PUBLIC rollback segments has been greatly reduced when compared to Version 6.

Allan Seabrook

Tel (Cellular) : +27 11 82 800 4344
           Fax : +27 11 313 5126
        E-Mail : seabrook_at_is.co.za 
--------------------------------------------------------------------------