ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 备份归档日志报错ORA-19625: crosscheck archivelog all

备份归档日志报错ORA-19625: crosscheck archivelog all

原创 Linux操作系统 作者:tolywang 时间:2010-03-02 08:39:15 0 删除 编辑

因手工删除归档日志,在使用RMAN进行归档日志备份的时候报如下错误:
RMAN> backup database plus archivelog delete input;

Starting backup at 08-FEB-09
current log archived
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=17 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/08/2009 08:28:19
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/oracle/arch1_2.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

解决方法:
$ rman target / nocatalog
RMAN> crosscheck archivelog all;  

 

------------------------------------------------------------------------ 



What is your method of deleting your previous archivelogs? Is it OS command?
If OS command, your controlfile might not be updated so it treats that those archivelogs are still available in your disk. You should update your controlfile when deleting archivelogs using OS command.

RMAN> crosscheck archivelog all; // validate all archvelogs in your disk. If some are missing, it will treat it as expired.
RMAN> delete expired archivelog all; // it ill delete expired archivelog and updates your controlfile.

 

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

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    14696043