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.