RE: rac: service failover when multiple instances are listed as "available"
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 16 Aug 2010 13:46:12 +0200
Jaffar,
Thanks for your quick answer.
My question is not about the failover of the session, but about the failover of
the service itself.
Say I have a db service which has instance A as the preferred instance and
instance B and C as available instances.
Now, when the node on which instance A runs fails, on which node will the db
service relocate?
Kind regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--
From: Syed Jaffar Hussain [mailto:sjaffarhussain@xxxxxxxxx]
Sent: maandag 16 augustus 2010 13:40
To: D'Hooge Freek
Subject: Re: rac: service failover when multiple instances are listed as
"available"
Dear Freek,
It depends on how you configure the TAF policy. Is it client side load
balancing or server side (listener) load balancing. For more details, you may
read the following ML note:
Failover Issues and Limitations [Connect-time failover and TAF] [ID 97926.1]
Regards,
Jaffar
On Mon, Aug 16, 2010 at 2:32 PM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx> wrote:
Hi,
Does someone know how Oracle will decide to which instance a service will
failover if multiple instances are marked as available for that service?
Is it to the least loaded node?
Is it the same node to which the vip of the failed node will failover?
The environment consists out of a 3 node rac and Oracle version is 10.2.0.4 on
windows 2003 (not my decision).
Unfortionatly I don't have permission to fail some nodes to test it myself ...
:-(
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--
//www.freelists.org/webpage/oracle-l
--
Best Regards,
Syed Jaffar Hussain
Oracle Certified Master (10g)
http://www.oracle.com/technology/ocm/shussain.html
Co-author Oracle 11gR1/R2 RAC Handbook
http://www.packtpub.com/oracle-11g-r1-r2-real-application-clusters-handbook/book
Oracle ACE
http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186
OCP 8i,9i,10g & 11g DBA
RAC Certified Expert
Official Oracle RAC SIG Representative for Saudi Arabian region
(http://www.oracleracsig.org/)
I blog at
http://jaffardba.blogspot.com/
LinkedIn : http://www.linkedin.com/in/sjaffarhussain
--------------------
"Winners don't do different things. They do things differently."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
