Re: evenly distribute services in RAC on node crash

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Wed, 18 Jul 2012 09:27:32 -0300
Message-ID: <CAJ2dSGTLGxoQ6sLQKS_50xtNdiavFzy3vMp1wNZW=_PVG8=PsA_at_mail.gmail.com>

Krishna,
  you can use the available node for each service. So, you would set the preferred node to RAC4 on all services and then add an available node RAC1 for 3 of them, RAC2 for 3 others and then RAC3 for the rest.

With this configuration, the services will not fall back to another node if the "available" node failes. That means if nodes 1 and 4 fail at the same time, the services that have RAC1 as available node will not relocate to an active node.

You may want to experiment, also, with having multiple available nodes but in a different order, I don't know how this will affect the behaviour but it might be worth a try.

hth

Alan.-

On Wed, Jul 18, 2012 at 8:30 AM, Krishna <krishna.setwin_at_gmail.com> wrote:

> Hi Everybody,
> we have 4 node rac cluster.
> Node 4 crashed. All the services on node 4 moved to node1.
>
> how can I evenly distribute the services instead all services going to
> node1 ?
>
> for example: i have 10 services on node 4. All went to node 1.
> i want 3 on node1, 3 on node2, 4 node3 .
>
> how can i achieve this?
>
> Any help appreciated.
>
> Thanks
> Krishna
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Wed Jul 18 2012 - 07:27:32 CDT