← 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