Re: Rollback to Undo in a RAC env.
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 23 Aug 2004 12:48:52 -0600
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
