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…
