>
> How can I ensure that my rollback segments come back online after a server =
> (NT4) re-boot. I have
> looked in all the books but can find no reference to the problem.
>
> Many thanks
>
> Robin Coode
>
Robin,
You must list each rollback segment in your initSID.ora file, such as the
following line:
rollback_segments = (r01,r02,r03,r04)
Best regards,
-Ari Kaplan
Independent Oracle DBA Consultant
-------------- Note from John Grosskruth --------------
> i saw this tip in your list and it is fine as long as
> the rbs are static over time...if the number of them
> and the names change i wrote the following script that
> i run after server up to dynamically bring them
> online..also shrinks them :) you have to cut ans
> paste the results into the sql window.
>
> hope it helps :)
>
> john grosskruth
>
SET ECHO OFF;
select 'ALTER ROLLBACK SEGMENT' , segment_name ,'ONLINE;' from dba_rollback_segs;
select 'ALTER ROLLBACK SEGMENT' , segment_name ,'SHRINK;' from dba_rollback_segs;
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 245+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page