Please follow the below steps.

Steps :

1. Shutdown immediate;

2. Physically remove redo log member(no redo log group) by using OS level command.

3. Startup;

4. SELECT GROUP#, STATUS, MEMBER FROM v$LOGFILE WHERE STATUS=’INVALID’;

5. Check alert log file.

Steps for Recovery :

1. Drop the damaged member

ALTER DATABASE DROP LOGFILE MEMBER ‘D:\app\admin\oradata\orcl\REDO01.LOG’;

2.If you get error like ORA-01609 – ALTER SYSTEM SWITCH LOGFILE;

3. Add a new member to the group.

ALTER DATABASE ADD LOGFILE MEMBER ‘D:\app\admin\oradata\orcl\REDO01.LOG’ TO
GROUP 1;

OR

A.  If the file you want to add already exists, then it must be the same size as the other group members, and you must
      specify REUSE.

B. For example:
ALTER DATABASE ADD LOGFILE MEMBER ‘D:\app\admin\oradata\orcl\REDO01.LOG’ REUSE TO GROUP 1;

Enjoy…

Leave a Reply