Oracle集群维护

1、Oracle集群维护i维护层次概述层次命令节点层olsnodes网络层oifcfg集群层Crsctlocrcheckocrdumporcconfig应用层Srvctlonsctlcrs_statcrs_stop2维护命令详解：2.1olsnodes:2.1.1用途：显示集群节点信息2.1.2参数说明：-n显示节点编号-p显示每个节点用于privateinterconnect的网络接口名称-I显示每个节点的VIP2.1.3示例：/opt/oracle/crs/bin/olsnodes-n-p-irac011rac01-privrac01-viprac022rac02-privrac02-vip2

2、.2 oifcfg2.2.1 用途：用来定义和修改集群需要的网卡属性2.2.2 参数说明：iflist显示网卡列表getif获取单个网卡信息setif配置单个网卡delif删除网卡2.2.3 示例：oifcfgiflisteth1172.168.0.0eth0192.168.0.0oifcfggetifeth1172.168.0.0globalcluster_interconnecteth0192.168.0.0globalpublicoifcfggetifTypepublicoifcfggetifTypecluster_interconnect2.3 crsctl2.3.1 不带任何参数执行

3、crsctl可查看该命令的全部参数：crsctlUsage:crsctlcheckcrs-checkstheviabilityoftheCRSstackcrsctlcheckcssd-checkstheviabilityofCSScrsctlcheckcrsd-checkstheviabilityofCRScrsctlcheckevmd-checkstheviabilityofEVMcrsctlsetcss<parameter><value>-setsaparameteroverridecrsctlgetcss<parameter>-getsthevalue

4、ofaCSSparametercrsctlunsetcssparameter-setsCSSparametertoitsdefaultcrsctlquerycssvotedisk-liststhevotingdisksusedbyCSScrsctladdcssvotedisk<path>-addsanewvotingdiskcrsctldeletecssvotedisk<path>-removesavotingdiskcrsctlenablecrs-enablesstartupforallCRSdaemonscrsctldisablecrs-disablesstartu

5、pforallCRSdaemonscrsctlstartcrs-startsallCRSdaemons.crsctlstopcrs-stopsallCRSdaemons.StopsCRSresourcesincaseofcluster.crsctlstartresources-startsCRSresources.crsctlstopresources-stopsCRSresources.crsctldebugstatedumpevm-dumpsstateinfoforevmobjectscrsctldebugstatedumpcrs-dumpsstateinfoforcrsobjectscr

6、sctldebugstatedumpcss-dumpsstateinfoforcssobjectscrsctldebuglogcssmodule:level,module:level.- TurnsondebuggingforCSScrsctldebugtracecss-dumpsCSSin-memorytracingcachecrsctldebuglogcrsmodule:level,module:level.- TurnsondebuggingforCRScrsctldebugtracecrs-dumpsCRSin-memorytracingcachecrsctldebuglogevmmo

7、dule:level,module:level.- TurnsondebuggingforEVMcrsctldebugtraceevm-dumpsEVMin-memorytracingcachecrsctldebuglogres<resname:level>turnsondebuggingforresourcescrsctlquerycrssoftwareversion<nodename>-liststheversionofCRSsoftwareinstalledcrsctlquerycrsactiveversion-liststheCRSsoftwareoperati

8、ngversioncrsctllsmodulescss-liststheCSSmodulesthatcanbeusedfordebuggingcrsctllsmodulescrs-liststheCRSmodulesthatcanbeusedfordebuggingcrsctllsmodulesevm-liststheEVMmodulesthatcanbeusedfordebugging1.1.2 查看crs状态：crsctlcheckcrsCSSappearshealthyCRSappearshealthyEVMappearshealthyCrs_stat（条目形式）：NAME=ora.ra

9、c01.ASM1.asmTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac01NAME=ora.rac01.LISTENER_RAC01.lsnrTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac01NAME=ora.rac01.gsdTYPE=applicationTARGET=ONLINESTATE=OFFLINENAME=ora.rac01.onsTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac01NAME=ora.rac01.vipTYPE=applicati

10、onTARGET=ONLINESTATE=ONLINEonrac01NAME=ora.rac02.ASM2.asmTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac02NAME=ora.rac02.LISTENER_RAC02.lsnrTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac02NAME=ora.rac02.gsdTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac02NAME=ora.rac02.onsTYPE=applicationTARGET=ONLINE

11、STATE=ONLINEonrac02NAME=ora.rac02.vipTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac02NAME=ora.racdb.dbTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac02NAME=ora.racdb.racdb1.instTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac01NAME=ora.racdb.racdb2.instTYPE=applicationTARGET=ONLINESTATE=ONLINEonrac02Cr

12、s_stat-（列表形式）:oraSM1.asmapplicationONLINEONLINErac01ora01.lsnrapplicationONLINEONLINErac01ora.rac01.gsdapplicationONLINEOFFLINEora.rac01.onsapplicationONLINEONLINErac01ora.rac01.vipapplicationONLINEONLINErac01oraSM2.asmapplicationONLINEONLINErac02ora02.lsnrapplicationONLINEONLINErac02ora.rac02.gsdap

13、plicationONLINEONLINErac02ora.rac02.onsapplicationONLINEONLINErac02ora.rac02.vipapplicationONLINEONLINErac02ora.racdb.dbapplicationONLINEONLINErac02orab1.instapplicationONLINEOFFLINEorab2.instapplicationONLINEONLINErac02如果crs已经关闭或异常，系统将出现如下提示：Failure1contactingCSSdaemonCannotcommunicatewithCRSCannot

14、communicatewithEVM1.1.3 启动crsCrsctlstartcrs（需要root权限）1.1.4 关闭crsCrsctlstopcrs（需要root权限）1.1.5 配置crs随着系统启动而自动启动Crsctlenablecrs（需要root权限）Crsctldisablecrs（需要root权限）验证修改结果，可以查看：Cat/etc/oracle/scls_scr/rac01/root/crsstart该文件中只有一句话:enable或disable1.1.6 验证crs进程是否存在：Ps-ef|grepd.bin当crs状态正常时，应该能够看到如下三个进程：root3

15、6641219:37?00:00:08/opt/oracle/crs/bin/crsd.binrebootoracle40463661019:38?00:00:01/opt/oracle/crs/bin/evmd.binoracle41964164119:38?00:00:02/opt/oracle/crs/bin/ocssd.bin说明：在集群环境中，如果需要关闭主机，需要首先关闭crs.在适用crs_stat命令，能够显示信息，无论是online或者是offline,都说明CRS进程都在服务。此时需要在确认相关资源offline后，执行crsctlstopcrs关闭CRS并且在执行Pspg

16、repd.bin没有CRS进程后，在执行主机的关闭，重启2.4 srvctl集群维护中，最常用，最重要的命令使用srvctl-h查看该命令的帮助2.4.1 参数说明：2.4.1.1 d数据库名称(racdb)n节点名称(rac01)i实例名称(racdb1)2.4.2 常用命令组合：2.4.2.1 srvctlconfig2.4.2.2 srvctlstart2.4.2.3 srvctlstop2.4.2.4 srvctlstatus2.4.3 使用srvctl关闭数据库Srvctlstopdatabase-dracdb关闭集群数据库，各节点的实例将同时关闭2.4.4 使用srvctl关闭一个

17、节点的实例srvctlstopinstance-dracdb-iracdb12.4.5 使用srvctl启动一个节点的实例Srvctlstartinstance-dracdb-iracdbl2.4.6 使用srvctl关闭节点nodeappsNodeapps包括GSDONSVIPLISTENRASMSrvctlstopnodeapps-nrac012.4.7 使用srvctl启动节点nodeappsSrvctlstartnodeapps-nrac012.4.8 查看集群数据库配置Srvcdtlconfigdatabase-dracdb-arac01racdb1/opt/oracle/produ

18、ct/10.2.0/db_1rac02racdb2/opt/oracle/product/10.2.0/db_1DB_NAME:racdbORACLE_HOME:/opt/oracle/product/10.2.0/db_1SPFILE:+DATA/racdb/spfileracdb.oraDOMAIN:nullDB_ROLE:nullSTART_OPTIONS:nullPOLICY:AUTOMATICENABLEFLAG:DBENABLED据库随着CRS自动启动)2.4.8查看NODEAPPLICATIONSsrvctlconfignodeapps-nrac01-a-g-s-lVIPexis

19、ts.:/rac01-vip/192.168.0.11/255.255.255.0/eth0GSDexists.ONSdaemonexists.Listenerexists.2.4.9 查看LISTENERSrvctlconfiglistener-nrac012.5 配置数据库不随着CRS启动而启动Srvctldisabledatabase-dracdb验证：Srvctlconfigdatabase-dracdb-arac01racdb1/opt/oracle/product/10.2.0/db_1rac02racdb2/opt/oracle/product/10.2.0/db_1DB_NAM

20、E:racdbORACLE_HOME:/opt/oracle/product/10.2.0/db_1SPFILE:+DATA/racdb/spfileracdb.oraDOMAIN:nullDB_ROLE:nullSTART_OPTIONS:nullPOLICY:MANUALENABLEFLAG:DBDISABLED,INSTDISABLEDONracdb1racdb22.6 配置数据库随着CRS启动而启动Srvctlenabledatabase-dracdb验证:rac01racdb1/opt/oracle/product/10.2.0/db_1rac02racdb2/opt/oracle/

21、product/10.2.0/db_1DB_NAME:racdbORACLE_HOME:/opt/oracle/product/10.2.0/db_1SPFILE:+DATA/racdb/spfileracdb.oraDOMAIN:nullDB_ROLE:nullSTART_OPTIONS:nullPOLICY:AUTOMATICENABLEFLAG:DBENABLED2.7 关闭某个实例的自动启动默认实例是自动启动的Srvctldisableinstance-dracdb-Iracdb1验证：Srvctlconfigdatabase-dracdb-arac01racdb1/opt/oracl

22、e/product/10.2.0/db_1rac02racdb2/opt/oracle/product/10.2.0/db_1DB_NAME:racdbORACLE_HOME:/opt/oracle/product/10.2.0/db_1SPFILE:+DATA/racdb/spfileracdb.oraDOMAIN:nullDB_ROLE:nullSTART_OPTIONS:nullPOLICY:AUTOMATICENABLEFLAG:DBENABLED,INSTDISABLEDONracdbl2.8 启用某个实例的自动启动Srvctlenableinstance-dracdbTracdbl

23、验证：rac01racdb1/opt/oracle/product/1020/db_1rac02racdb2/opt/oracle/product/1020/db_1DB_NAME:racdbORACLE_HOME:/opt/oracle/product/10.2.0/db_1SPFILE:+DATA/racdb/spfileracdb.oraDOMAIN:nullDB_ROLE:nullSTART_OPTIONS:nullPOLICY:AUTOMATICENABLEFLAG:DBENABLED2.9 crs_stop2.9.1 关闭某节点的全部资源（应用，实例）Crs_stop-crac01Attemptingtostop'ora.rac01.gsd'onmember'racOI'Attemptingtostop'ora.rac01.ons'onmember'racOI'Stopof'ora.racO1.gsd'onmember'racOI'succeeded.Stopof'ora.rac01.ons'onmember'racO1'succeeded.Attemptingtostop'ora.racdb.racdb1