RE: 10gR2 RAC and FAST_START_MTTR_TARGET

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • 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


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Chris Dunscombe
Sent: Friday, May 09, 2008 10:47 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 10gR2 RAC and 

Hi,

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.

Environment is:

10.2.0.2 64 bit
Windows 2003 64 bit
6 nodes

Thanks,

Chris





Chris Dunscombe

Christallize Ltd
www.christallize.com

Tel: 01903-714200
Mob: 07906-941850
Email: chris.dunscombe@xxxxxxxxxxxxxxxx

--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: