ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rman备份出现ORA-19625

rman备份出现ORA-19625

原创 Linux操作系统 作者:zwc1083 时间:2009-02-26 08:35:23 0 删除 编辑
[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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-02-16

  • 博文量
    91
  • 访问量
    43580