Oracle 集群维护.doc

Oracle 集群维护1 维护层次概述层次命令节点层olsnodes网络层oifcfg集群层Crsctl ocrcheck ocrdump orcconfig应用层Srvctl onsctl crs_stat crs_stop2 维护命令详解：2.1 olsnodes: 2.1.1 用途：显示集群节点信息 2.1.2 参数说明：-n 显示节点编号 -p 显示每个节点用于private interconnect 的网络接口名称 -I 显示每个节点的VIP 2.1.3示例：/opt/oracle/crs/bin/olsnodes n p i rac01 1 rac01-priv rac01-viprac02 2 rac02-priv rac02-vip2.2 oifcfg 2.2.1 用途：用来定义和修改集群需要的网卡属性 2.2.2 参数说明：iflist 显示网卡列表 getif 获取单个网卡信息 setif 配置单个网卡 delif 删除网卡2.2.3 示例：oifcfg iflist eth1 172.168.0.0eth0 192.168.0.0oifcfg getifeth1 172.168.0.0 global cluster_interconnecteth0 192.168.0.0 global publicoifcfg getif type publicoifcfg getif type cluster_interconnect 2.3 crsctl 2.3.1 不带任何参数执行crsctl 可查看该命令的全部参数： crsctlUsage: crsctl check crs - checks the viability of the CRS stack crsctl check cssd - checks the viability of CSS crsctl check crsd - checks the viability of CRS crsctl check evmd - checks the viability of EVM crsctl set css - sets a parameter override crsctl get css - gets the value of a CSS parameter crsctl unset css - sets CSS parameter to its default crsctl query css votedisk - lists the voting disks used by CSS crsctl add css votedisk - adds a new voting disk crsctl delete css votedisk - removes a voting disk crsctl enable crs - enables startup for all CRS daemons crsctl disable crs - disables startup for all CRS daemons crsctl start crs - starts all CRS daemons. crsctl stop crs - stops all CRS daemons. Stops CRS resources in case of cluster. crsctl start resources - starts CRS resources. crsctl stop resources - stops CRS resources. crsctl debug statedump evm - dumps state info for evm objects crsctl debug statedump crs - dumps state info for crs objects crsctl debug statedump css - dumps state info for css objects crsctl debug log css module:level,module:level . - Turns on debugging for CSS crsctl debug trace css - dumps CSS in-memory tracing cache crsctl debug log crs module:level,module:level . - Turns on debugging for CRS crsctl debug trace crs - dumps CRS in-memory tracing cache crsctl debug log evm module:level,module:level . - Turns on debugging for EVM crsctl debug trace evm - dumps EVM in-memory tracing cache crsctl debug log res turns on debugging for resources crsctl query crs softwareversion - lists the version of CRS software installed crsctl query crs activeversion - lists the CRS software operating version crsctl lsmodules css - lists the CSS modules that can be used for debugging crsctl lsmodules crs - lists the CRS modules that can be used for debugging crsctl lsmodules evm - lists the EVM modules that can be used for debugging2.3.2 查看crs 状态： crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy Crs_stat (条目形式)：NAME=ora.rac01.ASM1.asmTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac01NAME=ora.rac01.LISTENER_RAC01.lsnrTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac01NAME=ora.rac01.gsdTYPE=applicationTARGET=ONLINESTATE=OFFLINENAME=ora.rac01.onsTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac01NAME=ora.rac01.vipTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac01NAME=ora.rac02.ASM2.asmTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac02NAME=ora.rac02.LISTENER_RAC02.lsnrTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac02NAME=ora.rac02.gsdTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac02NAME=ora.rac02.onsTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac02NAME=ora.rac02.vipTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac02NAME=ora.racdb.dbTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac02NAME=ora.racdb.racdb1.instTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac01NAME=ora.racdb.racdb2.instTYPE=applicationTARGET=ONLINESTATE=ONLINE on rac02 Crs_stat t (列表形式)：ora.SM1.asm application ONLINE ONLINE rac01 ora.01.lsnr application ONLINE ONLINE rac01 ora.rac01.gsd application ONLINE OFFLINE ora.rac01.ons application ONLINE ONLINE rac01 ora.rac01.vip application ONLINE ONLINE rac01 ora.SM2.asm application ONLINE ONLINE rac02 ora.02.lsnr application ONLINE ONLINE rac02 ora.rac02.gsd application ONLINE ONLINE rac02 ora.rac02.ons application ONLINE ONLINE rac02 ora.rac02.vip application ONLINE ONLINE rac02 ora.racdb.db application ONLINE ONLINE rac02 ora.b1.inst application ONLINE OFFLINE ora.b2.inst application ONLINE ONLINE rac02 如果crs 已经关闭或异常，系统将出现如下提示： Failure 1 contacting CSS daemonCannot communicate with CRSCannot communicate with EVM 2.3.3 启动crs Crsctl start crs (需要root 权限)2.3.4 关闭crs Crsctl stop crs (需要root 权限) 2.3.5 配置crs 随着系统启动而自动启动 Crsctl enable crs ( 需要root 权限)Crsctl disable crs ( 需要root 权限) 验证修改结果，可以查看： Cat /etc/oracle/scls_scr/rac01/root/crsstart 该文件中只有一句话: enable 或 disable 2.3.5 验证crs 进程是否存在： Ps ef|grep d.bin 当crs 状态正常时，应该能够看到如下三个进程：root 3664 1 2 19:37 ? 00:00:08 /opt/oracle/crs/bin/crsd.bin rebootoracle 4046 3661 0 19:38 ? 00:00:01 /opt/oracle/crs/bin/evmd.binoracle 4196 4164 1 19:38 ? 00:00:02 /opt/oracle/crs/bin/ocssd.bin说明：在集群环境中，如果需要关闭主机，需要首先关闭crs . 在适用crs_stat 命令，能够显示信息，无论是online 或者是offline ，都说明CRS 进程都在服务。此时需要在确认相关资源offline 后，执行crsctl stop crs 关闭CRS .并且在执行Ps ef|grep d.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 srvctl config 2.4.2.2 srvctl start 2.4.2.3 srvctl stop 2.4.2.4 srvctl status 2.4.3 使用srvctl 关闭数据库 Srvctl stop database d racdb 关闭集群数据库，各节点的实例将同时关闭 2.4.4 使用srvctl 关闭一个节点的实例 srvctl stop instance -d racdb -i racdb1 2.4.5 使用srvctl 启动一个节点的实例 Srvctl start instance d racdb i racdb1 2.4.5 使用srvctl 关闭节点 nodeapps Nodeapps 包括 GSD ONS VIP LISTENR ASM Srvctl stop nodeapps n rac01 2.4.6 使用srvctl 启动节点 nodeapps Srvctl start nodeapps n rac01 2.4.7 查看集群数据库配置 Srvcdtl config database d racdb a rac01 racdb1 /opt/oracle/product/10.2.0/db_1rac02 racdb2 /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: AUTOMATICENABLE FLAG: DB ENABLED (数据库随着CRS自动启动) 2.4.8 查看NODE APPLICATION 配置srvctl config nodeapps -n rac01 -a -g -s -lVIP exists.: /rac01-vip/192.168.0.11/255.255.255.0/eth0GSD exists.ONS daemon exists.Listener exists. 2.4.9 查看LISTENER Srvctl config listener n rac01 2.5 配置数据库不随着CRS 启动而启动 Srvctl disable database d racdb 验证： Srvctl config database d racdb a rac01 racdb1 /opt/oracle/product/10.2.0/db_1rac02 racdb2 /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: MANUALENABLE FLAG: DB DISABLED, INST DISABLED ON racdb1 racdb2 2.6 配置数据库随着CRS 启动而启动 Srvctl enable database d racdb 验证: rac01 racdb1 /opt/oracle/product/10.2.0/db_1rac02 racdb2 /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: AUTOMATICENABLE FLAG: DB ENABLED 2.7 关闭某个实例的自动启动 默认实例是自动启动的 Srvctl disable instance d racdb I racdb1 验证： Srvctl config database d racdb a rac01 racdb1 /opt/oracle/product/10.2.0/db_1rac02 racdb2 /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: AUTOMATICENABLE FLAG: DB ENABLED, INST DISABLED ON racdb12.8 启用某个实例的自动启动 Srvctl enable instance d racdb I racdb1 验证： rac01 racdb1 /opt/oracle/product/10.2.0/db_1rac02 racdb2 /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: AUTOMATICENABLE FLAG: DB ENABLED 2.9 crs_stop 2.9.1 关闭某节点的全部资源（应用，实例）Crs_stop c rac01 Attempting to stop ora.rac01.gsd on member rac01Attempting to stop ora.rac01.ons on member rac01