Examine these commands:
srvctl add service -db RACDB -service CRM -preferred RACDB_1 -available RACDB_2 –taf policy preconnect
srvcl start service -db RACDB -service CRM
Instances RACDB_1 and RACDB_2 run on host0l and host02, respectively.
This is the only TNS entry in the client side tnsnames.ora:
CRM =
(DESCRIPTION =(FAILOVER=ON) (LOAD_BALANCE=ON)
(ADDRESS= (PROTOCOL=TCP) (HOST=host0l-VIP.example.com)(PORT=1521))
(ADDRESS= (PROTOCOL=TCP) (HOST=host02-VIP.example.com)(PORT=1521))
(CONNECT_DATA = (SERVICE_NAME = CRM)
(FAILOVER_MODE = (BACKUP=CRM_PRECONNECT)
(TYPE=SESSION)(METHOD=PRECONNECT))))
Which statement is true regarding the TAF settings?
A.
Clients using this configuration fail over and restart any active queries automatically.
B.
Clients using this configuration fail over and restart any active transactions automatically.
C.
This configuration will work only for a policy-managed RAC database.
D.
The configuration is incomplete because the TNS entry for the preconnected backup session is missing.
Correct : D
I am not sure if D is the correct answer (also that it uses VIP).
Source: https://docs.oracle.com/cd/E19509-01/820-3492/boaem/index.html
Option 1: Connect time FAIL OVER and TAF
MY_CLUSTER =
(DESCRIPTION =
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Node1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = Node2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = my_cluster.my_company.com)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = PRECONNECT)
(BACKUP=Node2)
)
)
)
Answer I think is either A or B.
I will go for A. (Please correct if you know the answer)
Let me correct myself. ziadabuqasem seems correct. I guess the answer is D.
Correct Answer: D
Must define:
MY_CLUSTER =
(DESCRIPTION =
(FAILOVER = ON)
..
..
(ADDRESS = (PROTOCOL = TCP)(HOST = Node2)(PORT = 1521))
)
..
..
..