Oracle RAC (Real Application Cluster)数据库备份失败报错:RMAN-06059: expected archived log not found。

book

Article ID: 100053278

calendar_today

Updated On:

Description

Error Message

Backup of Oracle RAC (Real Application Cluster) database(s) fails with the above error message and the following RMAN output:
Starting backup
current log archived
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 14:24:55
RMAN-06059: expected archived log not found, lost of archived log
compromises recoverability
ORA-19625: error identifying file /u02/oradata/scr9/archive/1_1160.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Cause

这是由于oracle自身的事务日志产生异常情况,该段事务日志有可能不连续或者出现系统内部语法错误进而RMAN备份识别异常。 

Resolution

请求DBA工程师清除掉事务日志文件夹内的所有日志log,然后进行crosscheck处理。

进入oracle命令控制台,输入如下命令:

$rman target /
RMAN>change archivelog all crosscheck;

操作完成后,重新执行备份任务可以正常完成。

Issue/Introduction

Oracle RAC (Real Application Cluster)数据库备份失败报错:RMAN-06059: expected archived log not found。