Oracle Rman Delete archivelog file older than N-day

rman target /
run{
allocate channel D1 type disk;
delete noprompt archivelog until time ‘SYSDATE-<N>‘;
release channel D1;
} ;

Example 2 day
run{
allocate channel D1 type disk;
delete noprompt archivelog until time ‘SYSDATE-2’;
release channel D1;
} ;

About tosasan

Just Me and my Bicycle
This entry was posted in ORACLE, RMAN and tagged . Bookmark the permalink.

Leave a comment