| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback to Undo in a RAC env.
For 10g, Document B10765-01, page 3-4 is pretty emphatic that "You cannot
simultaneously use automatic undo management and manual undo management in a
RAC database. In other words, all instances of a RAC database must operate
in the same undo mode."
I have *not* verified this limitation, nor have I checked 9.x documents. I hope this is not too late to help.
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of GUPTA, DEEPENDER
Sent: Friday, August 13, 2004 12:24 PM
To: 'oracle-l_at_freelists.org'
Subject: Rollback to Undo in a RAC env.
Hi All,
I am planning to covert the undo management from MANUAL to AUTO in a RAC environment with 2 nodes.
My question is, do I need to shutdown both the instances for doing this or can I change this parameter for 1 instance at a time. Can oracle mount 2 different instances with different UNDO management at a given point of time?
Last time when I upgraded the compatible parameter to 9200 I tried it one by one first and I got the error message ORA-1105 as one instance was mounted with compatible parameter 817 and I was trying to mount the other one with compatible parameter 9200.
Also pls advise if any type of performance problems has been observed with AUM. Regards
 |
 |