5 Replies Latest reply: Feb 12, 2013 4:21 PM by Ivica Arsov RSS

    Server side TAF configuration ..

    user7419391
      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.