ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 归档日志损坏验证:Corrupt archivelog giving unclear errors [ID 1359971.1]

归档日志损坏验证:Corrupt archivelog giving unclear errors [ID 1359971.1]

原创 Linux操作系统 作者:尛样儿 时间:2012-12-17 20:23:44 0 删除 编辑

Corrupt archivelog giving unclear errors [ID 1359971.1]
修改时间:2012-1-12类型:PROBLEM状态:PUBLISHED优先级:3

In this Document
  Symptoms
  Cause
  Solution


Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms


Recovery of database is failing.
DBV shows no corruption.

Errors:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/15/2011 14:39:19
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/b101/app/oraprod/arch/1_1844_712525167.dbf'
ORA-00283: recovery session canceled due to errors
ORA-12801: error signaled in parallel query server P005
ORA-10562: Error occurred while applying redo to data block (file# 30, block# 183309)
ORA-10564: tablespace XXDM
ORA-01110: data file 30: '/l101/app/oraprod/data/xxdm02.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 581266
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump

Cause

The archivelog was corrupt
alter system dump logfile '{name of failing log}' validate;
returned many issues

Customer restored to another site with a new copy of the log and was successfull

Solution

Although the error messages do not indicate a corrupt archivelog, that turned out to be the case.

If you are getting similar errors then dump validate (as above) the log.

To fix the problem replace the corrupt archivelog with a good copy.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23135684/viewspace-751236/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle数据库管理员,Oracle数据库系统构架员;2012年7月出版《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》一书;Oracle 10g OCM。

注册时间:2010-01-05

  • 博文量
    483
  • 访问量
    5259518