RAC TAF 连接 (tnsnames.ora)

 TYPE=SELECT 意味着如果当某台服务器出现故障时，Oracle 正在执行 SELECT 语句，在进行故障切换时将重新执行该 SELECT 语句，游标的指向方式会使客户端可以无缝地继续获取行。但是，INSERT 或 UPDATE 的事务仍会回滚。您还可以配置 TYPE=SESSION，这样如果首个连接失败，所有在当时正在进行的工作都将无可挽回地丢失。

METHOD=BASIC 意味着仅在任一服务器出现故障时连接到故障切换服务器。METHOD=PRECONNECT 意味着在任一服务器连接出现故障以前就连接到所有服务器；这样可避免重新连接的开销，但是意味着每个预连接的连接将占用的未使用的其他资源。

  In this example of a TAF basic dedicated connection, the TAF application first tries to connect to the 144.25.28.74 IP address. If it cannot connect, then it attempts to perform. a connect-time failover to 144.25.27.75. If the instance fails after the connection, then the TAF application fails over to the other node's listener, reserving SELECT statements that are in progress. If the failover connection attempt fails, then Oracle Net waits 5 seconds before trying to connect again. Oracle Net attempts to connect up to 180 times.

Specify a TAF basic dedicated connection for the SALES database as follows:

SALES_DED_BASIC=
  (DESCRIPTION=
     (LOAD_BALANCE=OFF)
     (FAILOVER=ON)
     (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=1524))
        (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=1524)))
     (CONNECT_DATA=
        (SERVICE_NAME=SALES.ORACLE.COM)
        (SERVER=DEDICATED)
        (INSTANCE_ROLE=PRIMARY)
        (FAILOVER_MODE=
             (BACKUP=SALES_DED_BASIC_BACKUP)
             (TYPE=SELECT)
             (METHOD=BASIC)
             (RETRIES=180)
             (DELAY=5))))

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-688795/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-688795/