Database Reference
In-Depth Information
Flash Recovery Area
Flash Recovery Area is a single place (folder) for all the
recovery-related files. One single location approach provides
easy manageability. In this location we can have all the
following files required in the recovery operation.
Control Files: One of copy of control file is saved at Flash
Recovery Area at the time of creation of database.
RMAN backup sets & Image Copies: Flash Recovery Area
serves the default location on the disk for RMAN backup sets
and image copies.
Data Files: When RMAN BACKUP AS COPY is used, the
default location of data files will be Flash Recovery Area.
Control File and SPFILE: Under RMAN back-up process,
control file and SPFILE get backed up to this location
automatically.
Archived Log Files: When the Flash Recovery Area is
configured, the ARCn processes create archived log files at this
location.
Flashback Logs: When flashback is enabled, flashback logs are
generated. These flashback logs are saved at this location.
How to Enable/Disable Flash Recovery Area?
Setting up following two initialization parameters activates the
Flash Recovery Area.
DB_RECOVERY_FILE_DEST_SIZE
DB_RECOVERY_FILE_DEST
DB_RECOVERY_FILE_DEST_SIZE should be large enough to
hold a copy of all data files, archived log files, incremental
Search WWH ::
Custom Search