Tag Archives: Add the redo log

ORA-00354: corrupt redo log block header

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;