Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true?
A.
The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
B.
Clusterware will monitor the service while it is active.
C.
The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
D.
When manually started, the service will always start on one or more available instances rather than on their preferred instances.
E.
The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
Explanation:
MANUAL: The database is never automatically restarted upon restart of the database host computer. A MANUAL setting does not prevent Oracle Clusterware from
monitoring the database while it is running and restarting it if a failure occurs.
Note: To prevent Oracle Clusterware from restarting your Oracle RAC database when you restart your system, or to avoid restarting failed instances more than
once, configure a policy to define the degree of control. There are two policies, automatic, which is the default, and manual.
https://docs.oracle.com/database/121/RACAD/srvctladmin.htm
B,E CORRECT
Service Management Policy
When you use Oracle Clusterware to manage your database, you can configure startup options for each individual database service when you add the service using the srvctl add service command with the -policy parameter. If you set the management policy for a service to AUTOMATIC (the default), then the service starts automatically when you start the database with SRVCTL. If you set the management policy to MANUAL, then the service does not automatically start, and you must manually start it with SRVCTL. A MANUAL setting does not prevent Oracle Clusterware from monitoring the service when it is running and restarting it if a failure occurs. Before Oracle RAC 11g release 2 (11.2), all services worked as though they were defined with a MANUAL management policy.
Correct!
Service Management Policy
When you use Oracle Clusterware to manage your database, you can configure startup options for each individual database service when you add the service using the srvctl add service command with the -policy parameter. If you set the management policy for a service to AUTOMATIC (the default), then the service starts automatically when you start the database with SRVCTL. If you set the management policy to MANUAL, then the service does not automatically start, and you must manually start it with SRVCTL. A MANUAL setting does not prevent Oracle Clusterware from monitoring the service when it is running and restarting it if a failure occurs. Before Oracle RAC 11g release 2 (11.2), all services worked as though they were defined with a MANUAL management policy.
…
Start or stop a service for a database or an instance. A service must be started before it can be used for client connections to that instance. If you shut down your database, for example, by running the SRVCTL command srvctl stop database -d db_unique_name where db_unique_name…, then Oracle Database stops all services to that database. Depending on the service management policy, you may have to manually restart the services when you start the database.
…
Table A–17 srvctl add service Options
-y {AUTOMATIC | MANUAL} Service management policy.
If AUTOMATIC (the default), then the service is automatically started upon restart of the database, either by a planned restart (with SRVCTL) or after a failure. Automatic restart is also subject to the service role, however (the -l option).
If MANUAL, then the service is never automatically restarted upon planned restart of the database (with SRVCTL). A MANUAL setting does not prevent Oracle Clusterware from monitoring the service when it is running and restarting it if a failure occurs.
Note: Using CRSCTL to stop and start the Oracle Clusterware restarts the service in the same way that a failure does.