ORA-10567: Redo is inconsistent with data block

来源：互联网发布：昆明网页美工培训编辑：程序博客网时间：2024/05/29 10:07

这两天在做DG升级，备库应用日志的时候遭遇了以下问题：

Media Recovery Log /export/11g/flash_recovery_area/ORCL2/archivelog/2015_02_08/o1_mf_1_34_bfgq6snb_.arcHex dump of (file 3, block 160) in trace file /export/11g/diag/rdbms/orcl2/orcl/trace/orcl_mrp0_26811.trcReading datafile '/export/11g/oradata/orcl/undotbs01.dbf' for corruption at rdba: 0x00c000a0 (file 3, block 160)Reread (file 3, block 160) found different corrupt data (logically corrupt)Hex dump of (file 3, block 160) in trace file /export/11g/diag/rdbms/orcl2/orcl/trace/orcl_mrp0_26811.trcErrors in file /export/11g/diag/rdbms/orcl2/orcl/trace/orcl_mrp0_26811.trc  (incident=12227):ORA-00600: internal error code, arguments: [3020], [3], [160], [12583072], [], [], [], [], [], [], [], []ORA-10567: Redo is inconsistent with data block (file# 3, block# 160, file offset is 1310720 bytes)ORA-10564: tablespace UNDOTBS1ORA-01110: data file 3: '/export/11g/oradata/orcl/undotbs01.dbf'ORA-10560: block type 'KTU SMU HEADER BLOCK'Incident details in: /export/11g/diag/rdbms/orcl2/orcl/incident/incdir_12227/orcl_mrp0_26811_i12227.trcCompleted: alter database recover managed standby database using current logfile disconnectUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.MRP0: Background Media Recovery terminated with error 600Errors in file /export/11g/diag/rdbms/orcl2/orcl/trace/orcl_mrp0_26811.trc:ORA-00600: internal error code, arguments: [3020], [3], [160], [12583072], [], [], [], [], [], [], [], []<span style="color:#ff0000;">ORA-10567: Redo is inconsistent with data block (file# 3, block# 160, file offset is 1310720 bytes)</span>ORA-10564: tablespace UNDOTBS1ORA-01110: data file 3: '/export/11g/oradata/orcl/undotbs01.dbf'ORA-10560: block type 'KTU SMU HEADER BLOCK'Managed Standby Recovery not using Real Time Apply

从错误信息来看，是redo与数据库不一致造成的，网上查找资料，有人通过从主库将相应的数据文件考到备库，然后在应用日志，心里没谱，打算尝试一把

</pre><pre name="code" class="html">

—— 主库：
SQL> alter tablespace UNDOTBS1 begin backup;

—— 备库
SQL> alter database datafile 2 offline drop;

[oracle@st orcl]$ mv sysaux01.dbf sysaux01.dbf.bak

—— 主库

[oracle@pr orcl]$ scp undotbs01.dbf oracle@192.168.233.129:/export/11g/oradata/orcl/

—— 备库

SQL> alter database datafile 2 online;

Database altered.

SQL> alter database recover managed standby database disconnect from session;

没有报错了。

0 0