delete archivelog in RMAN

step1 enter RMAN command

$ rman target /

step2 check all archivelog

RMAN> crosscheck archivelog all;

step3 list all invalid archivelog

RMAN> list expired archivelog all;

step4 delete expired archivelog

RMAN> delete noprompt expired archivelog all;

——————————————————————–

RMAN> crosscheck archivelog all;
RMAN> delete noprompt expired archivelog all;
RMAN> delete noprompt archivelog until time ‘sysdate-1’;

RMAN> delete all archivelogs which before log sequence 16
RAMN> delete archivelog until sequence 16;

#delete archivelog before 7 days
RMAN> delete archivelog all completed before ‘sysdate-7’;

#delete archivelog in 3 days.
delete archivelog from time ‘sysdate-3’;

#delete all archivelog
RMAN> delete noprompt archivelog all completed before ‘sysdate’;
or
RMAN> delete noprompt archivelog all;

Leave a Reply