Re: Rollback to Undo in a RAC env.

From: Daniel W. Fink <Daniel.Fink_at_Sun.COM>
Date: Fri, 20 Aug 2004 06:53:51 -0600
Message-id: <4125F45F.7050600@sun.com>

Well, there it is plain as day! You can't mix AUM and MUM in an instance...even though the undo_management parameters don't have to be identical ;) I understand the that undo_retention and undo_suppress_errors don't have to be the same and undo_tablespace *must* be different, so why not indicate this in the parameter section? I guess I needed to RTWholeFM.
Thanks for coming across this. This is why the list is great. I don't know anyone who reads the whole manual and can remember every word. By combining our eyes and brains, we'll have read it all as a group.

Daniel

Senthil Ramanujam wrote:

>Dan,
>
>I came across this document when i was searching for RAC admin stuff.. I
>think this talks about maintaining same undo/rbs segment across all RAC
>instances.
>
>http://download-west.oracle.com/docs/cd/B10501_01/rac.920/a96596/mangstor.htm#21233
>
>Note:
>**
>
>You cannot simultaneously use automatic undo management and manual undo
>management mode. In other words, all instances within Real Application
>Cluster environments must operate in the same undo mode
>
>thanks.
>
>senthil
>
>

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 20 2004 - 07:49:39 CDT