In this article, we will show you how to find redo log members, redo log file size, and redo log status using some simple commands.
Step 1. Find redo log file members and group details.
SQL>col member for a55 SQL>select group#,type,member from v$logfile
Output from above query:
Step 2. Find Redo log file size using v$log view.
SQL> select group#,thread#,sequence#,bytes/1024/1024 "size in MB",members from v$log;
Step 3. Get result from both query together.
SQL> col "redo file name" for a45 SQL>select l.group#,l.thread#,l.sequence#,l.archived,l.status, f.member "redo file name" from v$log l join v$logfile f on l.group#=f.group# order by l.status;