Some Generic ORA Errors related to Recovery

ORA-00742: Log read detects Lost write
Oracle database is not opening, while trying to open the database it’s crashed with this message:
Error in Alert Log File:
Errors in file E:\ORACLE12C\diag\rdbms\ic\ic\trace\ic_ora_4408.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 195 block 37645
ORA-00312: online log 4 thread 1: 'C:\ORACLE\ORADATA\FIDELIO\REDO04.LOG'
Wed Mar 15 18:20:39 2017
ARCH: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'D:\ORACLE\ARCHIVELOGS\ARC195_934509462_1.ARC' (error 742)

1. Open the database in Mount mode, as follows

2. Try to find the redo log status, as follows

we can see in the above output that Redo log group 2 is in Current State and this is the same redo log that is diagnosed with log read detects lost write. 

3. Then we try to recover the database, as per below command

Here we gave the path of the redo log which was shown up in the error.

4. Now we will open the database with resetlogs, as follows

Database was successfully altered.

5. Check the status of the open database, as follows

6. check the status of the redo logs, as follows

SELECT GROUP#, MEMBERS, STATUS, ARCHIVED FROM V$LOG;

Note : Please switch the logfile with the following command;

alter system switch logfile;