flash_recovery_area full-- how do you use RMAN to delete directories of .arc files

Posted on 2008-11-09
Last Modified: 2012-05-05
About a week ago we turned archivelog mode on in an 11g oracle server.  The flash_recovery_area is now full, and redo logs can't be archived, so the database won't open.

I need to delete some of the dated directories containing the .arc files using rman.  What is the exact process for connecting using rman and for deleting these directories?

Also-- I use dbconsole to RMAN to backup the database to local disk, and Computer Associates Arcserve to backup to tape.  I expected the archivelogs to be deleted (like they are truncated in MS SQL server) when a backup is done.  Is this not a correct expectation?

I've read that one can also free up space by backing up components of the flash_recovery_area.  I can only do this to disk.  Anyone know exactly the complete correct syntax for rman?
Question by:dakota5
    LVL 16

    Accepted Solution

    FRA should be automatically managed. However, if this fails, you can use the following methods to free up space.

    Log into RMAN in a command shell

    Assuming you're on Linux/Unix

    export ORACLE_SID=<sid>

    rman target /

    You should now be in RMAN CLI (Command Line Interface)

    Show all;
    This will show you all configured persistent settings. What you want to watch is RETENTION POLICY. Make sure this is not set to some ridiculous value. You may need to adjust this parameter to a more acceptable value like RECOVERY WINDOW OF 5 DAYS

    One this is set (or if the the current setting is acceptable), now run the following commands:

    crosscheck database;
    crosscheck archivelog all;
    delete noprompt expired archivelog all;
    delete noprompt obsolete;
    delete noprompt expired backup;

    These commands should free up space for you by reclaiming the space from redundant backups according to you backup policy.

    Finally, when you issue the backup database command in RMAN, I always backup the archivelogs at the same time and then delete the backed-up archivelogs in one command as follows:

    RMAN> backup database plus archivelog delete input;

    Without this command, if you use FRA for your archivelogs, you may run into space issues.

    LVL 6

    Assisted Solution

    Here are som useful commands:

    -find backupset to be deleted.
    RMAN> list backup of database summary;

    RMAN> list backupset 123;

    RMAN> delete backupset 123;

    SQL> SELECT object_type, message_type, message_level,
    reason, suggested_action
    FROM dba_outstanding_alerts;

    The following actions can be done to resolve the space issue :
    - Add disk space to the Flash Recovery Area.
    - Back up your files to a tertiary device.
    - Delete the files from the Flash Recovery Area using RMAN.
    - Changing RMAN retention policy. If you are using Data Guard, then consider changing

    The database handles a Flash Recovery Area with insufficient reclaimable space  just as it handles a disk full condition. Often, the result is a hang of the database.

    To free space in the FRA, use command BACKUP RECOVERY AREA.
    This command will take the backup of al the files in the FRA to tape only.
    After this the space occupied by the files in the FRA will be marked as reclaimable.

    RMAN> backup recovery area;

    If you deleted files via OS then use RMAN CROSSCHECK.

    Read more:
    Metalink-notes: 305812.1 , 401163.1 , 305817.1 and 315098.1

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

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

    Suggested Solutions

    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    761 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

    12 Experts available now in Live!

    Get 1:1 Help Now