To increase Oracle FRA capacity, first determine whether the constraint is the Oracle quota, DB_RECOVERY_FILE_DEST_SIZE, or the actual filesystem or ASM storage beneath it. Raising the quota does not create physical storage. Increase the quota only when backing storage has room; expand storage when that is what is full. For a separate archive destination, provision its storage or change the destination only after checking recovery and standby requirements.
Identify what is full
The fast recovery area (FRA) is a configured location for recovery-related files. DB_RECOVERY_FILE_DEST_SIZE sets Oracle’s hard limit for files counted against that area; it is not a measurement of free space on the underlying disk. Oracle defines it as the hard limit on total space used by target database recovery files in the FRA (Oracle AI Database Reference, release 23).
As an Amazon Associate I earn from qualifying purchases.
Before changing anything, inspect the configured FRA location and quota, the active archive destinations, and actual free capacity on the relevant filesystem or ASM disk group. A full FRA quota with free backing storage calls for a quota change. A full filesystem or disk group calls for more or different storage; increasing the quota alone cannot resolve it. If archived logs go to a separate destination, assess that destination’s capacity independently.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Size the FRA for the recovery plan
Choose a quota based on the recovery files the installation is meant to retain, including archived redo logs, flashback logs, and any local database backups kept in the FRA. Account for other databases if they share the same storage, and monitor their combined use (Oracle Database Configuration Best Practices).
#1 Best Overall
The quota is not the physical capacity requirement. Oracle excludes block 0 and operating-system file headers from its quota calculation and advises allowing an additional 10% for that overhead (Oracle AI Database Reference, release 23). Mirroring and other storage overhead can increase the backing capacity required further. In ASM, for example, logical file sizes and raw disk consumption can differ. Check the actual storage layout rather than treating the FRA quota as a raw-disk target.
Oracle’s current Backup and Recovery User’s Guide says to set the FRA size before its location. The location can be a filesystem directory or an ASM disk group, but not a raw disk (Oracle AI Database Backup and Recovery User’s Guide, dated January 20, 2026). Oracle’s Database 19c recovery-settings tutorial recommends placing the FRA on a storage device separate from database files; whether that is appropriate depends on the deployment architecture (Oracle Database 19c Configure Recovery Settings tutorial).
Increase the FRA quota when storage is available
Oracle documents DB_RECOVERY_FILE_DEST_SIZE as dynamically modifiable with ALTER SYSTEM. The parameter reference demonstrates setting a value with units such as G (Oracle AI Database Reference, release 23). For example, a suitably authorized administrator could use:
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problemsALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 200G SCOPE=BOTH;200G is an illustrative value, not a recommended size. Choose a value supported by the recovery plan and the real capacity of the backing storage. Check the exact syntax and persistence options against the database release, startup configuration, and local operating procedures. This parameter cannot be modified in a PDB. In Oracle RAC, it must have the same value for every instance; coordinate the change accordingly.
When the archive destination itself is the constraint
Archived redo logs may go to a local filesystem path, an ASM disk group, the FRA, or a remote service destination through LOG_ARCHIVE_DEST_n. To direct a local destination to the FRA, Oracle supports USE_DB_RECOVERY_FILE_DEST. A configured FRA may also be selected automatically as a local archive destination if no local archive destination is specified, so do not assume the FRA is—or is not—the active target without checking the configuration. See Oracle Database 19c Administrator’s Guide and Oracle Database 26 Managing Archived Redo Log Files.
If a non-FRA filesystem or ASM destination is physically full, add or expand its storage, or configure a suitable alternative destination as the recovery design allows. Do not redirect logs solely to relieve pressure without considering recovery and standby requirements. Oracle’s Database 19c guide says archive destination parameter changes take effect at the next automatic or manual log switch, so allow for that activation timing (Oracle Database 19c Administrator’s Guide).
Rank #4
Verify the change
- Confirm the resulting FRA quota and location, and verify that RAC instances have the same quota where applicable.
- Check free capacity on the underlying filesystem or ASM disk group, including storage overhead and any shared database use.
- Inspect archive destination configuration and status to establish where logs are being written.
- After the change becomes active, verify that archiving completes successfully and that the destination has adequate remaining capacity.
The parameter details cited here span Oracle AI Database releases 23 and 26 and Oracle Database 19c documentation. Confirm the command and behavior for the exact release and topology in use.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Quick Recap
Best Value
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
