How to Verify resources on Rac Cluster

How to verify all the resources are up and running  on cluster nodes?

From grid home , use ./crs_stat -t

select inst_id,sid,serial#,terminal,program,process from gv$session;

v$session to identify the user session id
Which connection established from which terminal.

Every connection has sid and serial#

But in RAC - we use gv$session
includes background processes sessions.

Finding number of instances on RAC

SQL> select instance_name from gv$instance;

INSTANCE_NAME
----------------
prod1
prod2

Finding which Instance running on which NOde :

SQL> select inst_id,instance_number,instance_name,host_name,startup_time,status,thread#,database_status from gv$instance;



SQL> alter tablespace users add datafile '+DATA' size 100m;

Tablespace altered.

SQL> select file_name from dba_data_files where tablespace_name like 'USERS';

FILE_NAME
--------------------------------------------------------------------------------
+DATA/prod/datafile/users.259.936451463
+DATA/prod/datafile/users.269.936534815


Find free space from v$asm_disk_stat

QL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/prod/onlinelog/group_2.262.936451561
+DATA/prod/onlinelog/group_1.261.936451559
+DATA/prod/onlinelog/group_3.266.936451923
+DATA/prod/onlinelog/group_4.267.936451927

SQL> select instance_name,status from gv$instance;

INSTANCE_NAME    STATUS
---------------- ------------
prod2            OPEN
prod1            OPEN



Database name is one prod but instances are two prod1 and prod2.