【轉】ORACLE CRS日常維護命令

http://space.itpub.net/786749/viewspace-511991

這篇文件主要給大家介紹一下ORACLE RAC的crs的一些日常維護的常見命令：
1. 手工啟動crs # /etc/init.d/init.crs start
手工關閉crs # /etc/init.d/init.crs stop
在不同的作業系統，該檔案的路徑可能不一樣（下同，不同的系統，請轉換為不同的路徑）：

sun: /etc/init.d/init.crs
Linux: /etc/init.d/init.crs
HP-UX: /sbin/init.d/init.crs
HP Tru64: /sbin/init.d/init.crs
IBM AIX: /etc/init.crs
預設情況下，系統啟動時，crs會自動起來，如果沒有起來，則可以使用以上命令啟動
2. 系統啟動時，
自動啟動crs # /etc/init.d/init.crs enable
不自動啟動crs，採取手工啟動的方式 # /etc/init.d/init.crs disable

預設情況下，當系統啟動時crs是自動起來的，這個也是推薦的一總方式，
但是有時crs沒有自動起來，而我們又想讓crs自動啟動，則可以使用init.crs start
有時CRS不正常時，系統可能會自動重啟，在問題解決前，系統又重啟了，這個時候我們可以把crs的自動啟動關閉，在解決問題後再讓crs自動啟動


3. 檢視crs是否啟動
$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
這三個資源資源的狀態應該都為healthy
[oracle@zyy1 install]$ ps -ef|grep d.bin
root 10203 1 0 Dec07 ? 00:00:22 /u01/app/crs/bin/crsd.bin reboot
oracle 16927 10199 0 Dec07 ? 00:00:01 /u01/app/crs/bin/evmd.bin
oracle 17061 17031 0 Dec07 ? 00:00:04 /u01/app/crs/bin/ocssd.bin
oracle 31559 26820 0 11:43 pts/1 00:00:00 grep d.bin
4. 檢視crs的資源是否起來
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE zyy1
ora....37.lsnr application ONLINE ONLINE zyy1
ora.zyy1.gsd application ONLINE ONLINE zyy1
ora.zyy1.ons application ONLINE ONLINE zyy1
ora.zyy1.vip application ONLINE ONLINE zyy1
ora....SM2.asm application ONLINE ONLINE zyy2
ora....2.lsnr application ONLINE ONLINE zyy2
ora.zyy2.gsd application ONLINE ONLINE zyy2
ora.zyy2.ons application ONLINE ONLINE zyy2
ora.zyy2.vip application ONLINE ONLINE zyy2
ora.portal.db application ONLINE ONLINE zyy2
ora....zyydb.cs application ONLINE ONLINE zyy2
ora....db1.srv application ONLINE ONLINE zyy1
ora....db2.srv application ONLINE ONLINE zyy2
ora....b1.inst application ONLINE ONLINE zyy1
ora....b2.inst application ONLINE ONLINE zyy2
所有資源的狀態均需要為ONLINE
$ crs_stat
[oracle@zyy1 ~]$ crs_stat
NAME=ora.zyy1.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy1
NAME=ora.zyy1.LISTENER_zyy1.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy1
NAME=ora.zyy1.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy1
NAME=ora.zyy1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy1
NAME=ora.zyy1.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy1
NAME=ora.zyy2.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy2
NAME=ora.zyy2.LISTENER_zyy2.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy2
NAME=ora.zyy2.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy2
NAME=ora.zyy2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy2
NAME=ora.zyy2.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy2
NAME=ora.zyydb.db
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy2
NAME=ora.zyydb.zyydb.cs
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy2
NAME=ora.portal.zyydb.zyydb1.srv
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy1
NAME=ora.zyydb.zyydb.zyydb2.srv
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy2
NAME=ora.zyydb.zyydb1.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy1
NAME=ora.zyydb.zyydb2.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on zyy2
5. 關閉crs資源
# cd $ORA_CRS_HOME/bin
# ./crsctl stop crs
啟動crs資源
# cd $ORA_CRS_HOME/bin
# ./crsctl start crs

6. 檢視/啟動/關閉[url=javascript:;][u][b]資料庫[/b][/u][/url]例項
srvctl status|stop|start instance -d [db_name] -i [inst_name]
srvctl status|stop|start database -d [db_name]
eg:
[oracle@zyy2 ~]$ srvctl status database -d zyydb
Instance zyydb1 is running on node zyy1
Instance zyydb2 is running on node zyy2
7. 啟動/檢視/關閉asm例項
srvctl status|stop|start asm -n [node_name]
eg:
$ srvctl status asm -n zyy2
ASM instance +ASM1 is running on node zyy2.
8. 啟動/檢視/關閉nodeapps資源
eg:
$ srvctl status nodeapps -n zyy1
VIP is running on node: zyy1
GSD is running on node: zyy1
Listener is running on node: zyy1
ONS daemon is running on node: zyy1
$ srvctl status nodeapps -n zyy2
VIP is running on node: zyy2
GSD is running on node: zyy2
Listener is running on node: zyy2
ONS daemon is running on node: zyy2
9.啟動某個單獨的資源
$ crs_start [NAME] 注：使用crs_stat可以檢視相應資源的名字
[CLUSTERWARE]> crs_start ora.zyydb.zyydb1.inst[@more@]