DB version: 11.2.0.4
OS: Oracle Linux 6.5
In this particular DB, we have multiplexed our redo logs (2 members in each redo group).
If just one member of a Redo log group is corrupted then, regardless of whether the member belonged to the group which is CURRENT, ACTIVE or INACTIVE, can we just DROP and CREATE the lost log file member to this group by following the below steps ?
-- Find the corrupted member
SELECT GROUP#, STATUS, MEMBER FROM V$LOGFILE WHERE STATUS='INVALID';
1. BACKUP the DB
2. ALTER SYSTEM CHECKPOINT;
3. ALTER DATABASE CLEAR LOGFILE GROUP 3; ---- This step shouldn't be run. Right ?
4. ALTER DATABASE DROP LOGFILE MEMBER '/oracle/oradata/wms/redo02.log';
(Apparently,this command does not delete the LOGFILE at OS Level; only the control file is updated within the DB)
5. ALTER DATABASE ADD LOGFILE MEMBER '/oracle/oradata/wms/redo02b.log' TO GROUP 3;
When I googled for steps, I found the below table in Oracle's official documentation. This table is applicable only if the entire REDO LOG GROUP is gone.
http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/osadvsce.htm#CACFJDBG
I just want steps if only 1 member from a multiplexed group is lost/corrupted.