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去备份的时候，找不到这个归档就出错了。可用以下方法解决：

处理: 0 U- V- h; y, U$ @6 k
可以在rman命令行执行下面检查语句后再做备份：: e: }# C9 v; p; w

RMAN> change archivelog all crosscheck;  

RMAN>list expired archivelog all;

RMAN>delete expired archivelog all;

然后再运行备份脚本,即可顺利进行.

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

转载于:http://blog.itpub.net/14876437/viewspace-557867/