TAF in RAC

TAF (Database Service) - Achive Fail Over 

1. create service 

srvctl add service -d DEVDB -s DEVDB_FO -r DEVDB1,DEVDB2 -P BASIC -e SELECT

-P BASIC/PRECONNECT 

-e SELECT/SESSION 

2. start service 

srvctl start service -d DEVDB -s DEVDB_FO

3. add TNS entry for the service 

DEVDB_FO =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = hostscan.localdomain.com)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = DEVDB_FO)

    )

  )

DEVDB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = hostscan.localdomain.com)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = DEVDB)

    )

  )

4. connect to database using service 

sqlplus sys/Mallik123#@DEVDB_FO as sysdba