oracle TAF

韶博雅

已于 2024-11-24 22:05:55 修改

阅读量162

点赞数 3

文章标签： oracle 数据库

于 2024-07-18 10:52:32 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_39735909/article/details/140516241

版权

1、服务端配置

1）使用Oracle用户，为CRS配一个service资源
语法：#srvctl add service -d <database-name> -s <service-name> -r "preferred-instance-list" -a "available-instance-list" -P <TAF-policy>

[oracle@node1 ~]$  srvctl add service -d prod -s TAF -r prod1,prod2 -P basic -e select -m basic -w 5 -z 180
[oracle@node1 ~]$  srvctl config service -d prod   查看TAF服务状态
[oracle@node1 ~]$ srvctl start service -d prod -s TAF   启动TAF服务
[grid@node1 ~]$ crs_stat -t |grep svc
ora....taf.svc ora....ce.type ONLINE    ONLINE    node1         看到TAF服务资源已启动

SQL> show parameter service

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
service_names			     string	 test, TAF

[oracle@node1 ~]$ lsnrctl status
Service "TAF" has 1 instance(s).

2、查看服务

set linesize 150
col name for a10;
col FAILOVER_METHOD for a20;
col FAILOVER_TYPE for a20;
 select NAME,
        FAILOVER_METHOD,
        FAILOVER_TYPE,
        FAILOVER_RETRIES,
        FAILOVER_DELAY
   From DBA_SERVICES
  where NAME = 'TAF';
  
NAME	   FAILOVER_METHOD	FAILOVER_TYPE	     FAILOVER_RETRIES FAILOVER_DELAY
---------- -------------------- -------------------- ---------------- --------------
TAF	   BASIC		SELECT				  180		   5

3、移去CRS中的service

srvctl stop service -d prod  -s taf -i prod2
srvctl remove service -d prod -s TAF -f
#srvctl enable/disable/stop service -d database-name -s service-name -i instance-name
begin
  dbms_service.delete_service(service_name=>'TAF');
end;
/

alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=192.168.3.188)(PORT=1521))))' sid='prod1';