OracleRACFailover详解(五)

2014-11-24 15:19:37 · 作者: · 浏览: 5
aw1

ora....w1.inst application ONLINE ONLINE raw1

ora....w2.inst application ONLINE ONLINE raw2

ora....SM1.asm application ONLINE ONLINE raw1

ora....W1.lsnr application ONLINE ONLINE raw1

ora.raw1.gsd application ONLINE ONLINE raw1

ora.raw1.ons application ONLINE ONLINE raw1

ora.raw1.vip application ONLINE ONLINE raw1

ora....SM2.asm application ONLINE ONLINE raw2

ora....W2.lsnr application ONLINE ONLINE raw2

ora.raw2.gsd application ONLINE ONLINE raw2

ora.raw2.ons application ONLINE ONLINE raw2

ora.raw2.vip application ONLINE ONLINE raw2

4)配置这个服务自启动

[oracle@raw2 bin]$ srvctl enable service -d raw -s dmm

PRKP-1018 : Service dmm already enabled.

5)启动服务

[oracle@raw2 bin]$ srvctl start service -d raw -s dmm

6)确认服务状态。Online 说明已启动

[oracle@raw2 bin]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.raw.db application ONLINE ONLINE raw1

ora.raw.dmm.cs application ONLINE ONLINE raw1

ora....aw1.srv application ONLINE ONLINE raw1

ora.raw.raw.cs application ONLINE ONLINE raw1

ora....w1.inst application ONLINE ONLINE raw1

ora....w2.inst application ONLINE ONLINE raw2

ora....SM1.asm application ONLINE ONLINE raw1

ora....W1.lsnr application ONLINE ONLINE raw1

ora.raw1.gsd application ONLINE ONLINE raw1

ora.raw1.ons application ONLINE ONLINE raw1

ora.raw1.vip application ONLINE ONLINE raw1

ora....SM2.asm application ONLINE ONLINE raw2

ora....W2.lsnr application ONLINE ONLINE raw2

ora.raw2.gsd application ONLINE ONLINE raw2

ora.raw2.ons application ONLINE ONLINE raw2

ora.raw2.vip application ONLINE ONLINE raw2

新建的服务会自动添加到初始话参数中:

SQL> show parameter service

NAME TYPE VALUE

----------------------------- ----------- --------------------

service_names 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 ro