Collecting Diagnostic information for RCA in the Corruption area (Doc ID 435731.1)

Last updated on JUNE 14, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.0.0 to 12.1.0.1 [Release 7.3.0 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.
Information in this document applies to any platform.

Purpose

The document was created for collecting diagnostic information. Many customers request Root Cause Analysis when it comes to database corruption issues. This is a very serious matter and almost all situations are down database issues. Part of the analyst job is to make sure to collect the minimum information before resolving the issue as it will help in making sure we have most of the required information.

This document will assist analysts in collecting information required for diagnosing various types of corruptions.

This note is not for the customer and the premise around the note is that the analyst has some knowledge of corruptions and the tools involved. Please avoid to send the whole note to the customer; instead individual sections may be provided based on the corruption type. For example if there is a block corruption in a TABLE, post the data block corruption section in the issue.