ORA-10567: Redo is inconsistent with data block (file# 4, block# 2, file offset is 16384 bytes)
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.