HZWEBTAF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.183.142)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.183.144)(PORT = 1522))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hzwebtaf.mambo.com)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
SESSION和SELECT的区别。真正的区别在于,配置了SELECT选项的FAILOVER在数据库实例失败时,会将会话切换到另一个实例,且将实例失败时运行的SELECT语句继续执行,并返回正确的结果。而SESSION则不具备这个功能。
对于BASIC方式,所有设置了TAF的会话在当前实例失败后,会连接到另外一个实例上。而对于PRECONNECT方式,每个连接的会话在主实例和备份实例上各连接一个会话,一旦主实例失败,可以迅速的切换到备份实例。
How to verify?
SQL> SET TIMING ON
SQL> SET TIMING OFF
SQL> SET PAUSE ON
SQL> SET PAUSE OFF
Select operation : Well done
Insert,update operation: Rollback
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16348200/viewspace-614835/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16348200/viewspace-614835/