檢視oracle rac的節點

it_newbalance發表於2013-01-10
Oracle
可以藉助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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24558279/viewspace-752495/，如需轉載，請註明出處，否則將追究法律責任。

相關文章