ORA-1578: ORACLE data block corrupted
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.
