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 LaurentBob

I suggest you take these steps:

1. Shutdown the database.
2. Edit the init.ora file, removing R01 from the list of active rollback segments (ROLLBACK_SEGMENTS = line).
3. Start the database.
4. Create the rollback segment again.
5. Shutdown the database.
6. Edit the init.ora file, putting R01 back in the line edited in step 2.
7. Start the database again.

This should be enough, unless you're facing some other problem.

'hope this can help. Received on Sat Apr 13 1996 - 00:00:00 CEST