RE: Rollback segments offline on database restart

From: Babette Turner-Underwood <babette+oraclelist_at_pythian.com>
Date: Wed, 12 Jul 2000 08:54:04 -0400
Message-Id: <10556.111790@fatcity.com>

An interesting thing to watch for that recently got us...

Someone had added a new rollback segment (rbs04) without adding it to the init.ora. Naturally when the instance was bounced this rollback segment was offline.

What was weird is that there was a dbms_job that kept failing because it was specifically looking for RBS04. And no, there was not "set transaction use rollback segment" type of thing being done here. It appears that it used RBS04 when it created the job and for some reason wanted to continue using it.

We just brought the rollback segment online and added it to the init.ora to fix the problem, but we still found it strange.

• Babette

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Roy Ferguson
Sent: Tuesday, July 11, 2000 11:44 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Rollback segments offline on database restart

confirm that you have the 25 rollback segments listed in your init.ora file.

example:

rollback_segments = (r01,r02,r03,r04)

>

> 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?
Received on Wed Jul 12 2000 - 07:54:04 CDT