Oracle：查看自己当前在RAC的哪个节点上


SQL> select * from v$instance;

              1 RAC1
rac1.localdomain
11.2.0.1.0        07-APR-12 OPEN         YES          1 STOPPED
ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO

查看那些节点目前是Active状态:

SQL> select * from v$active_instances;

          1
rac1.localdomain:RAC1

          2
rac2.localdomain:RAC2


查看一共有那些节点:
select * from gv$instance;

         1               1 RAC1
rac1.localdomain
11.2.0.1.0        07-APR-12 OPEN         YES          1 STOPPED
ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO

         2               2 RAC2
rac2.localdomain
11.2.0.1.0        29-MAR-12 OPEN         YES          2 STOPPED
ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO