Delete obsolet/expired archivelog records in RMAN repository

Posted on 2012-08-24
Medium Priority
Last Modified: 2012-10-01
Hello experts,

I have a question regarding cleaning up the RMAN repository. I have a space issue on my backup disk location (FRA) after every daily backup I do a crosscheck of the database, control files and archivelog log files then I perform a delete obsolete/expired on these files. Also before the backup I delete yesterday's backup files in the (FRA). When I sign on to RMAN and do a 'list archivelogs all' I get a full list of archivelogs when I do a 'list backup;' I get the available list of the database files and control file but I get long list of backup archivelogs with the status of 'available' when these files have been removed from the FRA.

Why is this happening, does this increase the number of records in my RMAN repository, and will this increase cause my RMAN repository to be ineffiecient.

Question by:7Souls
LVL 12

Accepted Solution

Praveen Kumar Chandrashekatr earned 750 total points
ID: 38332422
make it clear delete archive log from RMAN is really deleting the archive or not ? if its deleting then you need to have different combinations like
RMAN>delete archivelog all completed before 'sysdate';
RMAN>delete archivelog all completed before 'sysdate-7';

also check how frequently is your archive logs created which is filling up your FRA and increase the size of your FRA.
LVL 38

Expert Comment

by:Geert Gruwez
ID: 38336743
you need to run a
crosscheck archivelog all completed before 'sysdate-7';
to check the status of the archivelogs

and then run the delete operation

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question