RE: Rollback segments offline on database restart

Yes you have to list all RBS you want online in the rollback_segments parameter if they are
private RBS.

Rick

> -----Original Message-----
> From: Ravi Babu [SMTP:lravibabu_at_hotmail.com]
> Sent: Tuesday, July 11, 2000 9:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Rollback segments offline on database restart
>
> Hello,
> I have created 25 rollback segments. Now whenever i restart the database
> few
> rollback segments are offline. To one procedure i have assigened one
> rollback segment with the help of 'set transaction use ....'. Now whenever
>
> the database is restarted around 5-7 rollback segments are offline, which
> i
> manually have to set it online again. How to get this thing done. Do i
> have
> to use rollback_segments parameter and list out all(more than 25) segments
>
> there?
> Please help.
> Ravi.
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Ravi Babu
> INET: lravibabu_at_hotmail.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).
Received on Tue Jul 11 2000 - 09:09:52 CDT