RE: 10gR2 RAC and FAST_START_MTTR_TARGET
Date: Fri, 9 May 2008 15:30:17 -0400
With RAC if one instance crashes another instance starts performing rollback operations so yes set FAST_START_MTTR_TARGET to zero. In fact I am not against using zero on non-RAC.
- Mark D Powell -- Phone (313) 592-5148
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris Dunscombe Sent: Friday, May 09, 2008 10:47 AM
Subject: 10gR2 RAC and
We've got a SAP system running on RAC and SAP are recommending letting it default to 0. I'm not comfortable with this as recovery from an instance or total database crash could take a while (many minutes).
I've done some research via google and metalink and see that there's an underscore parameter _FAST_START_INSTANCE_RECOVERY_TARGET which is mentioned in some places as being the way to go on RAC.
I've not been able to come to any firm conclusions myself so any advice, experiences much appreciated.
10.2.0.2 64 bit
Windows 2003 64 bit
http://www.freelists.org/webpage/oracle-l Received on Fri May 09 2008 - 14:30:17 CDT