有个现场经理反馈,每天的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;