Downtime Announcement: Please note the SAP Community Wiki will be unavailable due to a system upgrade on Thursday, September 24th between 6 and 7 AM CEST
Skip to end of metadata
Go to start of metadata

 

Purpose

For those who are not very familiar with analyze methods and steps to perform in case of Block Corruption issues. Following the points below in the given order is advisable as this guides through and gives basic and intermediate informations. But it does not provide solution.

Overview

This document summarizes the steps for questions like 'What to do?','Which tools to use?',"How to perform the check?",etc.

Summary and general procedure of a Consistency Check / Analyze / Solution

  1. General Information
  2. Detecting Corrupted Blocks
  3. Consistency Check with 'ANALYZE' command
  4. Consistency Check with DBV
  5. Consistency Check with RMAN
  6. Consistency Check with Data Pump
  7. Which object is stored in the corrupted block(s)
  8. Checks found corrupted blocks. What to do now

Related SAP Notes/KBAs

SAP Note 23345 - Consistency check of ORACLE database

SAP note 365481 - Block corruptions

SAP note 1116190 - Handling of database corruptions by SAP Support