RMAN-03002 RMAN-06059 ORA-19625

发布时间:2024年01月05日

有个现场经理反馈,每天的rman备份异常,登录系统查看rman的log日志,报错信息如下

RMAN> run{
2>?? backup filesperset 50 archivelog all format '/backup/ARCHBAK_%d_%T_%s' tag arch_bak delete all input;
3>??? }
4>
Starting backup at 31-OCT-23
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2272 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 10/31/2023 01:10:02
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /archivelog/orcl/1_39800_999027762.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

处理办法:在rman中执行 crosscheck archivelog all; 执行后再次备份正常,

了解了情况是这样:某个周五晚上,客户的nas空间出问题了,现场担心归档可能会满,直接rm -rf删除了部分归档。之后备份就异常了。

优化了rman备份脚本,增加了一条命令 crosscheck archivelog all;

文章来源:https://blog.csdn.net/kevinyu998/article/details/135414110
本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。