This discussion is archived
5 Replies Latest reply: Feb 12, 2013 2:21 PM by Ivica Arsov RSS

Server side TAF configuration ..

681003 Newbie
Currently Being Moderated
I have configured Service Side TAF as below,

After restaring instance, following params related to service 'SSTAF1' are getting reset to 'NONE'
failover_method
failover_type

Procedure used for server side TAF configuration

srvctl add service -d OR112DB -s SSTAF1 -r "OR112DB1,OR112DB2" -P BASIC
srvctl start service -d OR112DB -s SSTAF1

sql> connect / as sysdba
Connected.
sql> execute dbms_service.modify_service (service_name => 'SSTAF1',goal => DBMS_SERVICE.GOAL_SERVICE_TIME,clb_goal => dbms_service.CLB_GOAL_SHORT,failover_method => dbms_service.FAILOVER_METHOD_BASIC,failover_type => dbms_service.FAILOVER_TYPE_SELECT,failover_retries => 20,failover_delay => 5,aq_ha_notifications => true );

SQL>select name,service_id from dba_services where name = 'SSTAF1';
NAME SERVICE_ID
------------------------------------------ ----------
SSTAF1 3


Before stoping intsnace
SQL> select name,failover_method,failover_type from dba_services where service_id = 3;

NAME
----------------------------------------------------------------
FAILOVER_METHOD
----------------------------------------------------------------
FAILOVER_TYPE
----------------------------------------------------------------
SSTAF1
BASIC
SELECT


After stopping & restarting instance

SQL> select name,failover_method,failover_type from dba_services where service_id = 3;

NAME
----------------------------------------------------------------
FAILOVER_METHOD
----------------------------------------------------------------
FAILOVER_TYPE
----------------------------------------------------------------
SSTAF1
NONE
NONE
SQL>


How to make service parameters permanant so that, it will not reset to 'NONE' after instance restart.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points