Oracle RAC SRVCTL and CRSCTL tools
Check RAC and Cluster health
- To check the health of RAC database there are two oracle native tools CRSCTL and SRVCTL.
- SQLPLUS is the command line tool to check the health of RAC instance and ASM instance.
Using SQLPLUS and find the RAC Instance status -
sql>select instance_name, host_name, archiver, thread#, status from gv$instance;
sql>select file_name, bytes/1024/1024 from dba_data_files;
sql>show parameter undo
sql>select group#, type, member, is_recovery_dest_file from v$logfile order by group#;
sql> select distinct thread#,group# from gv$log;
sql> select name from v$datafile