Re: RAC Multiple Instance vs Service vs Serverpool

From: Ludovico Caldara <ludovico.caldara_at_gmail.com>
Date: Wed, 6 Aug 2014 23:25:06 +0200
Message-ID: <CALSQGrKM5Q+SQxtybhQLZ6M1FmtiDuyidw7YWpL0cSRzJwdzkg_at_mail.gmail.com>



Hi Sanjay,

I guess that when you say "ASM database" you really mean "ASM instance", isn't it?
In this case, no. ASM resources don't need to be put in a serverpool, they are somehow "external" to policy management.

Best regards

-- 
Ludo


2014-08-06 23:02 GMT+02:00 Sanjay Mishra <smishra_97_at_yahoo.com>:


> Ludovico
>
> Can you please update if I am doing server pool configuration then also
> has to place ASM database into serverpool
>
> Sanjay
>
>
> On Monday, July 28, 2014 11:36 AM, Sanjay Mishra <
> dmarc-noreply_at_freelists.org> wrote:
>
>
> Thanks Ludovico
>
>
> On Sunday, July 27, 2014 5:16 PM, Ludovico Caldara <
> ludovico.caldara_at_gmail.com> wrote:
>
>
> Hi Sanjay,
> my answers are below your questions...
>
> 2014-07-27 22:29 GMT+02:00 Sanjay Mishra <dmarc-noreply_at_freelists.org>:
>
> Serverpool is still dark as not clear that if a service srvA is running on
> two node ServerPool as singleton service and if that node goes down, it
> will relocate to second node and raise question like
>
> - What will happen and how fast is this relocation done automatically
> by Oracle
>
> The service is relocated ONLY in case of instance/server crash.
> If you consciounsly shutdown your database (even srvctl stop instance -o
> abort) the service will be stopped.
> So you have to relocate it first in case of shutdown. This is weird...
> but... the expected behavior, I presume.
> Usually it takes 2-3 seconds, to relocate the service AND your session.
>
>
>
> - If the original node is back, does this singleton service comes back
> to original node or will stay on second node like ole Service concept until
> manually relocated to original or required node.
>
> No, it will stay where it is unless you relocate it manually.
>
>
>
> - If in 4 node RAC, I had two serverpool of two node each and if any
> serverpool both node crashed, how we can make sure that it can take one of
> the node from second available Serverpool and bring all Database/services
> earlier running on Serverpol A live on ServerPool 2
>
> specify -min 1 for both serverpools so in case of two server crashes you
> will have always one node for each serverpool.
>
>
> TIA
> Sanjay
>
>
> Best regards
> --
> Ludovico
>
>
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 06 2014 - 23:25:06 CEST

Original text of this message