Catching Corruption Early: DB_BLOCK_CHECKSUM TYPICAL vs FULL on Exadata

What DB_BLOCK_CHECKSUM really does, how TYPICAL and FULL differ, what Oracle recommends on Exadata, and the two companion parameters you should review at the same time.

Fully Recover Oracle Database from Block Corruption without backup

Disclaimer: The following recovery scenario is for a very specific case. It requires a comprehensive knowledge of the application schema design and the relationship between the different tables. It is not by any means valid for all block corruption cases. It not by any means a replacement for the regular database backups. Having a good … Continue reading Fully Recover Oracle Database from Block Corruption without backup