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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of GUPTA, DEEPENDER
Sent: Friday, August 13, 2004 12:24 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: