oracle failover 区别,Oracle RAC Failover 详解

最新推荐文章于 2024-07-23 02:33:49 发布

Sparkmlib

最新推荐文章于 2024-07-23 02:33:49 发布

阅读量201

点赞数

文章标签： oracle failover 区别

本文介绍如何在 Oracle 环境中配置与管理服务，包括服务的创建、设置自启动、启动服务、修改 TAF 配置、查看配置情况、删除服务等步骤，并详细展示了相关命令及操作流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

3)确认服务创建成功，offline 表示还没有启动

[Oracle@raw2 bin]$ crs_stat -t

Name Type Target State Host

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

ora.raw.db application ONLINE ONLINE raw1

ora.raw.dmm.cs application OFFLINE OFFLINE

ora....aw1.srv application OFFLINE OFFLINE

ora.raw.raw.cs application ONLINE ONLINE raw1

ora....aw1.srv 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

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$USERSNONE SHORT

seeddataXDB LONG

seeddata.regress.rdb LONG

rawXDB LONG

rawLONG

dmm BASICSELECT 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$USERSNONE SHORT

seeddataXDB LONG

seeddata.regress.rdb LONG

rawXDBLONG

raw LONG

dmmBASICSELECT 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$USERSNONE SHORT

seeddataXDB LONG

seeddata.regress.rdb LONG

rawXDBLONG

raw LONG

6 rows selected.