ORA-00354: corrupt redo log block header

1 Reply

ORA-00354: corrupt redo log block header

Redo log file is corrupted in the Oracle Database during startup of the database getting the following error:


ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 574153 change 1364577452357 time 18/01/2019 1:43:45
ORA-00312: online log 4 thread 1: '/u2/oradata/orcl/redo4a.log'

Solution
1. Mounted the Database.

startup mount

2. Check the files present in logfile.

-- Check member, location and size of redo files
SELECT
a.GROUP#,
a.THREAD#,
a.SEQUENCE#,
a.ARCHIVED,
a.STATUS,
b.MEMBER AS REDOLOG_FILE_NAME,
(a.BYTES/1024/1024) AS SIZE_MB
FROM v$log a
JOIN v$logfile b ON a.Group#=b.Group#
ORDER BY a.GROUP#;

3. Drop the redo log group which having error.

alter database drop logfile group 4;

3. Add the redo log file as follows.

alter database add logfile group 4 '/u2/oradata/orcl/redo4a.log' size 250M reuse;

4. Open the database.

alter database open;

1 thought on “ORA-00354: corrupt redo log block header”

  1. Unknown's avatarAnonymous

    ORACLE Instance MTDEV, archival error, archiver continuing
    2026-06-29T10:52:47.212863+02:00
    Errors in file /u01/app/oracle_base/diag/rdbms/mtdev/MTDEV/trace/MTDEV_arc3_177542.trc:
    ORA-00354: corrupt redo log block header
    ORA-00353: log corruption near block 24582 change 2614085 time 06/25/2026 11:00:04
    ORA-00312: online log 2 thread 1: ‘+DATA/MTDEV/ONLINELOG/group_2.263.1236774135’
    2026-06-29T10:52:47.212914+02:00
    ARC3 (PID:177542): Error 354 while archiving
    2026-06-29T10:52:47.212964+02:00
    Closing local archive destination LOG_ARCHIVE_DEST_1 ‘+RECO/MTDEV/ARCHIVELOG/2026_06_29/thread_1_seq_19.257.1237296903’, error=354 (MTDEV)
    ARC3 (PID:177542): Abort creation of archive log ‘+RECO/MTDEV/ARCHIVELOG/2026_06_29/thread_1_seq_19.257.1237296903’, error:354
    2026-06-29T10:52:48.265944+02:00
    Deleted Oracle managed file +RECO/MTDEV/ARCHIVELOG/2026_06_29/thread_1_seq_19.257.1237296903
    2026-06-29T10:52:48.267173+02:00
    Incomplete read from log member ‘+DATA/MTDEV/ONLINELOG/group_1.262.1236774135’. Trying next member.
    2026-06-29T10:52:48.273537+02:00
    Errors in file /u01/app/oracle_base/diag/rdbms/mtdev/MTDEV/trace/MTDEV_arc3_177542.trc:
    ORA-16038: log 2 sequence# 19 cannot be archived
    ORA-00354: corrupt redo log block header
    ORA-00312: online log 2 thread 1: ‘+DATA/MTDEV/ONLINELOG/group_2.263.1236774135’
    2026-06-29T10:52:48.273611+02:00
    ARC3 (PID:177542): Archival error occurred on a closed thread, archiver continuing
    2026-06-29T10:52:48.273669+02:00
    ORACLE Instance MTDEV, archival error, archiver continuing
    2026-06-29T10:52:48.517015+02:00
    ARC0 (PID:177530): Log corruption near block 311300 SCN:0x0000000000257d24 time ?
    ARC0 (PID:177530): CORRUPTION DETECTED: T-1.S-16 LNO:1 at block 311300
    2026-06-29T10:52:48.559248+02:00

    Reply ↓

Leave a Reply