all about Oracle RAC Failover(五)
ames string raw, dmm
7）用service TAF 修改配置，需要用dbms_service.Modify_service 包。
SQL> Begin
Dbms_service.modify_service(
Service_name=>'dmm',
Failover_method=>dbms_service.failover_method_basic,
Failover_type=>dbms_service.failover_type_select,
Failover_retries=>180,
Failover_delay=>5
);
End;
/
PL/SQL procedure successfully completed.
8) 确认参数已经生效
SQL> select name,failover_method,failover_type,goal,clb_goal from dba_services;
NAME FAILOVER_METHOD FAILOVER_TYPE GOAL CLB_G
------------- ---------- ----------- ------- -------
SYS$BACKGROUND NONE SHORT
SYS$USERS NONE SHORT
seeddataXDB LONG
seeddata.regress.rdb LONG
rawXDB LONG
raw LONG
dmm BASIC SELECT LONG
7 rows selected.
9） 也可以用srvctl 命令查看配置情况
[oracle@raw2 bin]$ srvctl config service -d raw -s dmm -a
dmm PREF: raw1 AVAIL: raw2 TAF: basic
10） 删除Service
先关闭service：
[oracle@raw2 bin]$ srvctl stop service -d raw -s dmm
[oracle@raw2 bin]$ srvctl disable service -d raw -s dmm
删除服务：
[oracle@raw2 bin]$ srvctl remove service -d raw -s dmm
dmm PREF: raw1 AVAIL: raw2
Service dmm is disabled.
Remove service dmm from the database raw (y/[n]) y
如果该命令清楚不掉，我们可以加上-f 参数
[oracle@raw2 bin]# ./srvctl remove service -d raw -s dmm -f
OCR中的信息已经被删除了，但是数据字典中的还有该service的内容，继续清除数据字典中的内容。
先查看数据字典内容：
SQL> select name,failover_method,failover_type,goal,clb_goal from dba_services;
NAME FAILOVER_METHOD FAILOVER_TYPE GOAL CLB_G
-------------------- --------------- ----------------------- -----
SYS$BACKGROUND NONE SHORT
SYS$USERS NONE SHORT
seeddataXDB LONG
seeddata.regress.rdb LONG
rawXDB LONG
raw LONG
dmm BASIC SELECT LONG
7 rows selected.
清除数据字典里的内容：
SQL> begin
2 dbms_service.delete_service(service_name=>'dmm');
3 end;
4 /
PL/SQL procedure successfully completed.
再次查询数据字典，没有了数据。清除完成
SQL> select name,failover_method,failover_type,goal,clb_goal from dba_services;
NAME FAILOVER_METHOD FAILOVER_TYPE GOAL CLB_G
-------------------- --------------- ----------------------- -----
SYS$BACKGROUND NONE SHORT
SYS$USERS NONE SHORT
seeddataXDB LONG
seeddata.regress.rdb LONG
rawXDB LONG
raw LONG