Flash Recovery Area

The Flash Recovery Area  is a unified storage location for all recovery related files and activities in an Oracle database.

To enable Flash Recovery Area you just need to specify 2 parameters in the following order:

        - DB_RECOVERY_FILE_DEST_SIZE (specifies max space to use)

        - DB_RECOVERY_FILE_DEST (Location)

You can check current settings by issuing "show parameter" in sqlplus prompt.

eg: show parameter DB_RECOVERY_FILE_DEST_SIZE

You can specify those parameters in the init.ora file or by ALTER SYSTEM SET command with the scope=both option.

Examples:

ALTER SYSTEM SET db_recovery_file_dest_size=10G scope=both;

ALTER SYSTEM SET db_recovery_file_dest='/oradata/flash_recovery_area';