Re: ROLLBACK_SEGMENTS definition

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 4 Jul 2002 23:01:00 +1000
Message-ID: <SzXU8.27524$Hj3.85142@newsfeeds.bigpond.com>

Hi Hrishikesh,

I would simply recommend ROLLBACK_SEGMENTS= (RBS1, RBS2). That always works.

Good Luck

Richard
"Hrishikesh Mehendale" <hrishikesh_mehendale_at_persistent.co.in> wrote in message news:ag1eaf$idt$1_at_news.vsnl.net.in...
> Hi,
>
> I'm having a weird (?) problem, as follows:
>
> In my init<sid>.ora file, I have specified the following lines:
>
> ROLLBACK_SEGMENTS = RBS1
> ROLLBACK_SEGMENTS = RBS2
>
> When I shutdown/startup the database, both (RBS1, RBS2) come online.
>
> However, if the lines are changed to either of
>
> rollback_segments = RBS1
> ROLLBACK_SEGMENTS = RBS2
>
> ------ or -------
>
> ROLLBACK_SEGMENTS = RBS1
> rollback_segments = RBS2
>
> only the second segment (RBS2) comes online (case sensitive ??)
>
> However, doing this:
>
> rollback_segments = RBS1
> rollback_segments = RBS2
>
> brings both segments online.
>
>
> I'm facing this problem on Oracle 8.1.7 EE for Solaris (8.1.7.1.0) and for
> Linux (8.1.7.0.1).
>
> Any ideas on (a) what I'm doing wrong (b) how to solve this?
> My problem is I have to add extra rollback segment(s) to a possibly
> existing declaration in the init<sid>.ora file through a script.
>
>
> Thanks
> Hrishikesh
>
> --
> Hrishikesh Mehendale
> Member of Technical Staff
> Persistent Systems, Pune.
> http://www.persistent.co.in/
Received on Thu Jul 04 2002 - 08:01:00 CDT