First page Back Continue Last page Graphics
Flash Recovery Area: Configuration
Set location
Set space limit
- Maximum space dedicated to flashback area
- database size + size of incremental backups + size of all archive logs not backed up to tape
If Flashback Database desired, set retention limit
- How far back can we flashback database?
Notes:
Set the space limit (size), location, and retention limit (in minutes) for flashback logs (if flashback database capability is desired) when establishing the flash recovery area. Since this is a recovery-related area, keep this on separate disk devices from the database files.
Note: The size *db_recovery_file_dest_size) must be altered before the destination, otherwise an ORA-19802 error is returned.
Refer to Section 3.2 of the Oracle Database Backup and Recovery Basics 10g Release 2 manual and Chapter 5 of the Oracle Database Backup and Recovery Advanced User's Guide 10g Release 2 for more information on configuring the Flash Recovery Area.
Supplemental Notes
The Database Configuration Assistant supports the configuration of the Flash Recovery Area.
The LOG_ARCHIVE_START parameter is deprecated in Oracle10g.