Delete Archive Logs & Foreign Archive Logs

Delete ArchiveLog:

Below are the various commands to delete archive logs files

rman

connect target 

--connect catalog cat/pass@SID ----Optional

DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-10';

DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';

delete archivelog all backed up 1 times to DISK;  -----

DELETE force ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1'; -- 

REPORT OBSOLETE;

delete obsolete;

delete archivelog expired;

-----------

--if you face -- RMAN-06091: no channel allocated for maintenance (of an appropriate type)

allocate channel for maintenance type disk;

delete obsolete device type disk;

-----------

Delete Foreign ArchiveLog:

When You are using GoldenGate downstream or mining server then there will be situation where you will have foreign archivelog.

---Deleting Foreign Archive log

list foreign archivelog all;

crosscheck foreign archivelog all;

delete expired foreign archivelog  UNTIL TIME 'SYSDATE-3';

delete foreign archivelog until TIME 'SYSDATE-3';

delete foreign archivelog until TIME 'SYSDATE-2';