How to recover from a loss of one redo log member of a multiplexed group

Loss of one member of current redolog group:

 

Rename/remove log file:

-

Check alert log for error: it shows error 

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: ' /u001/test_db/multiplex/redologfile/redo01b.log'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

-

It show Status = Invalid for lost redolog file.

-

We can’t drop a redolog member of Current group.

-

Solution: switch logfile; drop the lost member; re-add the dropped member to group.

Drop logfile member:

-

Add logfile again:

-

-

Switch logfiles to make newly added logfile to valid status:

-

Recovery complete.