Init parameterBackup & recovery

DB_RECOVERY_FILE_DEST

What it controls

Location of the Fast Recovery Area, for archived logs, backups and flashback logs.

Know this before you change it

Set DB_RECOVERY_FILE_DEST_SIZE first; Oracle won't accept the location without it.

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'db_recovery_file_dest';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'db_recovery_file_dest' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET db_recovery_file_dest = '+FRA' 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 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…

Open in the parameter referenceOracle's reference

More in Backup & recovery

• DB_RECOVERY_FILE_DEST_SIZEThe most space the Fast Recovery Area may use.
• 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.