Thursday, March 22, 2012

srvctl modify service - TAF

What if in RAC database i want to implement TAF (Transparent Application Failover) to already existing setup?
Normally before setup people setup the TAF by configuring the tnsnames.ora in client machine to take the benefit of TAF. This was old method and not very convenient.
 However we can configure without modifying tnsnames.ora of client machine by modifying our SERVICE

srvctl modify service -d orcl -s orcldb -r node1,node2 -P basic -e select -m basic -z 10 -w 2


Thats it!


-

d = database name

-s = service name we want to modify

-r = preferd node list where this service is running

-a = available nodes - this we haven't given

-P = is type which can be BASIC | NONE | PRECONNECT

-e = is type i.e SELECT or SESSION

-z = Failover restries

-w = Failover delay

-m = defines the method of TAF.

Reference MOS note -

11gR2(11.2) RAC TAF Configuration for Admin and Policy Managed Databases [ID 1312749.1]















No comments:

Post a Comment