Chapter 7. Handling Block Corruption

ORACLE DATABASE 10G: ADMINISTRATION II EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Dealing with Database Corruption

    • Define block corruption and list its causes and symptoms.

    • Detect database corruptions using the following utilities: ANALYZE and DBVERIFY.

    • Detect database corruptions using the DBMS_REPAIR package.

    • Implement the DB_BLOCK_CHECKING parameter to detect corruptions.

    • Repair corruptions using RMAN.

NOTE

Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.



This chapter provides a detailed explanation and walk-through of techniques and utilities designed to deal with physical corruption. We will discuss and use the ANALYZE TABLE table_name command, the DBVERIFY utility, the DB_BLOCK_CHECKING initialization parameter, and the DBMS_REPAIR package. These utilities and methods are not new to Oracle 10g ; most of them have been available since Oracle versions 7 and 8i. We will walk through some examples of using best practices for dealing with physical corruption. Additionally, you will use RMAN Block Media Recovery (BMR) to repair block corruption. This is a new Oracle 10g capability in RMAN.

This chapter concentrates on the workings of each of the preceding methods to identify and resolve physical corruption at the block level. The overview of the block corruption will explain how this occurs at a high level. We will also discuss how to identify block corruption and following that, we will demonstrate how to use each tool and utility to resolve block corruption.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset