RAC维护命令总结(2)

9、所有 Oracle 实例(数据库状态)
[oracle@rac1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac1
Instance racdb2 is running on node rac2

10、单个 Oracle 实例(特定实例的状态)
[oracle@rac1 ~]$ srvctl status instance -d racdb -i racdb1
Instance racdb1 is running on node rac1
[oracle@rac1 ~]$ srvctl status instance -d racdb -i racdb2
Instance racdb1 is running on node rac2

11、节点应用程序(状态)
[oracle@rac1 ~]$ srvctl status nodeapps
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
GSD is disabled
GSD is not running on node: rac1
GSD is not running on node: rac2
ONS is enabled

ONS daemon is running on node: rac1
ONS daemon is running on node: rac2
eONS is enabled
eONS daemon is running on node: rac1
eONS daemon is running on node: rac2

12、节点应用程序(配置)
[oracle@rac1 ~]$ srvctl config nodeapps

VIP exists.:rac1

VIP exists.: /rac1-vip/192.168.44.78/255.255.255.0/eth0

VIP exists.:rac2

VIP exists.: /rac2-vip/192.168.44.79/255.255.255.0/eth0

GSD exists.

ONS daemon exists. Local port 6100, remote port 6200

eONS daemon exists. Multicast port 22492, multicast IP address 234.236.221.152, listening port 2016

13、列出配置的所有数据库

[oracle@rac1 ~]$ srvctl config database

racdb

14、数据库(配置)
[oracle@rac1 ~]$ srvctl config database -d racdb -a

Database unique name: racdb

Database name: racdb

Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

Oracle user: oracle

Spfile: +RACDB_DATA/racdb/spfileracdb.ora

Domain: idevelopment.info

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: racdb

Database instances: racdb1,racdb2

Disk Groups: RACDB_DATA,FRA

Services:

Database is enabled

Database is administrator managed

15ASM —(状态)

[oracle@rac1 ~]$ srvctl status asm

ASM is running on rac1,rac2

16ASM —(配置)

[oracle@rac1 ~]$ srvctl config asm -a

ASM home: /u01/app/11.2.0/grid

ASM listener: LISTENER

ASM is enabled.

17TNS 监听器(状态)

[oracle@rac1 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac1,rac2

18TNS 监听器(配置)

[oracle@rac1 ~]$ srvctl config listener -a

Name: LISTENER

Network: 1, Owner: grid

Home:

/u01/app/11.2.0/grid on node(s) rac2,rac1

End points: TCP:1521

19SCAN —(状态)

[oracle@rac1 ~]$ srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac2

20SCAN —(配置)

[oracle@rac1 ~]$ srvctl config scan

SCAN name: rac-cluster-scan, Network: 1/192.168.44.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP: /rac-cluster-scan/192.168.44.177

21VIP —(特定节点的状态)

[oracle@rac1 ~]$ srvctl status vip -n rac1

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

[oracle@rac1 ~]$ srvctl config vip -n rac2

VIP exists.:rac2

VIP exists.: /rac2-vip/192.168.44.79/255.255.255.0/eth0

22VIP —(特定节点的配置)

[oracle@rac1 ~]$ srvctl config vip -n rac1

VIP exists.:rac1

VIP exists.: /rac1-vip/192.168.44.78/255.255.255.0/eth0

[oracle@rac1 ~]$ srvctl config vip -n rac2

VIP exists.:rac2

VIP exists.: /rac2-vip/192.168.44.79/255.255.255.0/eth0

23、节点应用程序配置VIPGSDONS、监听器)

[oracle@rac1 ~]$ srvctl config nodeapps -a -g -s -l

-l option has been deprecated and will be ignored.

VIP exists.:rac1

VIP exists.: /rac1-vip/192.168.44.78/255.255.255.0/eth0

VIP exists.:rac2

VIP exists.: /rac2-vip/192.168.44.79/255.255.255.0/eth0

GSD exists.

ONS daemon exists. Local port 6100, remote port 6200

Name: LISTENER

Network: 1, Owner: grid

Home:

/u01/app/11.2.0/grid on node(s) rac2,rac1

End points: TCP:1521

24、验证所有集群节点间的时钟同步

[oracle@rac1 ~]$ cluvfy comp clocksync -verbose

[@more@]

请使用浏览器的分享功能分享到微信等