Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rollback to Undo in a RAC env.

Re: Rollback to Undo in a RAC env.

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Mon, 23 Aug 2004 12:48:52 -0600
Message-id: <412A3C14.7000702@sun.com>


I think I'm going to add this to my list "Things You Will Never Never Never Never Do".

Thanks for being the guinea pig,
Daniel

GUPTA, DEEPENDER wrote:
> It seems that the two instance of RAC can run in different modes. Though we
> should not do that and run both the instance in the same mode.
>
> I tried this in my test environment and switched the rollback to undo in 1
> instance and restarted it, while the other instance was running using
> rollback segments. After few minutes I switched the rollback segments to
> undo segments in the second instance and it worked well.
>
> Conclusion is that we can switch from UNDO to ROLLBACK in a RAC env one by
> one and we don't need to shutdown both the instance at the same time. But
> the questions of Daniel are still unanswered.
>
> 1. How will the auto undo instance perform read consistency with entries
> from a manual rollback segment?
> 2. What are the recovery implications?
>
> 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 Mon Aug 23 2004 - 13:44:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US