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”.
