oracle中怎么配置及测试TAF

2025-03-14 技术教程

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

一、添加services_taf：

[root@ora19crac1~]#su-oracleLastlogin:TueMar318:06:26CST2020onpts/1[oracle@ora19crac1~]$srvctladdservice-dwoo-sserver_taf-r"woo1,woo2"-PBASIC二、启动server_taf

[oracle@ora19crac1~]$srvctlstartservice-dwoo-sserver_taf三、检查server_taf 运行状态

[oracle@ora19crac1~]$srvctlconfigservice-dwooServicename:server_tafServerpool:Cardinality:2Servicerole:PRIMARYManagementpolicy:AUTOMATICDTPtransaction:falseAQHAnotifications:falseGlobal:falseCommitOutcome:falseFailovertype:Failovermethod:Failoverretries:Failoverdelay:Failoverrestore:NONEConnectionLoadBalancingGoal:LONGRuntimeLoadBalancingGoal:NONETAFpolicyspecification:BASICEdition:Pluggabledatabasename:Hubservice:Maximumlagtime:ANYSQLTranslationProfile:Retention:86400secondsReplayInitiationTime:300secondsDraintimeout:Stopoption:SessionStateConsistency:DYNAMICGSMFlags:0ServiceisenabledPreferredinstances:woo1,woo2Availableinstances:CSScritical:noServiceusesJava:false四、检查刚才创建的服务

SQL>selectname,service_idfromdba_serviceswherename='server_taf';NAMESERVICE_ID-------------------------server_taf3五、检查服务配置

SQL>colnameformata15SQL>colfailover_methodformata11heading'METHOD'SQL>colfailover_typeformata10heading'TYPE'SQL>colfailover_retriesformat9999999heading'RETRIES'SQL>colgoalformata10SQL>colclb_goalformata8SQL>colAQ_HA_NOTIFICATIONSformata5heading'AQNOT'SQL>selectname,failover_method,failover_type,failover_retries,goal,clb_goal,aq_ha_notifications2fromdba_serviceswhereservice_id=3;NAMEMETHODTYPERETRIESGOALCLB_GOALAQNOT-------------------------------------------------------------------server_taf0NONELONGNO六、修改故障转移参数策略

[oracle@ora19crac1~]$srvctlmodifyservice-dwoo-sserver_taf-mBASIC-eSELECT-qTRUE-jLONG[oracle@ora19crac1~]$srvctlconfigservice-dwooServicename:server_tafServerpool:Cardinality:2Servicerole:PRIMARYManagementpolicy:AUTOMATICDTPtransaction:falseAQHAnotifications:trueGlobal:falseCommitOutcome:falseFailovertype:SELECTFailovermethod:BASICFailoverretries:Failoverdelay:Failoverrestore:NONEConnectionLoadBalancingGoal:LONGRuntimeLoadBalancingGoal:NONETAFpolicyspecification:BASICEdition:Pluggabledatabasename:Hubservice:Maximumlagtime:ANYSQLTranslationProfile:Retention:86400secondsReplayInitiationTime:300secondsDraintimeout:Stopoption:SessionStateConsistency:DYNAMICGSMFlags:0ServiceisenabledPreferredinstances:woo1,woo2Availableinstances:CSScritical:noServiceusesJava:false七、再次检查服务，我们可以看到值都有了

[oracle@ora19crac1~]$lsnrctlservicesLSNRCTLforLinux:Version19.0.0.0.0-Productionon19-MAR-202016:58:22Copyright(c)1991,2019,Oracle.Allrightsreserved.Connectingto(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))ServicesSummary...……Service"server_taf"has1instance(s).Instance"woo1",statusREADY,has1handler(s)forthisservice...Handler(s):"DEDICATED"established:0refused:0state:readyLOCALSERVERService"woo"has1instance(s).Instance"woo1",statusREADY,has1handler(s)forthisservice...Handler(s):"DEDICATED"established:0refused:0state:readyLOCALSERVER……Thecommandcompletedsuccessfully十、测试

SQL>colhost_nameformata11;SQL>selectinstance_name,host_namefromv$instance;INSTANCE_NAMEHOST_NAME---------------------------woo2ora19crac2十一、新开一个窗口关闭这个实例

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

SQL>colhost_nameformata11;SQL>selectinstance_name,host_namefromv$instance;INSTANCE_NAMEHOST_NAME---------------------------woo2ora19crac2

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