Which three statements are true about the administration and use of policy sets in Oracle 12c Clusterware?
A.
All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
B.
Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used.
C.
Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
D.
A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
E.
A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
Explanation:
A: A cluster configuration policy set is a document that defines the names of all server pools configured for the cluster and definitions for all policies.
C: If you create policies with Oracle Database Quality of Service Management (Oracle Database QoS Management), then you categorize servers by setting server
pool directive overrides, and CRSCTL commands using the policy and policyset nouns are disabled.
Note: Oracle Database 12c has introduced the policy sets, a feature that allows preparing in advance all the different workload scenarios and activating them with a
single command. The easiest way to create policy sets is dumping the current configuration into a file, edit it, and reload it into the cluster.
https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92635
– There is always exactly one policy set defined and used by the cluster. The policy set contains two attributes. The SERVER POOL NAMES attribute defines the names of all server pools controlled by the policy set. The policy set also contains an attribute that records the last activated policy.
– The policy set contains zero or more user-defined policies. Each policy contains exactly one definition for each server pool controlled by the policy set. Typically, administrators create policies to address different priorities at different times.
– Server pools may also exist outside the control of the policy set. For example, a server pool may be created with the srvctl add serverpool command and not be listed in the SERVER_POOL_NAMES policy set attribute. Server pools that are outside the control of the policy set are not directly affected by policy changes; however, such server pools may be indirectly affected by policy changes.
For example, a server pool outside the control of the policy set must yield a server when a policy change increases the number of servers allocated to a server pool with a higher priority, and there are no free servers or lower priority server pools elsewhere. Likewise, a server pool outside policy set control may grow in size because a policy change frees up a server.
– When QoS Management is activated, the associated clusterware policy set
definition is activated and locked so that clusterware administrators cannot manually modify the policy set.
B (NOT A) , C,E CORRECT
Should be CDE.
A is wrong because a policy set may contain only a subset of the existing serverpools.
B is wrong because servers not included in the policy set may well be affected indirectly by a policy change. Changes to MIN and MAX for policy set-controlled pools may cause a reassignment of servers across the entire cluster.
C is correct because QoS disables policy actions.
D and E are correct because you can freely choose which attributes you include in your policies.
D is correct
$ crsctl modify serverpool pool2 -attr “MIN_SIZE=1,MAX_SIZE=1” -policy DayTime
$ crsctl modify serverpool pool2 -attr “MIN_SIZE=1,MAX_SIZE=1” -policy Weekend
server pool pool2 has same attributes but assigned for daytime and weekend.
https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92640
This question is the same of the question N.76