Post date: 25-May-2009 08:51:02
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string
Instances running under this cluster
SQL> select instance_name, host_name from gv$instance
INSTANCE_NAME HOST_NAME
---------------- ----------------------------------------------------------------
rdb1 rc1.myrac.com
rdb2 rc2.myrac.com