Rman备份是实际工作中经常用到的技术,下面是工作中遇到的报错:
RMAN-00571: ===================================================
RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS ================
RMAN-00571: ===================================================
RMAN-03002: failure of backup command at 08/13/2012 02:32:55
RMAN-06726: could not locate archived log /archive/1_25286_709912966.dbf
RMAN-00571: ===================================================
RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS ================
RMAN-00571: ===================================================
RMAN-03002: failure of backup command at 08/13/2012 02:32:55
RMAN-06726: could not locate archived log /archive/1_25286_709912966.dbf
根据RMAN-06726的提示/archive/1_25286_709912966.dbf没找到,通过ls -lrt 查询
1_25286_709912966.dbf是早期的归档日志,已经不存在了。
解决办法:
RMAN>crosscheck archivelog all;##检查所有归档日志##
RMAN>delete noprompt expired archivelog all;##删除过期归档##
验证:手动执行RMAN备份脚本,查看log没有报错!
解决办法:
RMAN>crosscheck archivelog all;##检查所有归档日志##
RMAN>delete noprompt expired archivelog all;##删除过期归档##
验证:手动执行RMAN备份脚本,查看log没有报错!
向Secooler 致敬!
Johnson
12.8.15
12.8.15
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20985606/viewspace-741305/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20985606/viewspace-741305/