Init parameterBackup & recovery

DB_RECOVERY_FILE_DEST_SIZE

What it controls

The most space the Fast Recovery Area may use.

Know this before you change it

Oracle treats this as the limit even if the disk has more room. Reaching it stops archiving (ORA-00257).

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'db_recovery_file_dest_size';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'db_recovery_file_dest_size' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET db_recovery_file_dest_size = 500G SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET db_recovery_file_dest_size SCOPE = SPFILE SID = '*';

Related scripts

• Fast Recovery Area usageFRA size, used and reclaimable space, then what's using it by file type. Real used % is the number that matters: at 100% the database stops archiving…
• Archived redo generated per dayCount and size of archived logs for the last 14 days, from the local destination only so standby copies aren't double-counted. Useful for sizing the…

Open in the parameter referenceOracle's reference

More in Backup & recovery

• DB_RECOVERY_FILE_DESTLocation of the Fast Recovery Area, for archived logs, backups and flashback logs.
• DB_FLASHBACK_RETENTION_TARGETMinutes of flashback logs to keep for Flashback Database.
• CONTROL_FILE_RECORD_KEEP_TIMEDays that reusable backup and archived log records stay in the control file.
• DB_BLOCK_CHECKSUMWhether blocks carry a checksum that's verified on read.
• DB_BLOCK_CHECKINGLogical consistency checks on blocks when they change.
• DB_LOST_WRITE_PROTECTRecords block versions in redo so lost writes can be detected.