Oracle 集群维护

Oracle集群维护

1维护层次概述

层次 节点层 网络层 集群层 应用层 2维护命令详解： 2.1olsnodes:

2.1.1用途：显示集群节点信息 2.1.2参数说明：-n显示节点编号

-p显示每个节点用于privateinterconnect的网络接口名称 -I显示每个节点的VIP

2.1.3示例：/opt/oracle/crs/bin/olsnodes–n–p–i rac011rac01-privrac01-vip

rac022rac02-privrac02-vip

2.2oifcfg

2.2.1用途：用来定义和修改集群需要的网卡属性 2.2.2参数说明：iflist显示网卡列表 getif获取单个网卡信息 setif配置单个网卡 delif删除网卡

olsnodes oifcfg Crsctlocrcheckocrdumporcconfig Srvctlonsctlcrs_statcrs_stop 命令 2.2.3示例：oifcfgiflist eth1172.168.0.0

eth0192.168.0.0 oifcfggetif

eth1172.168.0.0globalcluster_interconnect eth0192.168.0.0globalpublic oifcfggetif–typepublic

oifcfggetif–typecluster_interconnect

2.3crsctl

2.3.1不带任何参数执行crsctl可查看该命令的全部参数： crsctl

Usage:crsctlcheckcrs-checkstheviabilityoftheCRSstack crsctlcheckcssd-checkstheviabilityofCSS crsctlcheckcrsd-checkstheviabilityofCRS crsctlcheckevmd-checkstheviabilityofEVM

crsctlsetcss-setsaparameteroverride crsctlgetcss-getsthevalueofaCSSparameter crsctlunsetcss-setsCSSparametertoitsdefault crsctlquerycssvotedisk-liststhevotingdisksusedbyCSS crsctladdcssvotedisk-addsanewvotingdisk crsctldeletecssvotedisk-removesavotingdisk crsctlenablecrs-enablesstartupforallCRSdaemons crsctldisablecrs-disablesstartupforallCRSdaemons crsctlstartcrs-startsallCRSdaemons.

crsctlstopcrs-stopsallCRSdaemons.StopsCRSresourcesincaseofcluster. crsctlstartresources-startsCRSresources.

crsctlstopresources-stopsCRSresources.

crsctldebugstatedumpevm-dumpsstateinfoforevmobjects crsctldebugstatedumpcrs-dumpsstateinfoforcrsobjects crsctldebugstatedumpcss-dumpsstateinfoforcssobjects crsctldebuglogcss[module:level]{,module:level}... -TurnsondebuggingforCSS

crsctldebugtracecss-dumpsCSSin-memorytracingcache crsctldebuglogcrs[module:level]{,module:level}... -TurnsondebuggingforCRS

crsctldebugtracecrs-dumpsCRSin-memorytracingcache crsctldebuglogevm[module:level]{,module:level}... -TurnsondebuggingforEVM

crsctldebugtraceevm-dumpsEVMin-memorytracingcache

crsctldebuglogresturnsondebuggingforresources

crsctlquerycrssoftwareversion[]-liststheversionofCRSsoftwareinstalled

crsctlquerycrsactiveversion-liststheCRSsoftwareoperatingversion crsctllsmodulescss-liststheCSSmodulesthatcanbeusedfordebugging crsctllsmodulescrs-liststheCRSmodulesthatcanbeusedfordebugging crsctllsmodulesevm-liststheEVMmodulesthatcanbeusedfordebugging 2.3.2查看crs状态： crsctlcheckcrs

CSSappearshealthy CRSappearshealthy EVMappearshealthy

Crs_stat(条目形式)：

NAME=ora.rac01.ASM1.asm TYPE=application TARGET=ONLINE STATE=ONLINEonrac01

NAME=ora.rac01.LISTENER_RAC01.lsnr TYPE=application TARGET=ONLINE STATE=ONLINEonrac01 NAME=ora.rac01.gsd TYPE=application TARGET=ONLINE STATE=OFFLINE NAME=ora.rac01.ons TYPE=application TARGET=ONLINE STATE=ONLINEonrac01 NAME=ora.rac01.vip TYPE=application TARGET=ONLINE STATE=ONLINEonrac01 NAME=ora.rac02.ASM2.asm TYPE=application TARGET=ONLINE STATE=ONLINEonrac02

NAME=ora.rac02.LISTENER_RAC02.lsnr TYPE=application

TARGET=ONLINE STATE=ONLINEonrac02 NAME=ora.rac02.gsd TYPE=application TARGET=ONLINE STATE=ONLINEonrac02 NAME=ora.rac02.ons TYPE=application TARGET=ONLINE STATE=ONLINEonrac02 NAME=ora.rac02.vip TYPE=application TARGET=ONLINE STATE=ONLINEonrac02 NAME=ora.racdb.db TYPE=application TARGET=ONLINE STATE=ONLINEonrac02 NAME=ora.racdb.racdb1.inst TYPE=application TARGET=ONLINE STATE=ONLINEonrac01 NAME=ora.racdb.racdb2.inst TYPE=application TARGET=ONLINE STATE=ONLINEonrac02

Crs_stat–t(列表形式)：

ora....SM1.asmapplicationONLINEONLINErac01 ora....01.lsnrapplicationONLINEONLINErac01 ora.rac01.gsdapplicationONLINEOFFLINE ora.rac01.onsapplicationONLINEONLINErac01 ora.rac01.vipapplicationONLINEONLINErac01 ora....SM2.asmapplicationONLINEONLINErac02 ora....02.lsnrapplicationONLINEONLINErac02 ora.rac02.gsdapplicationONLINEONLINErac02 ora.rac02.onsapplicationONLINEONLINErac02 ora.rac02.vipapplicationONLINEONLINErac02 ora.racdb.dbapplicationONLINEONLINErac02 ora....b1.instapplicationONLINEOFFLINE ora....b2.instapplicationONLINEONLINErac02 如果crs已经关闭或异常，系统将出现如下提示： Failure1contactingCSSdaemon

CannotcommunicatewithCRS CannotcommunicatewithEVM 2.3.3启动crs

Crsctlstartcrs(需要root权限) 2.3.4关闭crs

Crsctlstopcrs(需要root权限)

2.3.5配置crs随着系统启动而自动启动 Crsctlenablecrs(需要root权限)

Crsctldisablecrs(需要root权限) 验证修改结果，可以查看：

Cat/etc/oracle/scls_scr/rac01/root/crsstart 该文件中只有一句话:enable或disable 2.3.5验证crs进程是否存在： Ps–ef|grepd.bin

当crs状态正常时，应该能够看到如下三个进程：

root36641219:37?00:00:08/opt/oracle/crs/bin/crsd.binreboot oracle40463661019:38?00:00:01/opt/oracle/crs/bin/evmd.bin oracle41964164119:38?00:00:02/opt/oracle/crs/bin/ocssd.bin

说明：在集群环境中，如果需要关闭主机，需要首先关闭crs.在适用crs_stat命令，能够显示信息，无论是online或者是offline，都说明CRS进程都在服务。此时需要在确认相关资源offline后，执行crsctlstopcrs关闭CRS.并且在执行Ps–ef|grepd.bin没有CRS进程后，在执行主机的关闭，重启 2.4srvctl

集群维护中，最常用，最重要的命令 使用srvctl–h查看该命令的帮助 2.4.1参数说明：

2.4.1.1－d数据库名称（racdb） －n节点名称(rac01) －i实例名称(racdb1) 2.4.2常用命令组合： 2.4.2.1srvctlconfig 2.4.2.2srvctlstart 2.4.2.3srvctlstop 2.4.2.4srvctlstatus

2.4.3使用srvctl关闭数据库 Srvctlstopdatabase–dracdb

关闭集群数据库，各节点的实例将同时关闭 2.4.4使用srvctl关闭一个节点的实例 srvctlstopinstance-dracdb-iracdb1 2.4.5使用srvctl启动一个节点的实例 Srvctlstartinstance–dracdb–iracdb1 2.4.5使用srvctl关闭节点nodeapps Nodeapps包括GSDONSVIPLISTENRASM Srvctlstopnodeapps–nrac01 2.4.6使用srvctl启动节点nodeapps Srvctlstartnodeapps–nrac01 2.4.7查看集群数据库配置

Srvcdtlconfigdatabase–dracdb–a

rac01racdb1/opt/oracle/product/10.2.0/db_1

rac02racdb2/opt/oracle/product/10.2.0/db_1 DB_NAME:racdb

ORACLE_HOME:/opt/oracle/product/10.2.0/db_1 SPFILE:+DATA/racdb/spfileracdb.ora DOMAIN:null DB_ROLE:null START_OPTIONS:null POLICY:AUTOMATIC

ENABLEFLAG:DBENABLED(数据库随着CRS自动启动)

2.4.8查看NODEAPPLICATION配置

srvctlconfignodeapps-nrac01-a-g-s-l

VIPexists.:/rac01-vip/192.168.0.11/255.255.255.0/eth0 GSDexists.

ONSdaemonexists. Listenerexists.

2.4.9查看LISTENER Srvctlconfiglistener–nrac01

2.5配置数据库不随着CRS启动而启动 Srvctldisabledatabase–dracdb 验证：

Srvctlconfigdatabase–dracdb–a

rac01racdb1/opt/oracle/product/10.2.0/db_1

rac02racdb2/opt/oracle/product/10.2.0/db_1 DB_NAME:racdb

ORACLE_HOME:/opt/oracle/product/10.2.0/db_1 SPFILE:+DATA/racdb/spfileracdb.ora DOMAIN:null DB_ROLE:null START_OPTIONS:null POLICY:MANUAL

ENABLEFLAG:DBDISABLED,INSTDISABLEDONracdb1racdb2 2.6配置数据库随着CRS启动而启动 Srvctlenabledatabase–dracdb 验证:

rac01racdb1/opt/oracle/product/10.2.0/db_1

rac02racdb2/opt/oracle/product/10.2.0/db_1

DB_NAME:racdb

ORACLE_HOME:/opt/oracle/product/10.2.0/db_1 SPFILE:+DATA/racdb/spfileracdb.ora DOMAIN:null DB_ROLE:null START_OPTIONS:null POLICY:AUTOMATIC ENABLEFLAG:DBENABLED 2.7关闭某个实例的自动启动 默认实例是自动启动的

Srvctldisableinstance–dracdb–Iracdb1 验证：

Srvctlconfigdatabase–dracdb–a

rac01racdb1/opt/oracle/product/10.2.0/db_1

rac02racdb2/opt/oracle/product/10.2.0/db_1 DB_NAME:racdb

ORACLE_HOME:/opt/oracle/product/10.2.0/db_1 SPFILE:+DATA/racdb/spfileracdb.ora DOMAIN:null DB_ROLE:null START_OPTIONS:null POLICY:AUTOMATIC

ENABLEFLAG:DBENABLED,INSTDISABLEDONracdb1 2.8启用某个实例的自动启动

Srvctlenableinstance–dracdb–Iracdb1 验证：

rac01racdb1/opt/oracle/product/10.2.0/db_1

rac02racdb2/opt/oracle/product/10.2.0/db_1 DB_NAME:racdb

ORACLE_HOME:/opt/oracle/product/10.2.0/db_1 SPFILE:+DATA/racdb/spfileracdb.ora DOMAIN:null DB_ROLE:null START_OPTIONS:null POLICY:AUTOMATIC ENABLEFLAG:DBENABLED 2.9crs_stop

2.9.1关闭某节点的全部资源（应用，实例）

Crs_stop–crac01

Attemptingtostop`ora.rac01.gsd`onmember`rac01`

Attemptingtostop`ora.rac01.ons`onmember`rac01` Stopof`ora.rac01.gsd`onmember`rac01`succeeded. Stopof`ora.rac01.ons`onmember`rac01`succeeded. Attemptingtostop`ora.racdb.racdb1.inst`onmember`rac01` Stopof`ora.racdb.racdb1.inst`onmember`rac01`succeeded. Attemptingtostop`ora.rac01.ASM1.asm`onmember`rac01` Stopof`ora.rac01.ASM1.asm`onmember`rac01`succeeded.

Attemptingtostop`ora.rac01.LISTENER_RAC01.lsnr`onmember`rac01` Stopof`ora.rac01.LISTENER_RAC01.lsnr`onmember`rac01`succeeded. Attemptingtostop`ora.rac01.vip`onmember`rac01` Stopof`ora.rac01.vip`onmember`rac01`succeeded.

2.9.2使用crs_stop关闭数据库（不推荐使用shutdownabort）

Crs_stopdatabaseora.racdb.db 2.9.3使用crs_stop关闭某个节点实例 Crs_stopinstanceora.racdb.racdb1.inst 该命令与

Srvctlstopinstance–dracdb–Iracdb1等价 2.10crs_stop停止顺序： 1ONS 2GSD 3DB 4ASM 5LISTENER 6VIP

2.11crs_start启动顺序 1VIP 2LISTENER 3ASM 4DB 5INSTANCE 6GSD 7ONS