The server pool large_db has four servers.
Examine the output shown:
A.
The sales database resource will be started and the database instances will be started
automatically when restarting the clusterware stack after normal shutdown of the sales database.
B.
The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database.
C.
The sales database resource will be restarted automatically after an instance failure.
D.
The concurrency values are not shown because sales in not a RAC One Node database.
E.
The concurrency values are not shown because sales has only one of its four instances running.
I cannot find information about Start Concurrency and Stop Concurrency, would anyone assist?
Best Regards.
Where Can I info about this kind of concurrency? What about the corect answer?
I have an exam that says : B and D are the correct, but I am not sure.
B and E.
B is a trick, since the database was shutted down and policy is Manual, it will back in its previous state, down.
E, because the concurrency is applied on RAC databases, the opposite of D:
startconcurrency number_of_instances: Specify a number of database instances to start simultaneously, or specify 0 for an empty start concurrency value (https://docs.oracle.com/database/122/RACAD/server-control-utility-reference.htm#RACAD7906)
B is true because “previous running condition” was SHUTDOWN after real shutdown of database. After CRS restart DB will be still SHUTDOWN because MANAGEMENT POLICY is MANUAL.
C is true because even with POLICY is MANUAL but CRS will still monitor DB instance after manual startup and CRS will restart it AUTOMATIC in case of failure.
E is not true as I’ve just checked in practice. Two node cluster with two instances started already and concurrency is EMPTY. Why? because this parameter defines HOW MANY INSTANCES will startup in one moment after restart of the whole cluster.