Contents
What happens when FRA is full?
b)If no archived logs are stored in the FRA, and the FRA gets full, then your database is not affected. Your backups will be affected, as those will fail. In this case you will have to increase the FRA and/or delete obsole backups.
What is flash recovery area?
Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database backup & recovery related files and performs those activities in Oracle databases. Unified Backup Files Storage, all backup components can be stored in one consolidated spot.
How do I check my flash recovery area?
Checking the current usage You can check the configuration by looking at two parameters. The current FRA usage can be checked with the views v$recovery_area_usage (for each file type) and v$recovery_file_dest (for overall size and usage).
Where is flash recovery area?
Query the V$RECOVERY_FILE_DEST view to find out the current location, disk quota, space in use, space reclaimable by deleting files, and total number of files in the flash recovery area.
How to resolve a full flash recovery area?
You have a number of choices on how to resolve a full flash recovery area when there are no files eligible for deletion: Make more disk space available, and increase DB_RECOVERY_FILE_DEST_SIZE to reflect the new space. Move backups from the flash recovery area to a tertiary device such as tape.
Where can I find ora-19816 flash recovery area?
ORA-19816: WARNING: Files may exist in location that are not known to database. where location is the location of the flash recovery area. In such a situation, you should use the RMAN command CATALOG RECOVERY AREA to re-catalog any such files so that they appear in the RMAN repository.
Where are the transient files in flash recovery manager?
The permanent files (control files and online redo log files), flashback logs and transient files can be left in the old flash recovery area location. The database will delete the transient files from the old flash recovery area location as they become eligible for deletion.
Is there a way to back up flashback logs?
After you transfer backups from the flash recovery area to tape, you can resolve the full recovery area condition by deleting files from the flash recovery area, using forms of the RMAN DELETE command. Flashback logs, by design, cannot be backed up outside the flash recovery area.