Re: Flashback Recovery area Full in Oracle 10g

Note that your query shows "reclaimable space" being the same value as used space. This means that Oracle knows all used space in the FRA can be reused, so you don't need any extra steps to reclaim it as Oracle will do it automatically.

One question though: did you take a full database backup? Because if you did, your archived logs before the backup are obsolete, otherwise they are still needed for media recovery. You say you moved the files from flash recovery area to a different location - but Oracle still expects the log files to be in the flash recovery area, so in case of media failure and subsequent media recovery you will need to copy them back to the flash recovery area. If you backed up the db, you can use RMAN to delete these obsolete logs (note that since you moved the files without notifying Oracle that you did, you may need to do a crosscheck before deleting obsolete files.) See the RMAN reference and Backup/Recovery guide for details. Deleting these files from the catalog will clean up FRA and you will no longer see 90 files there and used space will drop to zero.

As of how to switch archivelog destination back to FRA: you just ALTER SYSTEM SET
LOG_ARCHIVE_DEST_1='location=USE_DB_RECOVERY_FILE_DEST mandatory' and Oracle will archive to the FRA wherever it is configured.

Hth,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Mon May 22 2006 - 00:08:20 CDT