RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
RMAN执行下列命令时报错:
RMAN> backup database format='/data/rman/%U.bak' plus archivelog delete input;
Starting backup at 2016-10-31 11:49:56
current log archived
using channel ORA_DISK_1
trying alternate file for archived log of thread 1 with sequence 316
RMAN-00571:==================================================
RMAN-00569:============ ERROR MESSAGE STACK FOLLOWS===============
RMAN00571:==================================================
RMAN-03002: failure of backup plus archivelog command at 10/31/2016 11:49:56
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/disk1/arch_1_914598477_383.log
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
原因:之前自己手动用rm命令删掉了归档日志。但是controlfile中还记录着归档日志信息,oracle还会去找这些归档日志文件,因此就会报错。
解决方法:使控制文件中的归档日志信息和实际物理文件信息保持一致;
1. corsscheck archivelog all;
此命令用来检查控制文件和实际物理文件信息的差异。
2.delete expired archivelog all;
删除无效的归档日志信息,使检查控制文件和实际物理文件信息同步。
提示:以上为个人在学习过程中遇到此问题时的解决方法,仅供参考,如有任何问题,请指出。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31378892/viewspace-2128143/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31378892/viewspace-2128143/