How to fix the Oracle error ORA-38705: Expected block size string does not match string in log header.?

In this post, you’ll learn more about the Oracle ErrorORA-38705: Expected block size string does not match string in log header. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-38705: Expected block size string does not match string in log header.

Reason for the Error ORA-38705: Expected block size string does not match string in log header.

When the flashback log file header was read, the block size in the control file did not match the block size contained in the header.

How to fix the Error ORA-38705: Expected block size string does not match string in log header. ?

You can fix this error in Oracle by following the below steps

If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.