QUERY RAC DATABASE info

QUERY INSTANCE_NAMES:

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
ORCLRAC2

SQL> select instance_name from gv$instance;

INSTANCE_NAME
----------------
ORCLRAC2
ORCLRAC1

---------------------------#################################################---------------------------------

QUERY REDO_LOG FILES:

column INST_ID format 999
column MEMBER format a60

SQL> select INST_ID,MEMBER from gv$logfile;

INST_ID MEMBER
------- ------------------------------------------------------------
      1 +REDO/ORCLRAC/redo02.log
      1 +REDO/ORCLRAC/redo01.log
      1 +REDO/ORCLRAC/redo03.log
      1 +REDO/ORCLRAC/redo04.log
      2 +REDO/ORCLRAC/redo02.log
      2 +REDO/ORCLRAC/redo01.log
      2 +REDO/ORCLRAC/redo03.log
      2 +REDO/ORCLRAC/redo04.log

---------------------------#################################################---------------------------------
QUERY DATAFILES:
     
SQL> column name format a60
SQL> select name from gv$datafile;

NAME
------------------------------------------------------------
+DATA/ORCLRAC/system01.dbf
+DATA/ORCLRAC/sysaux01.dbf
+DATA/ORCLRAC/undotbs01.dbf
+DATA/ORCLRAC/users01.dbf
+DATA/ORCLRAC/undotbs02.dbf
+DATA/ORCLRAC/system01.dbf
+DATA/ORCLRAC/sysaux01.dbf
+DATA/ORCLRAC/undotbs01.dbf
+DATA/ORCLRAC/users01.dbf
+DATA/ORCLRAC/undotbs02.dbf

10 rows selected.

---------------------------#################################################---------------------------------
QUERY CONTROL_FILES:

column INST_ID format 999
column NAME format a60

SQL> select INST_ID,NAME from gv$controlfile;

INST_ID NAME
------- ------------------------------------------------------------
      2 +DATA/ORCLRAC/control01.ctl
      2 +DATA/ORCLRAC/control02.ctl
      1 +DATA/ORCLRAC/control01.ctl
      1 +DATA/ORCLRAC/control02.ctl