rman备份出现ORA-19625

[oracle@sunny stage]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Mar 18 17:21:22 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1141870147)

 

RMAN> backup archivelog all;

Starting backup at 18-MAR-07
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/18/2007 17:52:42
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/1_2_616734317.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

 

原因在于操作系统下删除了这个归档日志，这个日志还没备份过，rman去备份的时候，找不到这个归档就出错了。可用以下方法解决：

 

RMAN> change archivelog all crosscheck;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=152 devtype=DISK
validation succeeded for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_02_12/o1_mf_1_1_2x01h9c2_.arc recid=1 stam
p=614355305
validation succeeded for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_02_13/o1_mf_1_2_2x147xxt_.arc recid=2 stam
p=614390912
validation succeeded for archived log

......

......
archive log Crosschecked 27 objects

然后再执行备份即可