OEM 13.3 upgrade to 13.5

 

RMAN Archive log delete

 

RMAN Archive Log Delete

Archive Log List:

RMAN> list archivelog all;
RMAN> list copy of archivelog until time 'SYSDATE-15';
RMAN> list copy of archivelog from time ‘SYSDATE-15′
RMAN> list copy of archivelog from time ‘SYSDATE-15′ until time ‘SYSDATE-1′;
RMAN> list copy of archivelog from sequence 1200;
RMAN> list copy of archivelog until sequence 1200;
RMAN> list copy of archivelog from sequence 1000 until sequence 1500;

Archive Log Delete:

RMAN> delete archivelog all;
RMAN> delete archivelog until time ‘SYSDATE-10′;
RMAN> delete archivelog from time ‘SYSDATE-10′
RMAN> delete archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;
RMAN> delete archivelog from sequence 1100;
RMAN> delete archivelog until sequence 1300;
RMAN> delete archivelog from sequence 1000 until sequence 1500;

select name from SYS.V_$ARCHIVED_LOG;
I use the following archive log delete command, and that solve my purpose:

RMAN> delete noprompt archivelog all completed before 'SYSDATE-3' backed up 01 times to device type disk;
RMAN> DELETE FORCE NOPROMPT OBSOLETE RECOVERY WINDOW OF 2 DAYS DEVICE TYPE DISK;
RMAN> DELETE FORCE NOPROMPT OBSOLETE REDUNDANCY = 2 DEVICE TYPE DISK;
RMAN> DELETE NOPROMPT FORCE ARCHIVELOG UNTIL TIME 'SYSDATE-1' DEVICE TYPE DISK;
RMAN> DELETE NOPROMPT FORCE ARCHIVELOG UNTIL TIME 'SYSDATE-1/2' DEVICE TYPE DISK;
RMAN> DELETE NOPROMPT FORCE ARCHIVELOG UNTIL SEQUENCE 260 DEVICE TYPE DISK;