Which three statements ate true about services and Transparent Application Failover (TAF)?

Which three statements ate true about services and Transparent Application Failover (TAF)?

Which three statements ate true about services and Transparent Application Failover (TAF)?

A.
If TAF has been configured for a service, sessions using that service fail over to a surviving
instance when an outage occurs.

B.
The TAF setting on a service can be NONE, BASIC, PRECONNECT, or POSTCONNECT, and
overrides any TAF setting in the client connection definition.

C.
TAF can restart a query after failover has completed but for other statements, such as INSERT,
UPDATE, or DELETE, the application must resubmit the transaction.

D.
The TAF setting for a client connection overrides any TAF setting in the service definition.

E.
Services simplify the deployment of TAF because by defining a TAF policy for a service, all
connections using this service will automatically have TAF enabled.

Explanation:
Services and Transparent Application Failover

Services simplify the deployment of Transparent Application Failover (TAF).
You can define a TAF policy for a service and all connections using this service will automatically
have TAF enabled.
The TAF setting on a service can be NONE, BASIC, or PRECONNECT and overrides any TAF
setting in the client connection definition.
To define a TAF policy for a service, the srvctl utility can be used as shown below:
srvctl modify service -s gl.example.com -q TRUE -P
BASIC -e SELECT -z 180 -w 5 -j LONG
Where -z is the number of retries, -w is the delay between retry attempts and -j is the connection
load balancing goal.
When Oracle Net Services establishes a connection to an instance, the connection remains open
until the client closes the connection, the instance is shut down, or a failure occurs. If you
configure TAF for the connection, then Oracle Database moves the session to a surviving instance
when an outage occurs.
TAF can restart a query after failover has completed but for other types of transactions, such as
INSERT, UPDATE, or DELETE, the application must roll back the failed transaction and resubmit
the transaction. You must re-execute any session customizations, in other words, ALTER
SESSION statements, after failover has occurred. However, with TAF, a connection is not moved
during normal processing, even if the workload changes over time.
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 13



Leave a Reply 8

Your email address will not be published. Required fields are marked *


bm

bm

B, C, E are the correct answers.

Gladys

Gladys

No POSTCONNECT

ACE is the correct answer

Gladys

Gladys

There is no PostConnect :

correct answer is ACE

Sikkhy

Sikkhy

A,C,E are the correct answers.

Sanjay Mevada

Sanjay Mevada

A,C,E is the correct answer.

L. Zhu

L. Zhu

A is right. TAF failover connections
B is wrong. no postconnect
C is right. no transaction for TAF
D is wrong. TAF service definition overrides client
E is right.

So A.C.E are correct