Oracle 11gR2 RAC Service-Side TAF 配置示例

How To Configure Server Side TransparentApplication Failover [ID 460982.1]1．创建TAFService[Oracle@db1 bin]$ ./srvctl add service -d orcl -s server_taf -r "orcl1,orcl2" -P BASIC--这里的orcl是database name，orcl1和orcl2 是instance name。2. 启动server_taf服务[oracle@db1 bin]$ ./srvctl start service -d orcl -s server_taf3. 检查service运行情况[oracle@db1 bin]$ ./srvctl config service -d orclService name: server_tafService is enabledServer pool: orcl_server_tafCardinality: 2Disconnect: falseService role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA notifications: falseFailover type: NONEFailover method: NONETAF failover retries: 0TAF failover delay: 0Connection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification: BASICEdition: Preferred instances: orcl1,orcl2Available instances:4.确认serviceIDSQL> select name,service_id from dba_services where name = "server_taf";NAME                                                            SERVICE_ID--------------------------------------------------------------------------server_taf                                                               35.给service添加参数：SQL> execute dbms_service.modify_service （service_name => "server_taf" -
, aq_ha_notifications => true -
, failover_method => dbms_service.failover_method_basic -
, failover_type => dbms_service.failover_type_select -
, failover_retries => 180 -
, failover_delay => 5 -
, clb_goal => dbms_service.clb_goal_long）; 6. 确认参数修改：col name format a15
col failover_method format a11 heading "METHOD"
col failover_type format a10 heading "TYPE"
col failover_retries format 9999999 heading "RETRIES"
col goal format a10
col clb_goal format a8
col AQ_HA_NOTIFICATIONS format a5 heading "AQNOT" SQL> select name, failover_method,failover_type, failover_retries,goal, clb_goal,aq_ha_notifications from dba_services where service_id = 3; NAME            METHOD      TYPE        RETRIES GOAL       CLB_GOAL AQNOT--------------- ----------- ------------------ ---------- -------- -----server_taf      BASIC       SELECT          180 NONE       LONG    YESSQL>

AIX上经常使用的DB2建instance的语句MongoDB主从同步及备份还原相关资讯 Oracle 11g Oracle 11gR2

CentOS 7上安装Oracle 11gR2 全程（07月25日）
RHEL 6.5 安装Oracle 11gR2 （06月11日）
Oracle 11gR2中的自动并行度（04月18日）

CentOS 无图形化安装Oracle 11gr2 （07月07日）
CentOS7安装Oracle 11gR2 图文详解（04月23日）
CentOS6.5下设置Oracle 11gR2 开机（12/19/2015 11:10:33）

本文评论查看全部评论（0）