Oracle RMAN 丢失归档日志：ORA-19625: error identifying file

最新推荐文章于 2024-01-29 11:10:49 发布

原创

最新推荐文章于 2024-01-29 11:10:49 发布 · 1.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #validation #file #disk #centos #database

在CentOS 5.6上使用Oracle RMAN备份时遇到ORA-19625错误，原因是归档日志文件被删除。解决方法是执行交叉检测（crosscheck），通过验证剩余的归档日志文件，然后重新备份，问题得到解决。

在CentOS 5.6 x64 平台备份时出现错误：

RMAN> backup archivelog all format='/opt/oracle/backup/arch_%T_%s_%p.bak';

Starting backup at 31-AUG-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=11 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/31/2011 23:52:25
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /data/oracle/fast_recovery_area/DB1/archivelog/2011_08_30/o1_mf_1_5_75t010tk_.arc
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

由于先前开户归档时生成的一个o1_m