How to identify corrupts blocks in the database

There 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 […]