← Redo & Archive Logs
Oracle · Redo & Archive Logs

How to check online redo log groups in Oracle

List online redo log groups with member paths, thread, archived flag, status, and size in MB.

Tested on11g12c18c19c21c23ai26ai

Join V$LOG with V$LOGFILE to see every online redo log group: group number, thread, member paths, whether the log has been archived, its status (CURRENT, ACTIVE, INACTIVE), and size in MB.

COL member   FORMAT a56
SET PAGESIZE 299 LINES 299

SELECT l.group#, l.thread#,
       f.member,
       l.archived,
       l.status,
       (l.bytes / 1024 / 1024) AS "Size (MB)"
FROM   v$log     l,
       v$logfile f
WHERE  f.group# = l.group#
ORDER BY 1, 2;
redoonline redov$logv$logfile