Standby Database errors in alert ORA-12801ORA-00600 ORA-10567 ORA-10564 ORA-01110 ORA-10561

If your MRP process stop on standby database with errors like below:


Errors in file /dbmid/admin/XXX/bdump/bwmdpr1_mrp0_1646.trc:
ORA-12801: error signaled in parallel query server P007, instance hostname055:XXX1 (1)
ORA-00600: internal error code, arguments: [3020], [37], [1277558], [156466806], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 37, block# 1277558)
ORA-10564: tablespace TS_XXX_INDEX_M
ORA-01110: data file 37: '+DG_XXX_DATA/xxx/datafile/tsin_xxx_index_m.dbf'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 135950
Wed Aug 21 15:24:02 2013
MRP0: Background Media Recovery process shutdown (XXXR1)


Action Plan:

1-Check the object in primary database
select OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_TYPE 
     from DBA_OBJECTS 
     where DATA_OBJECT_ID = 135950;

In My case it was an index and was not corrupted on primary database.

2-Start recover of standby allowing one corruption using this command below:

SQL> alter database recover automatic standby database allow 1 corruption;

Best Regards,
Paulo Portugal