Oracle 10g RAC常用维护命令
所有实例和服务的状态
[oracle@vzwc1 ~]$ srvctl status database -d zwc
Instance zwc1 is running on node vzwc1
Instance zwc2 is running on node vzwc2
单个实例的状态
[oracle@vzwc1 ~]$ srvctl status instance -d zwc -i zwc1
Instance zwc1 is running on node vzwc1
[oracle@vzwc1 ~]$ srvctl status instance -d zwc -i zwc2
Instance zwc2 is running on node vzwc2
特定节点上节点应用程序的状态
[oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc1
VIP is running on node: vzwc1
GSD is running on node: vzwc1
Listener is running on node: vzwc1
ONS daemon is running on node: vzwc1
[oracle@vzwc1 ~]$
[oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc2
VIP is running on node: vzwc2
GSD is running on node: vzwc2
Listener is running on node: vzwc2
ONS daemon is running on node: vzwc2
ASM 实例的状态
[oracle@vzwc1 ~]$ srvctl status asm -n vzwc1
ASM instance +ASM1 is running on node vzwc1.
[oracle@vzwc1 ~]$
[oracle@vzwc1 ~]$ srvctl status asm -n vzwc2
ASM instance +ASM2 is running on node vzwc2.
显示 RAC 数据库的配置
[oracle@vzwc1 ~]$ srvctl config database -d zwc
vzwc1 zwc1 /u01/app/oracle/product/10.2.0/db_1
vzwc2 zwc2 /u01/app/oracle/product/10.2.0/db_1
显示节点应用程序的配置 —(VIP、GSD、ONS、监听)
[oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc1 -a -g -s -l
VIP exists.: /vzwc1-vip/192.168.1.151/255.255.255.0/eth0
GSD 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/eth0
GSD exists.
ONS daemon exists.
Listener exists.
显示 ASM 实例的配置
[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
RAC正在运行的实例
SQL> SELECT
2 inst_id
, instance_number inst_no
, instance_name inst_name
, parallel
6 , status
7 , database_status db_status
8 , active_state state
9 , host_name host
10 FROM gv$instance
11 /
INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS STATE HOST
---------- ---------- ---------------- --- ------------ ----------------- --------- ----------
1 1 zwc1 YES OPEN ACTIVE NORMAL vzwc1
2 2 zwc2 YES OPEN ACTIVE NORMAL vzwc2
磁盘组中的所有数据文件
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
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 &nbs