Check the archivelog is deleted with view in Oracle

Check archivelog is marked as deleted in Oracle

select FIRST_TIME,SEQUENCE#,THREAD#,STATUS,DELETED,BACKUP_COUNT
from V$ARCHIVED_LOG
order by 3,1;

Check the expired archive and delete them with following commands:

RMAN> crosscheck archivelog all;
RMAN> list expired archivelog all;
RMAN> delete noprompt expired archivelog all;

Check the archive backup policy:

RMAN> show archivelog deletion policy;
RMAN> show archivelog backup copies;
RMAN> Show all;

Delete archive log for specific days:

RMAN> delete noprompt archivelog until time 'SYSDATE-100';
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply