Rollback to Undo in a RAC env.

From: GUPTA, DEEPENDER <DGUPTA_at_entergy.com>
Date: Fri, 13 Aug 2004 11:24:20 -0500
Message-ID: <E9270A7736A5914C94E0D74EB6A5136101BDFE6B@tcbyexs02.ar.entergy.c om>

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_at_freelists.org 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

Received on Fri Aug 13 2004 - 11:20:19 CDT