RMAN Commands related to Archive Logs

RMAN Commands related to Archive Logs

I am sharing handy commands which can be helpful when working with archive logs.

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 18600; 

list copy of archivelog until sequence 20000; 

list copy of archivelog from sequence 18600 until sequence 20000; 

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 18600; 

delete archivelog until sequence 20000; 

delete archivelog from sequence 18600 until sequence 20000; 

Use noprompt to avoid being prompted for each file

delete noprompt archivelog until time 'SYSDATE-1';

Use for Force option to forcefully deleting the archives

delete force noprompt archivelog until time 'SYSDATE-1';

If you like please follow and comment