SQL queries related to REDO logs

set linesize 200
col MEMBER for a80
SELECT l.group#
     , l.status
     , l.bytes/1024/1024 AS size_mb
     , l.members
     , lf.member
  FROM v$log l, v$logfile lf
 WHERE l.group# = lf.group#
 ORDER BY l.group#, lf.member;

    GROUP# STATUS              SIZE_MB    MEMBERS MEMBER
---------- ---------------- ---------- ---------- --------------------------------------------------------------------------------
         1 ACTIVE                  128          1 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_n0fc7t3w_.log
         2 CURRENT                 128          1 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_n0fc7skg_.log
         3 ACTIVE                  128          1 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_n0fc7s09_.log
         4 ACTIVE                  128          1 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_n0fc7v2n_.log

-- Add
EXEC rdsadmin.rdsadmin_util.add_logfile(p_size => '200M');
-- Delete
EXEC rdsadmin.rdsadmin_util.drop_logfile(grp => 1);