delete archive older than 1 day - Oracle Database Script. DELETE ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-1'; CROSSCHECK ARCHIVELOG ALL; DELETE EXPIRED ARCHIVELOG ALL;
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-1'; CROSSCHECK ARCHIVELOG ALL; DELETE EXPIRED ARCHIVELOG ALL;