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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of GUPTA, DEEPENDER
Sent: Friday, August 13, 2004 12:24 PM
To: 'oracle-l@(protected) '
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 (See ORA-1105.ora-code.com) 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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
