Fast Recovery Area
Oracle Fast Recovery Area: Set db_recovery_file_dest
Mar 7, 2026 / · 10 min read · oracle dba backup recovery flashback fast recovery area alter system dynamic parameters fra v$recovery_file_dest v$recovery_area_usage ·Oracle Fast Recovery Area: Set DB Recovery File Dest and Size Purpose The Oracle Fast Recovery Area (FRA) is a disk location where Oracle keeps files related to backup and recovery. Two dynamic initialization parameters, db_recovery_file_dest and db_recovery_file_dest_size, control its location and its disk quota. …
Read MoreDB_FLASHBACK_RETENTION_TARGET: Set Oracle Flashback Window
Mar 6, 2026 / · 5 min read · Oracle Flashback DBA Recovery Database Administration ALTER SYSTEM Fast Recovery Area Point In Time Recovery v$database ·Set Oracle Flashback Database Retention Target with ALTER SYSTEM Oracle Flashback Database lets you rewind your entire database to a past point in time without a full restore. The command ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET controls how far back in time that rewind can go. What This Command Does The …
Read More