How to fix the error ORA-00354: corrupt redo log block header?
In this post, you’ll learn more about the Oracle ErrorORA-00354: corrupt redo log block header with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-00354: corrupt redo log block header
Reason for the Error ORA-00354: corrupt redo log block header
The block header on the redo block indicated by the accompanying error, is not reasonable.
How to fix the Error ORA-00354: corrupt redo log block header ?
You can fix this error in Oracle by following the below steps
Do recovery with a good version of the log or do time based recovery up to the indicated time. If this happens when archiving, archiving of the problem log can be skipped by clearing the log with the UNARCHIVED option. This must be followed by a backup of every datafile to insure recoverability of the database.
Leave Your Comment