How to delete archived log files past one week in RMAN

[clio_usa]

You can also use:

allocate channel for maintenance type disk;
crosscheck backup of archivedlogs completed between 'sysdate - 30' and 'sysdate - 7';
delete expired backup;
release channel;
exit;

In 8i, that still has be run from RMAN> command prompt. In 9i, you can do it from script.


Hope that helps,

clio_usa - OCP 8/8i/9i DBA

Visit our Web Site