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.