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;

Advertisements

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.