7.6. Exam Essentials

Know how to detect database corruptions using ANALYZE and DBVERIFY. Make sure you understand how to detect database corruptions using the ANALYZE command against database objects like tables and indexes. You should be able to identify corruption using the DBVERIFY utility against datafiles.

Understand how to detect database corruptions using the DBMS_REPAIR package. Know how to detect database corruptions using the CHECK_OBJECT procedure in the DBMS_REPAIR package. Understand how to use many of the procedures in the DBMS_REPAIR package to resolve all aspects of database corruptions.

Know how to implement the DB_BLOCK_CHECKING initialization parameter to detect corruptions. Know how to set the DB_BLOCK_CHECKING initialization parameter. Understand how the DB_BLOCK_CHECKING parameter works to detect block corruptions.

Be able to repair corruptions with RMAN. Understand how to use RMAN to perform Block Media Recovery (BMR), when to use BMR, and its limitations.