Oracle 10g RAC 常用维护命令

核心提示：+DATADG/zwc/controlfile/current.260.810684377 +DATADG/zwc/datafile/example.264.810684397 +DATADG/zwc/datafile/sysaux.257.810684333 +DATADG/zwc/datafile/syste

+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

OCR存放路径
[oracle@vzwc1 ~]$ ocrcheck
Status 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

VOTEDISK存放路径
[oracle@vzwc1 ~]$ crsctl query css votedisk
0. 0 /dev/raw/raw2

located 1 votedisk(s).

clusterware版本
[oracle@vzwc1 ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.5.0]

RAC资源查看
[oracle@vzwc1 ~]$ crs_stat -t
Name 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