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

最新推荐文章于 2022-07-15 17:53:46 发布

转载最新推荐文章于 2022-07-15 17:53:46 发布 · 231 阅读

本文介绍了一个在使用RMAN进行归档日志备份时遇到的错误及其解决方法。错误原因是手工删除了归档日志，导致控制文件记录与实际情况不符。通过RMAN命令检查并清理过期的日志记录，更新控制文件。

因手工删除归档日志，在使用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博客 ” ，链接：http://blog.itpub.net/35489/viewspace-628318/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-628318/