Check the redo log location, size and status in Oracle

Check the size and location of Redo log files

set line 200 pages 200
col file_name for a50
SELECT a.GROUP#, a.THREAD#,  a.SEQUENCE#,  a.ARCHIVED,  a.STATUS,(a.BYTES/1024/1024) AS SIZE_MB, b.MEMBER AS FILE_NAME
FROM v$log a JOIN v$logfile b ON a.Group#=b.Group#
ORDER BY a.GROUP#;

GROUP# THREAD# SEQUENCE#  ARC STATUS	SIZE_MB  FILE_NAME
------ ------- ---------- --- --------- -------- ----------------------------------------------------

 1	    1	      19  YES INACTIVE	     200 /u01/app/oracle/oradata/CDB1/onlinelog/o1_mf_1_ljmhzo9h_.log
 2	    1	      20  YES INACTIVE	     200 /u01/app/oracle/oradata/CDB1/onlinelog/o1_mf_2_ljmhzobn_.log
 3	    1	      21  NO  CURRENT	     200 /u01/app/oracle/oradata/CDB1/onlinelog/o1_mf_3_ljmhzodt_.log

Check the redo log file members

select GROUP#,TYPE,MEMBER from v$logfile;

GROUP# TYPE    MEMBER

------ ------- ----------------------------------------------------------

	 3 ONLINE  /u01/app/oracle/oradata/CDB1/onlinelog/o1_mf_3_ljmhzodt_.log

	 2 ONLINE  /u01/app/oracle/oradata/CDB1/onlinelog/o1_mf_2_ljmhzobn_.log

	 1 ONLINE  /u01/app/oracle/oradata/CDB1/onlinelog/o1_mf_1_ljmhzo9h_.log

	 4 STANDBY /u01/app/oracle/oradata/CDB1/onlinelog/o1_mf_4_lwn2sz6n_.log

	 5 STANDBY /u01/app/oracle/oradata/CDB1/onlinelog/o1_mf_5_lwn2t1do_.log

	 6 STANDBY /u01/app/oracle/oradata/CDB1/onlinelog/o1_mf_6_lwn2t39t_.log

Check that Redo log file is archived and size

SELECT a.GROUP#, a.THREAD#,  a.SEQUENCE#,  a.ARCHIVED,  a.STATUS,(a.BYTES/1024/1024) AS SIZE_MB
FROM v$log a

    GROUP#    THREAD#  SEQUENCE# ARC STATUS		 SIZE_MB

---------- ---------- ---------- --- ---------------- ----------

	 1	    1	      19 YES INACTIVE		     200

	 2	    1	      20 YES INACTIVE		     200

	 3	    1	      21 NO  CURRENT		     200