oracle中怎么配置及测试TAF

这篇文章主要介绍"oracle中怎么配置及测试TAF"，在日常操作中，相信很多人在oracle中怎么配置及测试TAF问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答"oracle中怎么配置及测试TAF"的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

一、添加services_taf：

[root@ora19crac1 ~]# su - oracleLast login: Tue Mar  3 18:06:26 CST 2020 on pts/1[oracle@ora19crac1 ~]$ srvctl add service -d woo -s server_taf -r "woo1,woo2" -P BASIC

二、启动server_taf

[oracle@ora19crac1 ~]$ srvctl start service -d woo -s server_taf

三、检查server_taf 运行状态

[oracle@ora19crac1 ~]$ srvctl config service -d wooService name: server_tafServer pool: Cardinality: 2Service role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA notifications: falseGlobal: falseCommit Outcome: falseFailover type: Failover method: Failover retries: Failover delay: Failover restore: NONEConnection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification: BASICEdition: Pluggable database name: Hub service: Maximum lag time: ANYSQL Translation Profile: Retention: 86400 secondsReplay Initiation Time: 300 secondsDrain timeout: Stop option: Session State Consistency: DYNAMICGSM Flags: 0Service is enabledPreferred instances: woo1,woo2Available instances: CSS critical: noService uses Java: false

四、检查刚才创建的服务

SQL> select name,service_id from dba_services where name ='server_taf'; NAME            SERVICE_ID--------------- ----------server_taf               3

五、检查服务配置

SQL> col name format a15 SQL> col failover_method format a11 heading 'METHOD'SQL> col failover_type format a10 heading 'TYPE'SQL> col failover_retries format 9999999 heading 'RETRIES'SQL> col goal format a10SQL> col clb_goal format a8SQL> col AQ_HA_NOTIFICATIONS format a5 heading 'AQNOT'SQL> select name, failover_method, failover_type, failover_retries,goal, clb_goal,aq_ha_notifications   2  from dba_services where service_id = 3; NAME            METHOD      TYPE        RETRIES GOAL       CLB_GOAL AQNOT--------------- ----------- ---------- -------- ---------- -------- -----server_taf                                    0 NONE       LONG     NO

六、修改故障转移参数策略

[oracle@ora19crac1 ~]$ srvctl modify service -d woo -s server_taf -m BASIC -e SELECT -q TRUE -j LONG[oracle@ora19crac1 ~]$ srvctl config service -d wooService name: server_tafServer pool: Cardinality: 2Service role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA notifications: trueGlobal: falseCommit Outcome: falseFailover type: SELECTFailover method: BASICFailover retries: Failover delay: Failover restore: NONEConnection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification: BASICEdition: Pluggable database name: Hub service: Maximum lag time: ANYSQL Translation Profile: Retention: 86400 secondsReplay Initiation Time: 300 secondsDrain timeout: Stop option: Session State Consistency: DYNAMICGSM Flags: 0Service is enabledPreferred instances: woo1,woo2Available instances: CSS critical: noService uses Java: false

七、再次检查服务，我们可以看到值都有了

SQL> col name format a15 SQL> col failover_method format a11 heading 'METHOD'SQL> col failover_type format a10 heading 'TYPE'SQL> col failover_retries format 9999999 heading 'RETRIES'SQL> col goal format a10SQL> col clb_goal format a8SQL> col AQ_HA_NOTIFICATIONS format a5 heading 'AQNOT'SQL> select name, failover_method, failover_type, failover_retries,goal, clb_goal,aq_ha_notifications   2  from dba_services where service_id = 3; NAME            METHOD      TYPE        RETRIES GOAL       CLB_GOAL AQNOT--------------- ----------- ---------- -------- ---------- -------- -----server_taf      BASIC       SELECT            0 NONE       LONG     YES

八、检查服务是否有注册到监听

[oracle@ora19crac1 ~]$ lsnrctl services LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-MAR-2020 16:58:22 Copyright (c) 1991, 2019, Oracle.  All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))Services Summary...……Service "server_taf" has 1 instance(s).  Instance "woo1", status READY, has 1 handler(s) for this service...    Handler(s):      "DEDICATED" established:0 refused:0 state:ready         LOCAL SERVERService "woo" has 1 instance(s).  Instance "woo1", status READY, has 1 handler(s) for this service...    Handler(s):      "DEDICATED" established:0 refused:0 state:ready         LOCAL SERVER         ……The command completed successfully

十、测试

SQL> col host_name format a11;SQL> select instance_name,host_name from v$instance; INSTANCE_NAME    HOST_NAME---------------- -----------woo2             ora19crac2

十一、新开一个窗口关闭这个实例

SQL> shut abortORACLE instance shut down.

十二、查询可以正常进行，但是会有短暂的锁住现象

SQL> col host_name format a11;SQL> select instance_name,host_name from v$instance; INSTANCE_NAME    HOST_NAME---------------- -----------woo2             ora19crac2

到此，关于"oracle中怎么配置及测试TAF"的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注网站，小编会继续努力为大家带来更多实用的文章！