RE: Rollbacks online

edit your init<sid>.ora
In it set rollback_segments like this.

rollback_segments = (rbs1,rbs2,rbs3,rbs4)

before this check how many rollback segments you are having from this query

select * from dba_rollback_segs.

and place them all in your rollback_segment parameter except for the system RBS.
After this shutdown and startup your database. This will make all your RBS online.
Or if you don't want to shutdown your database then make them online by firing this query for all of your RBS's. Alter rollback segment rbs1 online;

Vikas
-----Original Message-----
From: Jeff Wiegand [mailto:jwiegand_at_ancept.com] Sent: Thursday, June 01, 2000 11:26 PM
To: Multiple recipients of list ORACLE-L Subject: Rollbacks online

ok. silly question. how do you make sure your rollbacks are online when the database comes up. I thought you specified this in init.ora, but that didn't work.

Is this a good way to manage your rollback segments, or should I run a script when I bring up the database?

Jeff

-- 
Author: Jeff Wiegand
  INET: jwiegand_at_ancept.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).