|
|
|
|
|
|
Discussion of the Month: Rollback Segments
|
Rollback Segments (1 of 10), Read 144 times |
|
|
Conf: |
|
|
From: |
|
|
Date: |
Monday, September 10, 2001 09:08 AM |
The Rollback segments occasionally go offline. How can I stop this?
|
Topic: |
Rollback Segments (2 of 10), Read 95 times |
|
Conf: |
|
|
From: |
|
|
Date: |
Monday, September 10, 2001 09:14 AM |
What version of Oracle and on what platform?
Does this happen at a particular occasion or after running particular module or batch job or something similar? What is the frequency of this happening?
HTH.
Shripad Godbole
"Let's document it and call it a feature.".
|
Topic: |
Rollback Segments (3 of 10), Read 95 times |
|
Conf: |
|
|
From: |
|
|
Date: |
Monday, September 10, 2001 10:08 AM |
Rollback segments shouldn't go offline on their own. Is this happening when you restart your instance? If so, then make sure that you have a parameter in your INIT.ORA like:
rollback_segments=(r01,r02,r03,r04)
For all of your rollback segments.
HTH,
Brian
===================================
Brian Peasland
Pipeline SYSOP
Database Administrator
OCP DBA (7,8,8i)
|
Topic: |
Rollback Segments (4 of 10), Read 91 times |
|
Conf: |
|
|
From: |
|
|
Date: |
Tuesday, September 11, 2001 03:54 AM |
On a slight sidetrack from the original question ... I was under the impression that RBSs named in the init.ora file were private (to the instance) and so only generally useful for OPS? In fact further than I that, I thought that naming RBSs in the init.ora was not a good idea because they *must* be present at startup and that can cause problems in certain recovery scenarios or if, for example, one of them is taken offline and dropped without remembering to change the init.ora.
Is this a misunderstanding on my part?
Jonathan Cook
Cargill, World Trading Unit
OCP DBA 7.3, 8
|
Topic: |
Rollback Segments (5 of 10), Read 89 times |
|
Conf: |
|
|
From: |
|
|
Date: |
Tuesday, September 11, 2001 12:43 PM |
I always use private rollback segments. Public have a bad habit of cycling online and offline annoyingly beyond the control of the DBA. I have never had a recovery situation problem because of private rollback segments.
TUSC - The Ultimate Software Consultants
Training, Consulting, Monitoring, Development
Michael R. Ault
Senior Technical Management Consultant
(770) 363-7740
Fax: (770) 754-4503
|
Topic: |
Rollback Segments (6 of 10), Read 74 times |
|
Conf: |
|
|
From: |
|
|
Date: |
Wednesday, September 12, 2001 10:43 AM |
One other point to make outside of the "high standard" answers already given! You really only need to be concerned with public rollback segments if you are using Oracle Parallel Server (OPS). IIRC, in OPS you can have rollback segments that any instance can use (public) or that only that instance can use (private). If you are not running OPS, then you do not need public rollback segments.
HTH,
Brian
===================================
Brian Peasland
Pipeline SYSOP
Database Administrator
OCP DBA (7,8,8i)
|
Topic: |
Rollback Segments (7 of 10), Read 88 times |
|
Conf: |
|
|
From: |
|
|
Date: |
Wednesday, September 12, 2001 03:23 AM |
Thanks for setting me straight Mike and I guess that you answered the original question at the same time.
Jonathan Cook
Cargill, World Trading Unit
OCP DBA 7.3, 8
|
Topic: |
Rollback Segments (8 of 10), Read 83 times |
|
Conf: |
|
|
From: |
|
|
Date: |
Wednesday, September 12, 2001 10:17 AM |
Just a matter of opinion, don't know if there is a right or wrong answer.
TUSC - The Ultimate Software Consultants
Training, Consulting, Monitoring, Development
Michael R. Ault
Senior Technical Management Consultant
(770) 363-7740
Fax: (770) 754-4503
|
Topic: |
Rollback Segments (9 of 10), Read 68 times |
|
Conf: |
|
|
From: |
|
|
Date: |
Thursday, September 13, 2001 12:08 PM |
Mike ..
What does 'cycling online and offline means' in your suggestion given above
Regards
|
Topic: |
Rollback Segments (10 of 10), Read 62 times |
|
Conf: |
|
|
From: |
|
|
Date: |
Thursday, September 13, 2001 05:05 PM |
Usually the problem is the rollback segments come online and can't go offline when you need to do maintenance. A public rollback segment will be automatically brought on line if Oracle determines it needs to.
TUSC - The Ultimate Software Consultants
Training, Consulting, Monitoring, Development
Michael R. Ault
Senior Technical Management Consultant
(770) 363-7740
Fax: (770) 754-4503
