PROD1, PROD2, and PROD3 are three Instance that have the PROD database open.
The OLTP service was created using:
$ srvctl add service -db prod -service OLTP -preferred PROD1, PROD2 -available PROD3
After starting the OLTP service, you execute this command:
$ srvctl stop instance -db prod -instance ” PROD1, PROD2 ” -stopoption immediate -f
Which statement is true about the outcome of this command?
A.
It shuts down PROD1 and PROD2; OLTP will be started automatically on PROD3.
B.
It shuts down PROD1 and PROD2; OLTP will not be started on PROD3.
C.
PROD1 and PROD2 are not shut down because OLTP must first be stopped.
D.
PROD1 and PROD2 are not shut down because OLTP must first be manually relocated to PROD3.
E.
It shuts down either PROD1or PROD2 but not both, so that OLTP remains available on a preferred instance.
I think the correct answer B
The srvctl stop instance command stops instances, and all enabled and running services that has these instances as either preferred or available instances.
Correct: A
When you create a service, you define which instances typically support that service. These are known as the preferred instances for that service. You can also define other instances to support a service if the service’s preferred instance fails. These are known as available instances for a service.
I think B is correct.
OLTP will not be started on PROD3, because it is already running there when OLTP was started.
I will go with A
A
I just made some test and the correct outcome is B.
If it is a pre-connect services would be C
https://docs.oracle.com/database/121/RACAD/GUID-9271B951-2AF5-4CFB-BC05-581467F34E22.htm#RACAD5040
-f (force option) will failover the service
A
tested on 2 node rac:
srvctl add service -d TESTDB -service TESTSERVICE -preferred inst1 -available inst2
srvctl stop instance -db TESTDB -instance ”inst1” -stopoption immediate -f
service was stopped on 1st machine and started on 2nd
From documentation
-force :This parameter fails the running services over to another instance.