Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article we will be learning how to Drop Redo Log Group In Oracle.
Before dropping a group, note that it is “INACTIVE”.
1 2 3 4 5 6 7 8 9 | SQL> select group#, members, bytes/1024/1024 MB, status from v$log; GROUP# MEMBERS MB STATUS ---------- ---------- ---------- ---------------- 1 1 50 CURRENT 2 1 50 UNUSED 3 1 50 INACTIVE 4 1 50 UNUSED 5 2 50 UNUSED |
I’m dropping group number 5.
1 2 3 | SQL> alter database drop logfile group 5; Database altered. |
I’m checking to see if it’s been dropped.
1 2 3 4 5 6 7 8 | SQL> select group#, members, bytes/1024/1024 MB, status from v$log; GROUP# MEMBERS MB STATUS ---------- ---------- ---------- ---------------- 1 1 50 CURRENT 2 1 50 UNUSED 3 1 50 INACTIVE 4 1 50 UNUSED |
NOTE: We get an error when we try to drop a redo log group with “CURRENT”.
