Contents
How do I check my Fra space?
Use the V$RECOVERY_FILE_DEST view to obtain the following information about the fast recovery area: total number of files, current location, disk quota, space in use, and space reclaimable by deleting files. The space details are in bytes. Querying V$RECOVERY_FILE_DEST produces the following output.
How do I check my FRA free space?
How do I delete old archive logs in RMAN?
In order to delete them you can do: RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; , you can also include the delete input clause when you back them up, and they will be deleted after they have been backed up (it is up to you).
What are the files in the flash recovery area?
In the Oracle database, the Flash Recovery Area or FRA is a location on disk where the database can create and manage several kinds of backup and recovery-related files. Main file types are archivelog, flashback log, backups, as well as mirrors for your control files and redo log files. All files in the FRA are Oracle-managed files.
Where to find archive logs in Oracle recovery area?
Setting log_archive_dest_N to the FRA directory is not the same as actually setting the FRA as an archivelog destination. The naming of archivelog files also confirms this, as archivelogs in the FRA are use OMF format, and they are actually placed in seperate directories (named based on the date) each day.
Why are archive logs taking up so much space?
We have cleared up all unneeded backups through the enterprise manager, but the Archive logs are still taking up over 50% of the allocated FRA space. Is it possible to delete some of the older archive logs to free up space?
How to fill up a fast recovery area?
If you configure a fast recovery area, then the database automatically deletes unneeded files in this area automatically First, determine if you are running out of space. For example using the following query (sample output included): If you are running out of space you have to either decrease your retention policy or increase the size of your FRA.