Oracle 10g RAC 常用维护命令
01.[oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc1 -a -g -s -l
02.VIP exists.: /vzwc1-vip/192.168.1.151/255.255.255.0/eth0
03.GSD exists.
04.ONS daemon exists.
05.Listener exists.
06.[oracle@vzwc1 ~]$
07.[oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc2 -a -g -s -l
08.VIP exists.: /vzwc2-vip/192.168.1.152/255.255.255.0/eth0
09.GSD exists.
10.ONS daemon exists.
11.Listener exists.
[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 实例的配置
[plain] view plaincopyprint?
01.[oracle@vzwc1 ~]$ srvctl config asm -n vzwc1
02.+ASM1 /u01/app/oracle/product/10.2.0/db_1
03.[oracle@vzwc1 ~]$
04.[oracle@vzwc1 ~]$ srvctl config asm -n vzwc2
05.+ASM2 /u01/app/oracle/product/10.2.0/db_1
[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正在运行的实例
[plain] view plaincopyprint?
01.SQL> SELECT
02. 2 inst_id
03. , instance_number inst_no
04. , instance_name inst_name
05. , parallel
06. 6 , status
07. 7 , database_status db_status
08. 8 , active_state state
09. 9 , host_name host
10. 10 FROM gv$instance
11. 11 /
12.
13. INST_ID INST_NO INST_NAME PAR 毕业论文 STATUS DB_STATUS STATE HOST
14.---------- ---------- ---------------- --- ------------ ----------------- --------- ----------
15. 1 1 zwc1 YES OPEN ACTIVE NORMAL vzwc1
16. 2 2 zwc2  
上一页 [1] [2] [3] [4] [5] [6] [7] 下一页