Rollback to Undo in a RAC env. 2004-08-23 - By Daniel Fink
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
