Delete obsolet/expired archivelog records in RMAN repository

Posted on 2012-08-24
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

    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 36

    Expert Comment

    by:Geert Gruwez
    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    Via a live example, show how to take different types of Oracle backups using RMAN.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now