Database Software

Hi all,

I have some problems regarding the retention policy of the archive logs backup (on Win2k3 and Oracle 9.2.0.4, RMAN, NOCATALOG).

Once per hour I run this RMAN script to backup the archive logs;

sql 'alter system archive log current';
backup
format 'E:\backup\ARCLOG_%d_%t_%s_%p'
archivelog all
delete all input;
exit;

Once per day I run these RMAN scripts:

BACKUP FULL:

backup
format 'E:\backup\OnLineFULL_%d_%t_%s_%p'
tag "Full OnLine Backup"
database
include current controlfile;
exit;

CROSSCHECK:

allocate channel for maintenance type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
exit;

MAINTENANCE

allocate channel for maintenance type disk;
report obsolete;
delete noprompt obsolete;
exit;

The retention policy is 'RECOVERY WINDOWS OF 3 DAYS'. After the maintenance scripts, I saw that the archive log backups are never automatically deleted using the retention policy specified. Is this right? How can I automatically delete the archive log backups using the same retention policy specified for full online backup?

Thank you very much for your help.

Stefano.

Message was edited by:
Stefano IT