Issue:

Database is in Flashback Mode.

Enabled No logging on some db Tables

Recover the database.

Truncate those no logging Temporary tables.

Now we get error message ORA-1578: ORACLE data block corrupted

Reason:

Oracle says it is a behavior in 10g and fixed in 11g Rel1.

Cannot Reuse a Corrupt Block in Flashback Mode, ORA-1578 [ID 729433.1]

In 11g (11.1 releases) there is an optimization introduced to skip the block read if the object was dropped before the flashback retention range, and this will help with corrupt blocks on disk.

Comments are closed.