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>