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 Fast Recovery Area, which corresponds to the initialization parameter db_recovery_file_dest. The value of this parameter provides the location at which Oracle maintains backups and online redo logs.

Element

Description

Specify Fast 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 must 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 Automatic Storage Management (ASM) disk groups if you selected the Automatic Storage Management option on the Move Database Files page.

Fast Recovery Area

Enter the path where you want to locate the fast recovery files.

Note: Fast Recovery Area configuration is optional except when you select Move or XE database. By default, existing values for Fast Recovery Area are retained if it is already configured. For Oracle Real Application Clusters (Oracle RAC) database instances, ensure that the path entered for the Fast Recovery Area files points to a shared location.

Fast 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 Fast Recovery Area size that is too small may hang the database when it cannot find space to store archived logs.

Related Topics

Overview of the Database Upgrade Assistant