DBA Hub

📋Steps in this guide1/1

delete archive older than 1 day

DELETE ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-1'; CROSSCHECK ARCHIVELOG ALL; DELETE EXPIRED ARCHIVELOG ALL;

oracle configurationintermediate
by OracleDba
13 views
1

delete archive older than 1 day

Code/Command (click line numbers to comment):

1
2
3
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-1';
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!