My Oracle Support Banner

DBMS_REPAIR example (Doc ID 68013.1)

Last updated on JUNE 13, 2021

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document provides an example of DBMS_REPAIR as introduced in Oracle 8i.
Oracle provides different methods for detecting and correcting data block corruption - DBMS_REPAIR is one option.

WARNING: Any corruption that involves the loss of data requires analysis to understand how that data fits into the overall database system. Depending on
the nature of the repair, you may lose data and logical inconsistencies can be introduced; therefore you need to carefully weigh the gains and losses
associated with using DBMS_REPAIR.

Scope

This article is intended to assist an experienced DBA working with an Oracle Worldwide Support analyst only. This article does not contain general
information regarding the DBMS_REPAIR package, rather it is designed to provide sample code that can be customized by the user (with the assistance of
an Oracle support analyst) to address database corruption.

The "Detecting and Repairing Data Block Corruption" Chapter of the Oracle Database Administrator's Guide should be read and risk assessment analyzed prior to
proceeding.

 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.