set NLS_DATE_FORMAT=YYYYMMDD HH24:MI:SS
Archivelog List Commands:
list archivelog all;
list copy of archivelog until time 'SYSDATE-1';
list copy of archivelog from time 'SYSDATE-1';
list copy of archivelog from time 'SYSDATE-1' until time 'SYSDATE-2';
list copy of archivelog from sequence 1000;
list copy of archivelog until sequence 1500;
list copy of archivelog from sequence 1000 until sequence 1500;
Archivelog Delete Commands:
delete archivelog all;
delete archivelog until time 'SYSDATE-1';
delete archivelog from time 'SYSDATE-1';
delete archivelog from time 'SYSDATE-1' until time 'SYSDATE-2';
delete archivelog from sequence 1000;
delete archivelog until sequence 1500;
delete archivelog from sequence 1000 until sequence 1500;
Note : Use noprompt to avoid being prompted for each file
delete noprompt archivelog until time 'SYSDATE-1';
Use FORCE if you try to delete the archive log files which are not backed up:
delete FORCE archivelog until time 'SYSDATE-1';
|