Wednesday, September 29, 2010

Server Pools and Policy Managed Databses (1)

Server pools are logical divisions of a cluster into pools of servers, which are allocated to host databases or other applications. Server pools are managed using crsctl and srvctl commands.
Each server pool name must be unique within the cluster. You cannot have two server pools using the same name.
There are two styles of server pool management:
1.   Administrator-managed: Database administrators define on which servers a database resource should run, and place resources manually as needed. This is the management strategy used in previous releases.
2.   Policy managed: Database administrators specify in which server pool (excluding generic or free) the database resource should run. Oracle Clusterware is responsible for placing the database resource on a server within that server pool.
      The server pool name is a required attribute. You can also provide values for the following attributes; if you do not specify them, then they are set to the default value:
1.   MIN_SIZE: Minimum number of servers on which you want a resource to run. The default is 0.
2.   MAX_SIZE: Maximum number of servers on which you want a resource to run. The default is -1, which indicates that resources can run on all available nodes in the cluster.
3.    IMPORTANCE: The relative importance of the server pool, used to determine how to reconfigure servers when a node joins or leaves the cluster. The default is 0.
One good example/exercise

No comments:

Post a Comment