Oracle 集群維護1 維護層次概述層次命令節(jié)點層olsnodes網絡層oifcfg集群層Crsctl ocrcheck ocrdump orcconfig應用層Srvctl onsctl crs_stat crs_stop2 維護命令詳解：2.1 olsnodes: 2.1.1 用途：顯示集群節(jié)點信息 2.1.2 參數說明：-n 顯示節(jié)點編號 -p 顯示每個節(jié)點用于private interconnect 的網絡接口名稱 -I 顯示每個節(jié)點的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 不帶任何參數執(zhí)行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 狀態(tài)： 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 已經關閉或異常，系統(tǒng)將出現如下提示： 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 隨著系統(tǒng)啟動而自動啟動 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 狀態(tài)正常時，應該能夠看到如下三個進程：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說明：在集群環(huán)境中，如果需要關閉主機，需要首先關閉crs . 在適用crs_stat 命令，能夠顯示信息，無論是online 或者是offline ，都說明CRS 進程都在服務。此時需要在確認相關資源offline 后，執(zhí)行crsctl stop crs 關閉CRS .并且在執(zhí)行Ps ef|grep d.bin 沒有CRS進程后，在執(zhí)行主機的關閉，重啟2.4 srvctl 集群維護中，最常用，最重要的命令 使用srvctl h 查看該命令的幫助 2.4.1 參數說明： 2.4.1.1 d 數據庫名稱 （racdb） n 節(jié)點名稱 (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 關閉集群數據庫，各節(jié)點的實例將同時關閉 2.4.4 使用srvctl 關閉一個節(jié)點的實例 srvctl stop instance -d racdb -i racdb1 2.4.5 使用srvctl 啟動一個節(jié)點的實例 Srvctl start instance d racdb i racdb1 2.4.5 使用srvctl 關閉節(jié)點 nodeapps Nodeapps 包括 GSD ONS VIP LISTENR ASM Srvctl stop nodeapps n rac01 2.4.6 使用srvctl 啟動節(jié)點 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 關閉某節(jié)點的全部資源（應用，實例）Crs_stop c rac01 Attempting to stop ora.rac01.gsd on member rac01Attempting to stop ora.rac01.ons on member rac01