Tuesday, August 26, 2008

Oracle Dataguard Standby - recovery hunging

Problem in Oracle 9.2.0.8 dataguard Standby:

ORA-00600: internal error code, arguments: [3020], [126207919], [1], [38584], [352663], [36], [], []
ORA-10567: Redo is inconsistent with data block (file# 30, block# 378799)
ORA-10564: tablespace INDEX01
ORA-01110: data file 30: '/dev/rsprod_index11'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 82018
MRP0: Background Media Recovery process shutdown


Action Plan:

Standby and production uses raw devices
1) Make IMAGE copy of datafile 30 using rman on PRIMARY
rman target / catalog username/password@rman
RMAN>COPY DATAFILE 30 TO '/oracle/sprod1/arch/rsprod_index11';

2) sftp this image file '/oracle/sprod1/arch/rsprod_index11' to STANDBY server location '/oracle/sprod1/arch/rsprod_index11'

3) On standby, shutdown all instances and Copy '/oracle/sprod1/arch/rsprod_index11' to raw device using DD command
dd if=/oracle/sprod1/arch/sprod_index11 of=/dev/rsprod_index11 bs=4096 seek=1

4) Start recovery.
Note: FOR AIX use BS=4096 Metalink Note:178965.1

No comments: