oracle怎么区分rac节点,查看oracle rac的节点

可以借助gv$instance视图来查询，例如

SQL> desc gv$instance;

名称                                      是否为空? 类型

----------------------------------------- -------- ---------------

INST_ID                                            NUMBER

INSTANCE_NUMBER                        NUMBER

INSTANCE_NAME                             VARCHAR2(16)

HOST_NAME                                     VARCHAR2(64)

VERSION                                           VARCHAR2(17)

STARTUP_TIME                                 DATE

STATUS                                             VARCHAR2(12)

PARALLEL                                         VARCHAR2(3)

THREAD#                                           NUMBER

ARCHIVER                                          VARCHAR2(7)

LOG_SWITCH_WAIT                          VARCHAR2(15)

LOGINS                                               VARCHAR2(10)

SHUTDOWN_PENDING                       VARCHAR2(3)

DATABASE_STATUS                          VARCHAR2(17)

INSTANCE_ROLE                                VARCHAR2(18)

ACTIVE_STATE                                   VARCHAR2(9)

BLOCKED                                            VARCHAR2(3)

SQL> select instance_number,instance_name,host_name,status,version from gv$instance;

INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME            STATUS       VERSION

--------------- ---------------- -------------------- ------------ -------------

2 clus2            NODE1                OPEN         10.2.0.1.0

1 clus1            NODE2                OPEN         10.2.0.1.0