• Kiran Dalvi
• 25 Jul, 2021
• 0 Comments
• 36 Secs Read

Archive log Backup Command

In this blog, We will see the archive log backup command.

 

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 2000; 
list copy of archivelog until sequence 3000; 
list copy of archivelog from sequence 2000 until sequence 3000; 

Archivelog Delete Commands:

Following commands can be used to delete the old archive logs

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 2000; 
delete archivelog until sequence 3000; 
delete archivelog from sequence 2000 until sequence 3000;