Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

ORA-10567: Redo is inconsistent with data block (file# 124, block# 214081)

Posted by Hendry chinnapparaj on February 21, 2011

 

ORA-10567: Redo is inconsistent with data block (file# 124, block# 214081)

Problem

———–

The following errors occurs in standby database – seen in oracle alert log

Completed: ALTER DATABASE RECOVER  managed standby database using current logfile disconnect

Sat Feb 19 08:19:13 2011

Errors in file /u01/oracle/admin/zoeprd/bdump/zoeprd_p000_1470606.trc:

ORA-00600: internal error code, arguments: [3020], [124], [214081], [520307777], [], [], [], []

ORA-10567: Redo is inconsistent with data block (file# 124, block# 214081)

ORA-10564: tablespace ZOE_LM_INDEX_1M

ORA-01110: data file 124: ‘/u02/oradata/zoeprd/ZOE_LM_INDEX_1M_01.DBF’

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

Sat Feb 19 08:19:13 2011

Errors in file /u01/oracle/admin/zoeprd/bdump/zoeprd_p002_757812.trc:

ORA-00600: internal error code, arguments: [3020], [2], [43149], [8431757], [], [], [], []

ORA-10567: Redo is inconsistent with data block (file# 2, block# 43149)

ORA-10564: tablespace UNDOTBS1

ORA-01110: data file 2: ‘/u02/oradata/zoeprd/undotbs01.dbf’

ORA-10560: block type ‘KTU UNDO BLOCK’

Sat Feb 19 08:19:13 2011

Errors in file /u01/oracle/admin/zoeprd/bdump/zoeprd_p001_1200318.trc:

ORA-00600: internal error code, arguments: [3020], [466], [15128], [1954560792], [], [], [], []

ORA-10567: Redo is inconsistent with data block (file# 466, block# 15128)

ORA-10564: tablespace DOCIDX021

ORA-01110: data file 466: ‘/u02/oradata/zoeprd/DOCIDX021_01.DBF’

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

Sat Feb 19 08:19:15 2011

Errors in file /u01/oracle/admin/zoeprd/bdump/zoeprd_p000_1470606.trc:

ORA-00600: internal error code, arguments: [3020], [124], [214081], [520307777], [], [], [], []

ORA-10567: Redo is inconsistent with data block (file# 124, block# 214081)

ORA-10564: tablespace ZOE_LM_INDEX_1M

ORA-01110: data file 124: ‘/u02/oradata/zoeprd/ZOE_LM_INDEX_1M_01.DBF’

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

Sat Feb 19 08:19:15 2011

Errors in file /u01/oracle/admin/zoeprd/bdump/zoeprd_p002_757812.trc:

ORA-00600: internal error code, arguments: [3020], [2], [43149], [8431757], [], [], [], []

ORA-10567: Redo is inconsistent with data block (file# 2, block# 43149)

ORA-10564: tablespace UNDOTBS1

ORA-01110: data file 2: ‘/u02/oradata/zoeprd/undotbs01.dbf’

ORA-10560: block type ‘KTU UNDO BLOCK’

Sat Feb 19 08:19:15 2011

Errors in file /u01/oracle/admin/zoeprd/bdump/zoeprd_p001_1200318.trc:

ORA-00600: internal error code, arguments: [3020], [466], [15128], [1954560792], [], [], [], []

ORA-10567: Redo is inconsistent with data block (file# 466, block# 15128)

ORA-10564: tablespace DOCIDX021

ORA-01110: data file 466: ‘/u02/oradata/zoeprd/DOCIDX021_01.DBF’

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

Sat Feb 19 08:19:16 2011

MRP0: Background Media Recovery terminated with error 12801

Sat Feb 19 08:19:16 2011

 

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.

 

 

Fix:-

——–

 

Get the files from the primary and syncup the standby as below

 

There are 3 files affected

File numbers are 466, 124 and 2

1) You have to find out the tablespace name related to this datafiles

‘/u02/oradata/zoeprd/DOCIDX021_01.DBF’ ==> File 466
‘/u02/oradata/zoeprd/ZOE_LM_INDEX_1M_01.DBF’ ==> File 124
‘/u02/oradata/zoeprd/undotbs01.dbf’ ===> File 2

From primary sql> select tablespace_name from dba_data_files where file_name = ‘/u02/oradata/zoeprd/DOCIDX021_01.DBF’ ;
do the same for rest of 2 files also..

2) From primary sql> ALTER tablespace <tablespacename> begin backup;

3) Copy (SCP/FTP) the datafile file from PRIMARY to STANDBY

 

 

ftp <stby server name>

4) From primary sql> ALTER tablespace <tablespacename> end backup;

5) Start the recovery in standby
recover managed standby database using current logfile disconnect;
6) monitor the alert log if any issues

 

 

 

 

 

 

 

 

 

 

 

 

 

Advertisements

One Response to “ORA-10567: Redo is inconsistent with data block (file# 124, block# 214081)”

  1. […] https://hendrydasan.wordpress.com/2011/02/21/ora-10567-redo-is-inconsistent-with-data-block-file-124-… […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: