ORA-00742: Log read detects ( corrupt Redo header )
Oracle database is not open, when i tried to open the database it’s crashed, up to 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)
Solution 1:
1.You can try to clean the archive redo log with following commands:2. Switch the logfile for verify:
alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;Solution 2:
alter system switch logfile;
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
SQL> ALTER DATABASE DROP LOGFILE GROUP 3;
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:
SQL>RECOVER DATABASE UNTIL CANCEL;
Media recovery complete.
3. open the database:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
Database altered.
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;