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:
Post a Comment