Oracle 10g RAC 常用维护命令
所有实例和服务的状态
[oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc1VIP is running on node: vzwc1GSD is running on node: vzwc1Listener is running on node: vzwc1ONS daemon is running on node: vzwc1[oracle@vzwc1 ~]$ [oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc2VIP is running on node: vzwc2GSD is running on node: vzwc2Listener is running on node: vzwc2ONS daemon is running on node: vzwc2
[oracle@vzwc1 ~]$ srvctl status asm -n vzwc1ASM instance +ASM1 is running on node vzwc1.[oracle@vzwc1 ~]$ [oracle@vzwc1 ~]$ srvctl status asm -n vzwc2ASM instance +ASM2 is running on node vzwc2.
[oracle@vzwc1 ~]$ srvctl config database -d zwcvzwc1 zwc1 /u01/app/oracle/product/10.2.0/db_1vzwc2 zwc2 /u01/app/oracle/product/10.2.0/db_1
[oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc1 -a -g -s -lVIP exists.: /vzwc1-vip/192.168.1.151/255.255.255.0/eth0GSD exists.ONS daemon exists.Listener exists.[oracle@vzwc1 ~]$ [oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc2 -a -g -s -l VIP exists.: /vzwc2-vip/192.168.1.152/255.255.255.0/eth0GSD exists.ONS daemon exists.Listener exists.
[oracle@vzwc1 ~]$ srvctl config asm -n vzwc1+ASM1 /u01/app/oracle/product/10.2.0/db_1[oracle@vzwc1 ~]$ [oracle@vzwc1 ~]$ srvctl config asm -n vzwc2+ASM2 /u01/app/oracle/product/10.2.0/db_1
SQL> select name from v$datafile 2 union 3 select member from v$logfile 4 union 5 select name from v$controlfile 6 union 7 select name from v$tempfile 8 /NAME--------------------------------------------------------------------------------------------+DATADG/zwc/controlfile/current.260.810684377+DATADG/zwc/datafile/example.264.810684397+DATADG/zwc/datafile/sysaux.257.810684333+DATADG/zwc/datafile/system.256.810684333+DATADG/zwc/datafile/undotbs1.258.810684333+DATADG/zwc/datafile/undotbs2.265.810684503+DATADG/zwc/datafile/users.259.810684333+DATADG/zwc/onlinelog/group_1.261.810684379+DATADG/zwc/onlinelog/group_2.262.810684383+DATADG/zwc/onlinelog/group_3.266.810684557+DATADG/zwc/onlinelog/group_4.267.810684559+DATADG/zwc/tempfile/temp.263.810684393+FLASHDG/zwc/controlfile/current.256.810684377+FLASHDG/zwc/onlinelog/group_1.257.810684381+FLASHDG/zwc/onlinelog/group_2.258.810684385+FLASHDG/zwc/onlinelog/group_3.259.810684559+FLASHDG/zwc/onlinelog/group_4.260.810684561
[oracle@vzwc1 ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 2 Total space (kbytes) : 1043916 Used space (kbytes) : 3832 Available space (kbytes) : 1040084 ID : 1906841437 Device/File Name : /dev/raw/raw1 Device/File integrity check succeeded Device/File not configured Cluster registry integrity check succeeded
[oracle@vzwc1 ~]$ crsctl query css votedisk 0. 0 /dev/raw/raw2located 1 votedisk(s).
[oracle@vzwc1 ~]$ crsctl query crs activeversionCRS active version on the cluster is [10.2.0.5.0]
[oracle@vzwc1 ~]$ crs_stat -tName Type Target State Host ------------------------ora....SM1.asm application ONLINE ONLINE vzwc1 ora....C1.lsnr application ONLINE ONLINE vzwc1 ora.vzwc1.gsd application ONLINE ONLINE vzwc1 ora.vzwc1.ons application ONLINE ONLINE vzwc1 ora.vzwc1.vip application ONLINE ONLINE vzwc1 ora....SM2.asm application ONLINE ONLINE vzwc2 ora....C2.lsnr application ONLINE ONLINE vzwc2 ora.vzwc2.gsd application ONLINE ONLINE vzwc2 ora.vzwc2.ons application ONLINE ONLINE vzwc2 ora.vzwc2.vip application ONLINE ONLINE vzwc2 ora.zwc.db application ONLINE ONLINE vzwc2 ora....c1.inst application ONLINE ONLINE vzwc1 ora....c2.inst application ONLINE ONLINE vzwc2
停止 Oracle 实例，当此实例（和相关服务）关闭后，关闭 ASM 实例。最后，关闭节点应用程序（虚拟 IP、GSD、TNS 监听器和 ONS）。
export ORACLE_SID=zwc1
emctl stop dbconsole
srvctl stop instance -d zwc -i zwc1
srvctl stop asm -n vzwc1
srvctl stop nodeapps -n vzwc1
启动节点应用程序（虚拟 IP、GSD、TNS 监听器和 ONS）。当成功启动节点应用程序后，启动 ASM 实例。最后，启动 Oracle 实例（和相关服务）以及EM。
export ORACLE_SID=zwc1
srvctl start nodeapps -n vzwc1
srvctl start asm -n vzwc1
srvctl start instance -d zwc -i zwc1
emctl start dbconsole
启动/停止所有实例及其启用的服务
srvctl start database -d zwc
srvctl stop database -d zwc
