Tag Archives: How to identify corrupts blocks in the database

How to identify corrupts blocks in the Oracle database and correct it

Last updated on July 28th, 2019 at 07:58 amThere are two type of corruption. a. Physical corruption: This happens generally due to media corruption. In this case,block does have invalid checksum.it may contains zero. This is generally the result of infrastructure issue like media,network ,memory. RMAN block recover can be used to remove physical corruption We see the error ORA-01578: ORACLE data block corrupted in … Continue reading How to identify corrupts blocks in the Oracle database and correct it »