你的位置:首页 > 数据库

[数据库]檢查RAC狀態


1.使用srvctl工具檢查RAC當前配置和狀態

$ srvctl config database -h

Displays the configuration for the database.

Usage: srvctl config database [-d <db_unique_name> [-a] ] [-v]
    -d <db_unique_name>      Unique name for the database
    -a                       Print detailed configuration information
    -v                       Verbose output
    -h                       Print usage

[root@phaws1 ~]# srvctl config database -d phaws
Database unique name: phaws
Database name: phaws
Oracle home: /oracle/product/11.2.0
Oracle user: oracle
Spfile: +SYSDG1/phaws/spfilephaws.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: phaws
Database instances: phaws1,phaws2
Disk Groups: SYSDG1,BACKUPDG,SYSDG2,DATADG
Mount point paths:
Services:
Type: RAC
Database is administrator managed

Displays the current state of the database.

Usage: srvctl status database -d <db_unique_name> [-f] [-v]
    -d <db_unique_name>      Unique name for the database
    -f                       Include disabled applications
    -v                       Verbose output
    -h                       Print usage

[root@phaws1 ~]# srvctl status database -d phaws
Instance phaws1 is running on node phaws1
Instance phaws2 is running on node phaws2

2.V$ACTIVE_INSTANCES view can also display the current status of the instances

SQL> select INST_NAME from v$active_instances;

INST_NAME
--------------------------------------------------------------------------------
phaws1:phaws1
phaws2:phaws2