试谈Oracle集群维护

1、 Oracle 集群维护1 维护层次概述层次命令节点层olsnodees网络层oifcfg集群层Crsctl ocrccheck ocrduump orrcconffig应用层Srvctl onscttl crss_statt crs_stop2 维护命令详详解：2.1 olssnodess: 2.1.11 用途：显示示集群节点信信息 2.1.22 参数说明明：-n 显显示节点编号号 -p 显示示每个节点用用于privvate iintercconnecct 的网络络接口名称 -I 显示每每个节点的VVIP 2.1.33示例：/oopt/orracle/crs/bbin/ollsnodees

2、n p i rac011 1 rac001-priiv racc01-viiprac02 2 rrac02-priv rac022-vip2.2 oiffcfg 2.2.1 用途：用来来定义和修改改集群需要的的网卡属性 2.2.2 参数说明：iiflistt 显示网卡卡列表 ggetif 获取单个个网卡信息 ssetif 配置单个个网卡 ddelif 删除网卡卡2.2.3 示示例：oiffcfg iiflistt eeth1 172.1168.0.0eth0 1192.1668.0.00oifcfg getiffeth1 1172.1668.0.00 gloobal clustter_innt

3、ercoonnectteth0 1192.1668.0.00 gloobal publiicoifcfg getiff type publiicoifcfg getiff type clustter_inntercoonnectt 2.3 ccrsctll 2.3.11 不带任何何参数执行ccrsctll 可查看该该命令的全部部参数： crrsctlUsage: crscttl cheeck ccrs - ccheckss the viabiility of thhe CRSS stacck crscttl cheeck ccssd - ccheckss the viabiility of C

4、SSS crscttl cheeck ccrsd - ccheckss the viabiility of CRRS crscttl cheeck eevmd - ccheckss the viabiility of EVVM crscttl sett ccss - sets a parrameteer oveerridee crscttl gett ccss - getts thee valuue of a CSSS paraameterr crscttl unsset ccss - setts CSSS paraameterr to iits deefaultt crscttl queer

5、y ccss vootedissk - lissts thhe votting ddisks used by CSSS crscttl addd ccss vootedissk - addss a neew votting ddisk crscttl dellete ccss vootedissk - remooves aa votiing diisk crscttl enaable crs - eenablees staartup for aall CRRS daeemons crscttl dissable crs - ddisablles sttartupp for all CCRS d

6、aaemonss crscttl staart crrs - startts alll CRS daemoons. crscttl stoop crrs - stopss all CRS ddaemonns. Sttops CCRS reesourcces inn casee of cclusteer. crscttl staart reesourcces - starrts CRRS ressourcees. crscttl stoop ressourcees - stopss CRSS resoourcess. crscttl debbug sttateduump evvm - dumps

7、s statte inffo forr evm objeccts crscttl debbug sttateduump crrs - dumpss statte inffo forr crs objeccts crscttl debbug sttateduump csss - dumpss statte inffo forr css objeccts crscttl debbug loog csss moddule:llevel,moddule:llevel . - TTurns on deebuggiing foor CSSS crscttl debbug trrace ccss - dum

8、pss CSS in-meemory traciing caache crscttl debbug loog crss moddule:llevel,moddule:llevel . - TTurns on deebuggiing foor CRSS crscttl debbug trrace ccrs - dumpss CRS in-meemory traciing caache crscttl debbug loog evmm moddule:llevel,moddule:llevel . - TTurns on deebuggiing foor EVMM crscttl debbug t

9、rrace eevm - dumpss EVM in-meemory traciing caache crscttl debbug loog ress turrns onn debuuggingg for resouurces crscttl queery crrs sofftwareeversiion - liists tthe veersionn of CCRS sooftwarre insstalleed crscttl queery crrs acttiveveersionn - liists tthe CRRS sofftwaree operratingg verssion crsc

10、ttl lsmmodulees csss - liists tthe CSSS moddules that can bbe useed forr debuuggingg crscttl lsmmodulees crss - liists tthe CRRS moddules that can bbe useed forr debuuggingg crscttl lsmmodulees evmm - liists tthe EVVM moddules that can bbe useed forr debuuggingg2.3.2 查查看crs 状态： crrsctl checkk crsCSS

11、 apppears healtthyCRS apppears healtthyEVM apppears healtthy Crrs_staat (条条目形式)：NAME=orra.racc01.ASSM1.assmTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac01NAME=orra.racc01.LIISTENEER_RACC01.lssnrTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac01NAME=orra.racc01.gssdTYPE=appplicaationTA

12、RGET=ONLINNESTATE=OOFFLINNENAME=orra.racc01.onnsTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac01NAME=orra.racc01.viipTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac01NAME=orra.racc02.ASSM2.assmTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac02NAME=orra.racc02.LIISTENEER_RACC02.l

13、ssnrTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac02NAME=orra.racc02.gssdTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac02NAME=orra.racc02.onnsTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac02NAME=orra.racc02.viipTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac02NAME=orra

14、.raccdb.dbbTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac02NAME=orra.raccdb.raacdb1.instTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac01NAME=orra.raccdb.raacdb2.instTYPE=appplicaationTARGET=ONLINNESTATE=OONLINEE on rrac02 Crrs_staat t (列表表形式)：ora.SM1.aasm appplicaation ONNLINE ONNLIN

15、E raac01 ora.01.lssnr appplicaation ONLINNE ONLINNE rac011 ora.racc01.gssd appplicaation ONNLINE OFFFLINEE ora.racc01.onns appplicaation ONNLINE ONNLINE raac01 ora.racc01.viip appplicaation ONNLINE ONNLINE raac01 ora.SM2.aasm appplicaation ONNLINE ONNLINE raac02 ora.02.lssnr appplicaation ONLINNE ON

16、LINNE rac022 ora.racc02.gssd appplicaation ONNLINE ONNLINE raac02 ora.racc02.onns appplicaation ONNLINE ONNLINE raac02 ora.racc02.viip appplicaation ONLINNE ONLINNE rac022 ora.raccdb.dbb appplicaation ONNLINE ONNLINE raac02 ora.b1.innst appplicaation ONLINNE OFFLIINE ora.b2.innst appplicaation ONLIN

17、NE ONLINNE rac022 如果crrs 已经关关闭或异常，系系统将出现如如下提示： Faiilure 1 conntactiing CSSS daeemonCannot commuunicatte witth CRSSCannot commuunicatte witth EVMM 2.3.3 启动crss CCrsctll starrt crss (需要要root 权限)2.3.4 关关闭crs Crrsctl stop crs (需要rooot 权限) 2.3.5 配置crss 随着系统统启动而自动动启动 CCrsctll enaable ccrs ( 需要rooot 权限)Crs

18、ctl disaable ccrs ( 需要rooot 权限) 验证证修改结果，可可以查看： Cat /etc/ooraclee/sclss_scr/rac011/roott/crssstart 该文件中只只有一句话: enabble 或 disabble 2.3.5 验证crss 进程是否否存在： Ps eef|greep d.bbin 当crs 状态正常时时，应该能够够看到如下三三个进程：root 36664 1 2 19:37 ? 00:00:088 /optt/oraccle/crrs/binn/crsdd.bin reboootoracle 40046 33661 0 19:38 ?

19、 00:00:011 /optt/oraccle/crrs/binn/evmdd.binoracle 41196 44164 1 19:38 ? 00:00:022 /optt/oraccle/crrs/binn/ocsssd.binn说明：在集群环环境中，如果果需要关闭主主机，需要首首先关闭crrs . 在在适用crss_statt 命令，能能够显示信息息，无论是oonlinee 或者是oofflinne ，都说说明CRS 进程都在服服务。此时需需要在确认相相关资源offflinee 后，执行行crscttl stoop crss 关闭CRRS .并且且在执行Ps ef|grrep d.bi

20、n 没没有CRS进进程后，在执执行主机的关关闭，重启2.4 srvvctl 集群维护中中，最常用，最最重要的命令令 使用srvvctl h 查看该该命令的帮助助 2.4.11 参数说明： 2.4.11.1 dd 数据据库名称 （rracdb） n 节点名名称 (rac011) i 实例名名称 (racdbb1) 2.4.22常用命令组组合： 2.4.2.1 srrvctl confiig 2.4.2.2 srrvctl startt 2.4.2.3 srrvctl stop 2.4.2.4 srrvctl statuus 2.4.3 使用ssrvctll 关闭数据据库 Srvctll stop

21、p dataabase d raccdb 关闭集群数数据库，各节节点的实例将将同时关闭 2.4.4 使用ssrvctll 关闭一个个节点的实例例 srvcctl sttop innstancce -d racdbb -i rracdb11 2.4.5 使用ssrvctll 启动一个个节点的实例例 Srvctll starrt insstancee d raccdb i racddb1 2.4.5 使用ssrvctll 关闭节点点 nodeeapps Nodeappps 包括括 GSD ONS VVIP LIISTENRR ASM Srvctll stopp nodeeapps n racc01

22、 2.4.6 使用ssrvctll 启动节点点 nodeeapps Srvctll starrt noddeappss n racc01 2.4.7 查看集群数数据库配置 Srvcdttl connfig ddatabaase d raccdb a rac001 raccdb1 /opt/ooraclee/prodduct/110.2.00/db_11rac02 rracdb22 /optt/oraccle/prroductt/10.22.0/dbb_1DB_NAMEE: raccdbORACLE_HOME: /optt/oraccle/prroductt/10.22.0/dbb_1SPFIL

23、E: +DATTA/raccdb/sppfilerracdb.oraDOMAIN: nulllDB_ROLEE: nulllSTART_OOPTIONNS: nuullPOLICY: AUTTOMATIICENABLE FLAG: DB EENABLEED (数据库随随着CRS自动启启动) 2.4.8 查看NODDE APPPLICATTION 配配置srvctl confiig noddeappss -n rrac01 -a -gg -s -lVIP exiists.: /racc01-viip/1922.168.0.11/255.2255.2555.0/eeth0GSD exiists.O

24、NS daeemon eexistss.Listeneer exiists. 2.4.9 查看LLISTENNER Srvctll conffig liisteneer n racc01 2.5 配置数据库库不随着CRSS 启动而启启动 SSrvctll disaable ddatabaase d raccdb 验验证： SSrvctll conffig daatabasse d raccdb a rrac01 racdbb1 /oppt/oraacle/pproducct/10.2.0/ddb_1rac02 rracdb22 /optt/oraccle/prroductt/10.22.0/d

25、bb_1DB_NAMEE: raccdbORACLE_HOME: /optt/oraccle/prroductt/10.22.0/dbb_1SPFILE: +DATTA/raccdb/sppfilerracdb.oraDOMAIN: nulllDB_ROLEE: nulllSTART_OOPTIONNS: nuullPOLICY: MANNUALENABLE FLAG: DB DDISABLLED, IINST DDISABLLED ONN racddb1 raacdb2 2.6 配配置数据库随随着CRS 启动而启动动 SSrvctll enabble daatabasse d raccdb

26、验验证: rrac01 racdbb1 /oppt/oraacle/pproducct/10.2.0/ddb_1rac02 rracdb22 /optt/oraccle/prroductt/10.22.0/dbb_1DB_NAMEE: raccdbORACLE_HOME: /optt/oraccle/prroductt/10.22.0/dbb_1SPFILE: +DATTA/raccdb/sppfilerracdb.oraDOMAIN: nulllDB_ROLEE: nulllSTART_OOPTIONNS: nuullPOLICY: AUTTOMATIICENABLE FLAG: DB EE

27、NABLEED 2.7 关关闭某个实例例的自动启动动 默默认实例是自自动启动的 SSrvctll disaable iinstannce d raccdb II racddb1 验验证： SSrvctll conffig daatabasse d raccdb a rrac01 racdbb1 /oppt/oraacle/pproducct/10.2.0/ddb_1rac02 rracdb22 /optt/oraccle/prroductt/10.22.0/dbb_1DB_NAMEE: raccdbORACLE_HOME: /optt/oraccle/prroductt/10.22.0/dbb

28、_1SPFILE: +DATTA/raccdb/sppfilerracdb.oraDOMAIN: nulllDB_ROLEE: nulllSTART_OOPTIONNS: nuullPOLICY: AUTTOMATIICENABLE FLAG: DB EENABLEED, INNST DIISABLEED ON racdbb12.8 启用某某个实例的自自动启动 Srvvctl eenablee insttance d raccdb II racddb1 验证： racc01 raacdb1 /opt/oraclle/prooduct/10.2.0/db_1rac02 rracdb22 /opt

29、t/oraccle/prroductt/10.22.0/dbb_1DB_NAMEE: raccdbORACLE_HOME: /optt/oraccle/prroductt/10.22.0/dbb_1SPFILE: +DATTA/raccdb/sppfilerracdb.oraDOMAIN: nulllDB_ROLEE: nulllSTART_OOPTIONNS: nuullPOLICY: AUTTOMATIICENABLE FLAG: DB EENABLEED 2.9 crs_sstop 2.9.1 关闭某某节点的全部部资源（应用用，实例）Crs_stoop c racc01 Atttemptiing too stopp oraa.rac001.gsdd on membeer raac01Attemptting tto stoop orra.racc01.onns onn membber rrac01Stop off o