oracle rman不能自动删除归档日志备份解决

环境：oralce10g x64 ,suse10 x64

发现在日常备份中，rman无法将过期的归档日志备份删除，查相关资料，
delete noprompt backup completed before 'sysdate-2';    可通过该语句将所有备份记录删除，包括归档日志备份。

整理的脚本如下：


10 20 * * * su - oracle -c "/oracle/script/fullbackup.sh"
10 12 * * * su - oracle -c "/oracle/script/arcbk.sh"

先设置rman备份保留可恢复数据库到前两天的时间；
 RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 days;
 

oracle@ciqdb:~/script> cat fullbackup.sh
echo '=======start backup====================================='>>/rmanfs/rmandb.log
date >>/rmanfs/rmandb.log
$ORACLE_HOME/bin/rman target / log /rmanfs/rmandb.log append <<EOF
run {  
crosscheck backup;
delete noprompt expired backup device type disk;
allocate channel DISK_2 type disk format '/rmanfs/fulldb_%T_%u';
##backup  database  include current controlfile ;
backup as compressed backupset  
   ( database  include current controlfile );
}
allocate channel for maintenance device type disk;
delete noprompt archivelog until time 'sysdate - 8';
delete noprompt obsolete device type disk;
delete noprompt backup completed before 'sysdate-2';
EOF
date >>/rmanfs/rmandb.log
echo '======stop backup====================================-='>>/rmanfs/rmandb.log
oracle@ciqdb:~/script> cat arcbk.sh
echo '=======start backup====================================='>>/rmanfs/rmanarc.log
date >>/rmanfs/rmanarc.log
$ORACLE_HOME/bin/rman target / log /rmanfs/rmanarc.log append <<EOF
run {  
allocate channel DISK_2 type disk format '/rmanfs/arc_%T_%u';
##backup archivelog all not backed up 1 times;
backup as compressed backupset ( archivelog all);
}
allocate channel for maintenance device type disk;
delete noprompt obsolete device type disk;
EOF
date >>/rmanfs/rmanarc.log
echo '======stop backup====================================-='>>/rmanfs/rmanarc.log
oracle@ciqdb:~/script>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29519108/viewspace-1796243/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29519108/viewspace-1796243/