一.问题起因
2014/10/14接某客户反馈,备份数据库的crontab执行失败。远程连接分析后发现是因为2014/09/13灾备演练过后dataguard参数没有正确调整导致的归档未清理,过多归档备份时因空间不足而失败。详细过程如下
二.日志分析
1.登陆后检查备份日志后发现数据文件备份成功但是备份归档时失败:
including current SPFILE in backup set channel c1: starting piece 1 at 13-OCT-14 channel c1: finished piece 1 at 13-OCT-14 piece handle=/backup/addrrman/full_ADDRPROD_20141013_14004_1 tag=TAG20141013T220005 comment=NONE channel c1: backup set complete, elapsed time: 00:00:01 channel c2: finished piece 1 at 13-OCT-14 piece handle=/backup/addrrman/full_ADDRPROD_20141013_14001_1 tag=TAG20141013T220005 comment=NONE channel c2: backup set complete, elapsed time: 01:45:12 channel c3: finished piece 1 at 13-OCT-14 piece handle=/backup/addrrman/full_ADDRPROD_20141013_14002_1 tag=TAG20141013T220005 comment=NONE channel c3: backup set complete, elapsed time: 01:46:01 Finished backup at 13-OCT-14 sql statement: alter system archive log current 。。。。skip ..... released channel: c1 released channel: c2 released channel: c3 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on c3 channel at 10/14/2014 00