ORA-00742: Log read detects

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)

Solution 1:

1.You can try to clean the archive redo log with following commands:

alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;

 
2. Switch the logfile for verify:

alter system switch logfile;

  

Solution 2:

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 openSQL> 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;

Advertisements

2 thoughts on “ORA-00742: Log read detects

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s