Dropping online redo log groups

We can drop a log group only if the group status is inactive.

We use the ALTER DATABASE DROP LOGFILE GROUP SQL statement to drop an inactive log group.

To check the status of the log groups, run the following statement:

SQL> select group#, status, archived, thread#, sequence# from v$log;

Example:

 ----Check group status
SQL> select group#, status, archived, thread#, sequence# from v$log;
     GROUP# STATUS           ARC    THREAD#  SEQUENCE#
---------- ---------------- --- ---------- ----------
         1 INACTIVE         YES          1         18
         2 INACTIVE         YES          1         22
         3 INACTIVE         YES          1         20
         4 INACTIVE         YES          1         21
         7 INACTIVE         YES          1         23
         8 CURRENT          NO           1         24
 6 rows selected.

---- Drop log group 7
SQL> alter database drop logfile group 7;
 Database altered.
SQL>