Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

deleted archive logs thru RMAN but still show in v$archived_log

Ratzie
Super Advisor

deleted archive logs thru RMAN but still show in v$archived_log

I deleted archive logs thru RMAN and they are removed from the system. But, when I select * from v$archived_log the NAME is blank?

What does this mean?
3 REPLIES
Ratzie
Super Advisor

Re: deleted archive logs thru RMAN but still show in v$archived_log

OK more reading:
An archive log record is inserted after the online redo log is successfully archived or cleared (name column is NULL if the log was cleared).
So how do I remove those entries?
Is there a purge?
Michael Steele_2
Honored Contributor

Re: deleted archive logs thru RMAN but still show in v$archived_log

Archive logs should be removed automatically after a backup with rman and crosscheck scipts. But the procedure varies from versions by oracle versions. For example:

RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt;
RMAN> CROSSCHECK BACKUP OF TABLESPACE user_data COMPLETED BEFORE 'SYSDATE-14'; RMAN> DELETE NOPROMPT EXPIRED BACKUP OF TABLESPACE user_data COMPLETED BEFORE 'SYSDATE-14';
RMAN> DELETE BACKUP OF DATABASE LIKE '/tmp%';
RMAN> DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;
RMAN> DELETE BACKUPSET 101, 102, 103;
RMAN> DELETE CONTROLFILECOPY '/tmp/cntrlfile.copy';
RMAN> DELETE BACKUP OF SPFILE TABLESPACE users DEVICE TYPE sbt;

http://www.ss64.com/ora/rman_delete.html
Support Fatherhood - Stop Family Law
Ratzie
Super Advisor

Re: deleted archive logs thru RMAN but still show in v$archived_log

Yes I understand that, but I we are using oracle streams and can not delete the archive logs if streams are not finish with it.

This is why I did a backup, then deleted all archives older then 3 days.
But I still need to understand why the name is blank and how to purge...