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 ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.