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