Q: RE: Q: ACTIVE_PLACEMENT - RAC clusterware how it works
Date: Wed, 26 Mar 2008 11:13:27 +0200
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.
Amihay Gonen wrote:
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 ?
Dba Team Leader