How to delete old archive logs using RMAN Safely

Delete old archive logs  using RMAN

Many times as a DBA  , we may have  to delete old archive logs using RMAN. Here are few steps we can follow.

Delete one day old archive logs

RMAN > DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-1’;

Delete 30 day old archive logs

RMAN > DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-30’;

Delete archive logs which are already backed up 2 times to disk

RMAN > DELETE ARCHIVELOG ALL BACKED UP 2 TIMES to disk;

Delete archive logs until a particular sequence

RMAN > DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 270;

Force fully deleting Archivelogs

RMAN > DELETE FORCE ARCHIVELOG ALL BACKED UP 2 TIMES to disk;

Hope this helps

Wysheid Team

Leave a comment

Your email address will not be published. Required fields are marked *

We assure our best to meet up to your expectations

Your Feedback will help us

Glad That You Liked It

Your Feedback will help us to improve