Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rollback to Undo in a RAC env.
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
-- 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