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 ~

 所有实例和服务的状态
[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
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------