查询oracle rac状态,RAC常见命令检查状态

  • Post author:
  • Post category:其他


1.2.1 检查集群状态

[grid@rac1 ~]$ crsctl check cluster

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Servicesis online

CRS-4533: Event Manager is online

1.2.2 所有Oracle实例(数据库状态)

[grid@rac1 ~]$ srvctl status database -dsdd

Instance sdd1 is running on node rac1

Instance sdd2 is running on node rac2

1.2.3 检查单个实例状态

[grid@rac1 ~]$ srvctl status instance -dsdd -i sdd1

Instance sdd1 is running on node rac1

[grid@rac1 ~]$

1.2.4节点应用程序状态

[grid@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

1.2.5 列出所有的配置数据库

[grid@rac1 ~]$ srvctl config database

sdd

1.2.6 数据库配置

[grid@rac1 ~]$ srvctl config database -dsdd -a

Database unique name: sdd

Database name: sdd

Oracle home: /u01/app/oracle/11.2.0/db_1

Oracle user: oracle

Spfile: +DATA/sdd/spfilesdd.ora

Domain:

Start options: open