Hi all,

You can list redo logs with this query:

Query

SELECT
    A.GROUP#,
    A.THREAD#,
    A.SEQUENCE#,
    A.ARCHIVED,
    A.STATUS,
    B.MEMBER "FILE NAME",
    (A.BYTES/1024/1024) "SIZE (MB)"
FROM
    V$LOG A
    JOIN V$LOGFILE B ON A.GROUP# = B.GROUP#
ORDER BY
    A.GROUP#;

Output

GROUP#   THREAD#   SEQUENCE#   ARCHIVED   STATUS     FILE NAME	                           SIZE (MB)
------   -------   ---------   --------   --------   -----------------------------------   ---------
1	 1	   48	       NO	  INACTIVE   /home/oracle/oradb/PROD/redo011.log   1024
1	 1	   48	       NO	  INACTIVE   /home/oracle/oradb/PROD/redo012.log   1024
2	 1	   49	       NO	  INACTIVE   /home/oracle/oradb/PROD/redo021.log   1024
2	 1	   49	       NO	  INACTIVE   /home/oracle/oradb/PROD/redo022.log   1024
3	 1	   50	       NO	  CURRENT    /home/oracle/oradb/PROD/redo031.log   1024
3	 1	   50	       NO	  CURRENT    /home/oracle/oradb/PROD/redo032.log   1024

 

See you later.