Recovery Configuration

Use this page to provide mandatory XE recovery configuration and optional EE recovery configuration. When files are moved for XE or EE, you need to configure the database Flash Recovery Area, which corresponds to the init parameter db_recovery_file_dest. This is the location where backups and online redo logs are maintained.

Element

Description

Specify Flash Recovery Area

Select this option to specify a backup and recovery area and specify its directory location and size. This option is mandatory when database files are being moved for XE or EE databases. When files are moved, you need to configure a recovery area to locate the redo log files. The recovery area provides an alternative method of managing online and archived redo log files. This option is required for the move database file feature.

Note: Besides file system directories, the locations could also be ASM disk groups if you selected the Automatic Storage Management option on the Move Database Files page.

Flash Recovery Area Enter the path where you want to locate the flash recovery files.
Flash Recovery Area Size

There are no limitations on the recovery area size, which depends on the size of the database redo generation. However, Oracle recommends that the size should be at least twice the database size. A Flash Recovery Area size that is too small may hang the database when it cannot find space to store archived logs.