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 Delete Redo Log Member in oracle.
When deleting a member from a group, we must check if its status is CURRENT.
1 2 3 4 5 6 7 8 | SQL> select group#, members,status from v$log; GROUP# MEMBERS STATUS ---------- ---------- ---------------- 1 2 INACTIVE 2 1 INACTIVE 3 1 CURRENT 4 1 INACTIVE |
We learn the data file of the member to be deleted.
1 2 3 4 5 6 7 | SQL> select group#, member from v$logfile where group#=1; GROUP# MEMBER ---------- -------------------------------------------------------------------------------- 1 /u01/app/oracle/oradata/traindb/redo01.log 1 /u01/app/oracle/oradata/traindb/redo01b.log |
Now we can delete the member.
1 2 3 | SQL> alter database drop logfile member '/u01/app/oracle/oradata/traindb/redo01b.log' ; Database altered. |
Let’s check if the member has been deleted.
1 2 3 4 5 6 7 8 | SQL> select group#, members,status from v$log; GROUP# MEMBERS STATUS ---------- ---------- ---------------- 1 1 INACTIVE 2 1 INACTIVE 3 1 CURRENT 4 1 INACTIVE |
