ORA-00742: Log read detects ( corrupt Redo header )
Oracle database is not open, when i tried to open the database it’s crashed, upto mount state its working fine.
When try to open fire it throw the following error in alert log:
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 3 thread 1: ‘E:\ORACLE12C\ORADATA\IC\REDO03B.LOG’
ORA-00312: online log 3 thread 1: ‘E:\ORACLE12C\ORADATA\IC\REDO03A.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.You can try to clean the archive redo log with following commands:
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;
2. Switch the logfile for verify:
Its seems to be redo log file corrupted during instance crash recovery or something else case.
1. Tried for drop the redo log and create new one
When fired upper command, it show me archiving is not completed for redo file,its not dropped my logfile group.
2. Recover the database with following command:
Media recovery complete.
3. open the database:
alter database open
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database openSQL> alter database open resetlogs;
4. Check the redo log files and fire switch command for more sure.
select MEMBER from v$logfile;SELECT GROUP#, MEMBERS, STATUS, ARCHIVED FROM V$LOG;
alter system switch logfile;