OCP Blog
Super DBA
ORA-10567: Redo is inconsistent with data block (file# 25, block# 7652)
by Vazha Mantua Wednesday, March 9, 2011 10:57 AM

Good morning all,

 

On of our standby database stop apply process with error ORA-10567: Redo is inconsistent with data block (file# 25, block# 7652).

 

ORA-10567: Redo is inconsistent with data block (file# 25, block# 7652)

ORA-10564: tablespace USER_DATA

ORA-01110: data file 124: ‘/u01/oradata/ORAST/USER_DATA_01.DBF’

ORA-10561: block type ‘TRANSACTION MANAGED INDEX BLOCK’, data object# 7652

 

Cause

The Redo when shipped across network or somewhere along the way had some issues which caused the inconsistency, hence not able to syncup with the standby datafiles.

 

Solution

On primary database

1.ALTER tablespace USER_DATA begin backup;

2.copy USER_DATA01.dbf datafile from primary DB to standby DB

On primary database

3.ALTER tablespace USER_DATA end backup;

on standby database start recovery

4. recover managed standby database using current logfile disconnect;

 

Remark: Does not do this operation when production database has pick load, begin backup can decrease DB performance

Tags: ,

Comments (6) -

11/22/2011 6:00:03 AM #

Bad credit repair service

I really loved this brilliant article. Please continue this awesome work.

Bad credit repair service United States

1/17/2012 7:29:14 AM #

electricians Sydney

You made some good points there. I did a search on the topic and found most people will agree with your blog.

electricians Sydney United States

3/6/2012 12:10:42 PM #

Mercurial Superfly III

Such is the love<strong><a href=http://www.gotsoccercleats.com/>Mercurial Superfly III</a></strong>     that Middlesbrough and Sunderland fans have for Julio Arca, both sets of supporters will sing his <strong><a href=http://www.gotsoccercleats.com/>Vapor Superfly 3</a></strong>name before Wednesday¡¯s FA Cup replay at the Riverside

Mercurial Superfly III People's Republic of China

3/7/2012 6:00:34 AM #

Mercurial Superfly III

Such is the love<strong><a href=http://www.gotsoccercleats.com/>Mercurial Superfly III</a></strong>     that Middlesbrough and Sunderland fans have for Julio Arca, both sets of supporters will sing his <strong><a href=http://www.gotsoccercleats.com/>Vapor Superfly 3</a></strong>name before Wednesday’s FA Cup replay at the Riverside.

Mercurial Superfly III People's Republic of China

3/8/2012 4:13:28 AM #

carpet dry cleaning melbourne

This is my second visit to this blog. We are starting a new initiative in the same category as this blog. Your blog provided us with important information to work on. You have done a marvellous job.

carpet dry cleaning melbourne United States

6/3/2012 2:27:45 AM #

Directory Submission Service

ORA-10561: block type ‘TRANSACTION MANAGED INDEX BLOCK’, data object# 7652

Directory Submission Service United Kingdom

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  November 2019  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

View posts in large calendar

TextBox