Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
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...