We mentioned earlier that the database works on at least two Redo Logfile Groups and each Group contains at least one Member. Let's assume that your database works on three Redo Logfile Groups and each Group contains two Members.

SELECT GROUP#,MEMBER FROM V$LOGFILE;

Let's assume that there is a problem in the following Member:

D:\ORADATA\REDO11.LOG

It belongs to Group1.

Here are the steps to solve this scenario:

1- First, we delete the Member that has the problem from the Group, then we delete it through the system.

ALTER DATABASE DROP LOGFILE MEMBER 'D:\oradata\REDO11.LO G';

2- Then we add a new member to the group.

ALTER DATABASE ADD LOGFILE MEMBER 'D:\oradata\REDO11.LO G' TO GROUP 1;

This can be verified by query.

SELECT GROUP#,MEMBER FROM V$LOGFILE;

It can also be physically verified through the operating system.