DB_RECOVERY_FILE_DEST

Property	Description
Parameter type	String
Syntax	DB_RECOVERY_FILE_DEST = directory | disk group
Default value	There is no default value.
Modifiable	ALTER SYSTEM ... SID='*'
Basic	Yes
Real Application Clusters	You must set this parameter for every instance, and multiple instances must have the same value.

DB_RECOVERY_FILE_DEST specifies the default location for the flash recovery area. The flash recovery area contains multiplexed copies of current control files and online redo logs, as well as archived redo logs, flashback logs, and RMAN backups.

Specifying this parameter without also specifying the DB_RECOVERY_FILE_DEST_SIZE initialization parameter is not allowed.

Note:

1. This parameter was introduced in 10g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘DB_RECOVERY_FILE_DEST’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
db_recovery_file_dest		TRUE	FALSE	IMMEDIATE	FALSE	FALSE	default database recovery file location

Oracle initializatoin parameters