My Oracle Support Banner

Best Practices for Corruption Detection, Prevention, and Automatic Repair - in a Data Guard Configuration (Doc ID 1302539.1)

Last updated on MAY 07, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 12.1.0.1 [Release 11.1 to 12.1]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.3.0.0.0 [Release 12.1 to 19]
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
Information in this document applies to any platform.

Purpose

Oracle Active Data Guard is a data protection and availability solution for the Oracle Database. The purpose of this document is to provide Database Administrators best practice recommendations for configuring key parameters, database features, system features and operational practices to enable best corruption detection, prevention, and automatic repair, in a MAA or Data Guard configuration for on-premise or in the cloud. This note also provides:


1. additional background information on each parameter with performance considerations and relevant Oracle documentation references
2. clarity on what’s default in the database, in Exadata or in Oracle cloud and recommended MAA settings.

Scope

This document is intended for Database Administrators wanting to learn how to prevent, detect and automatically repair from various data block corruptions.


A corrupt block is a block that has been changed so that it differs from what Oracle Database expects to find. This note covers two data block corruption types:

Block corruptions can also be divided into interblock corruption and intrablock corruption:

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!


In this Document
Purpose
Scope
Details
 Causes of corrupted blocks
 Corruption Summary
 Deploy Primary and Standby on Oracle Exadata Database Machine and Exadata Storage Servers
 Deploy Oracle Data Integrity eXtensions (DIX) with T10 Data Integrity Field (DIF) when not on Exadata
 General Guidance on Performance Trade-offs
 DB_BLOCK_CHECKSUM- Background
 DB_BLOCK_CHECKING - Background
 DB_LOST_WRITE_PROTECT - Background
 Shadow Lost Write Protection
 Oracle Automatic Storage Management (ASM) - Background
 Oracle Flashback Technologies - Background
 Oracle Data Guard
 Additional Operational Practices to detect block corruptions
References

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