My Oracle Support Banner

How to Resolve Block Corruption on Standby when the block is in free space (Doc ID 2377843.1)

Last updated on AUGUST 01, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Corrupted blocks reported on Standby database.

Primary database is Corruption free .

Active dataguard feature not available .


Querying the block id on Primary confirms the blocks are in free space

 

Standby database reports

 

Select * from v$database_block_corruption ;

  FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO CON_ID
---------- ---------- ---------- ------------------ --------- ----------
  172 1354116 2 0 CORRUPT 0
  172 1716356 2 0 CORRUPT 0
  172 992900 2 0 CORRUPT 0

 



On Primary database

 

  

  

 

 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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