SQL> select group#,sequence#,members,bytes,status,archived from v$log;
GROUP# SEQUENCE# MEMBERS BYTES STATUS ARCHIV
-------------------- ---------- ---------- --------------- ------
1 37 1 524288000 CURRENT NO
2 35 1 524288000 INACTIVE YES
3 36 1 524288000 INACTIVE YES
SQL> alter database add logfile('/home/oracle/oracle/redo04a.log','/home/oracle/oracle/redo04b.log') size 50m;
SQL> alter database droplogfile group 4;