My Oracle Support Banner

FAQ: Physical Corruption (Doc ID 403747.1)

Last updated on AUGUST 31, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.3 [Release 8.1.7 to 11.2]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
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
Information in this document applies to any platform.

Purpose



To understand the cause of physical corruptions introduced in an Oracle database.

Questions and Answers

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

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


In this Document
Purpose
Questions and Answers
 1. What are the symtoms of a physical corruption?
 2. What are the common corruption errors?
 3. How to check a physical corruption?
 4. How to identify the segment for the given corrupt block?
 5. How to understand if this is an Oracle problem?
 6. How restore / recover is going explain the cause?
 
7. What to do if restore/recover introduces the corruption?
 8. What to do if the restore/recover doesnot introduce the corruption?
 9. What all the parameters that we shall enable to have checkings in oracle side?
 10. A quick link to diagnostics / troubleshooting articles.
References

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