Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bring rollback segments online at dbstart 3

Status
Not open for further replies.

mrmac228

IS-IT--Management
May 27, 2003
255
GB
I've got an 8.1.7 db that everytime I shut it down and bring it back on line I have to manually bring the rollback segments back online.

How do I get this to happen automatically?

I love deadlines. I like the whooshing sound they make as they fly by - Douglas Adams
 
You should modify your init.ora file to include a rollback_segments parameter

ROLLBACK_SEGMENTS = (put comma separated list of rollback segments here)
 
Mr. Mac,

Another clever way to make rollback segments come on-line automatically without listing their names in the init.ora is to create your rollback segments as PUBLIC:

CREATE PUBLIC ROLLBACK SEGMENT <name>
TABLESPACE <rbs_ts_name>
STORAGE (INITIAL <size> NEXT <size> MAXEXTENTS <n | UNLIMITED>);

As I recall, the number of rollback segments that your instance will then try to automatically bring on-line results from this calculation that uses instance-parameter values:

TRUNC(processes/transactions_per_rollback_segment)

If you wish to use this method, but already have non-PUBLIC rollback segments, you can create and on-line as many PUBLIC rollback segments as you wish, then off-line and drop the non-PUBLIC ones that you don't want/need any longer.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA @ 21:48 (02Dec03) GMT, 14:48 (02Dec03) Mountain Time)
 
Thanks gents,

SantaMufasa, I reckon I'll do it in the init.ora file BUT I do like finding these, as you say, clever ways of doing things.

A star for your prompt responses.



I love deadlines. I like the whooshing sound they make as they fly by - Douglas Adams
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top