日期:2014-05-16  浏览次数:20703 次

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、