We got the below error in one of our physical standby databases today.

ORA-10567: Redo is inconsistent with data block

[adrotate banner=”1″]

Problem Description :

ORA-00600: internal error code, arguments: [3020], [4], [2], [16777218], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 4, block# 2, file offset is 16384 bytes)
ORA-10564: tablespace USERS
ORA-01110: data file 4: ‘/u02/PRMRY/users01.dbf’
ORA-10560: block type ‘KTFB Bitmapped File Space Header’
Errors in file /u02/app/oracle/diag/rdbms/stdby/STDBY/trace/STDBY_mrp0_4026.trc (incident=16285):

Oracle Documentation says,

10567, 00000, “Redo is inconsistent with data block (file# %s, block# %s)”
// *Cause: There are two possible causes of this error: (1) A write issued
// by Oracle was lost by the underlying OS or storage system.
// (2) an Oracle internal error.
// *Action: Investigate why the error occurred and how important is the data
// block. Media and standby database recovery usually can continue
// if user allows recovery to corrupt this data block.

Solution :

On primary database

1.ALTER tablespace USERS begin backup;

2.copy users01.dbf datafile from a primary database to standby database

On primary database

3.ALTER tablespace USERS end backup;

on standby database start recovery

4. alter database recover managed standby database using current logfile disconnect;

 

You can learn complete Oracle 11g Course here – Oracle 11g step by step guide

Words from dbapath

Thank you for giving your valuable time to read the above information. I hope the content served your purpose in reaching out the blog.
Suggestions for improvement of the blog are highly appreciable. Please contact us for any information/suggestion/feedback.

If you want to be updated with all our articles

please follow us on Facebook | Twitter
Please subscribe to our newsletter.