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?

Try to look your initXXX.ora file.
It locates at $ORACLE_HOME/dbs direstory.

(Note: XXX in string initXXX.ora means your $ORACLE_SID, so type env, find ORACLE_SID and then find file initXYZ.ora if the ORACLE_SID=XYZ) In that file try to find string like

   rollback_segment=(r01,r02...
Comment this line (don't forget the number and names of that RBS segments) and restart ORACLE, start SQLDBA (connect internal),

And from menu use

   STORAGE -> ROLLBACK SEGMENT -> CREATE sequence.

Create PUBLIC segments with NAMEs same that you've seen in your initQWERTY.ora file in tablespace RBS.

BUT: First you must create tablespace RBS (or whatever you like) (if it doesn't exists) with plenty of space in it.

Don't mix your rollback segments with working tablespace.

One more thing (before first): maybe your rollback segments are offline?

   Try STORAGE->ROLLBACK SEGMENT->SET ONLINE sequence. Received on Tue Apr 09 1996 - 00:00:00 CEST