Q: RE: Q: ACTIVE_PLACEMENT - RAC clusterware how it works

I've looked at cluster resource configuration I didn't see any place when I can define node as preferred or available.  

There are 2 parameters there:  

HOSTING_MEMBERS - An ordered list of cluster nodes separated by blank spaces that can host the resource. This attribute is required only if PLACEMENT equals favored or restricted.

PLACEMENT - The placement policy (balanced, favored, or restricted) specifies how Oracle Clusterware chooses the cluster node on which to start the resource  

favored-Oracle Clusterware refers to the list of nodes in the HOSTING_MEMBERS attribute of the application profile.

Only cluster nodes that are in this list and that satisfy the resource requirements are eligible for placement consideration.    

I know you can define service using srvctl as preferred of available, but I don't understand how it should be done with crs_profile.

From: Dan Norris [mailto:dannorris_at_dannorris.com] Sent: 26 March 2008 03:00
To: Amihay Gonen
Cc: annie.flint_at_oracle.com; elejandro
Subject: Re: Q: ACTIVE_PLACEMENT - RAC clusterware how it works  

I think that if node1 is the only preferred node and node2 is just an available node, then yes, the resource will relocate to node1.

Dan

Amihay Gonen wrote:

http://download.oracle.com/docs/cd/B28359_01/rac.111/b28255/crschp.htm#s thref382  

Hi all , if I've set ACTIVE_PLACEMENT of crs_profile to 1 . According to oracle documentation:

"When set to 1, Oracle Clusterware reevaluates the placement of a resource during addition or restart of a cluster node."

Is it means that if I've a resource which moved from node1 to node2 due to instance failure, then after node1 is back then the resource will go back to node1 ?    

Amihay Gonen
Dba Team Leader
PD Division
ECTel Ltd.    

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