My Oracle Support Banner

FAQ: Physical Corruption (Doc ID 403747.1)

Last updated on AUGUST 04, 2018

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]
Information in this document applies to any platform.
***Checked for relevance on 15-Oct-2014***

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.

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