DB_RECOVERY_FILE_DEST_SIZE

Property	Description
Parameter type	Big integer
Syntax	DB_RECOVERY_FILE_DEST_SIZE = integer [K | M | G]
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_SIZE specifies (in bytes) the hard limit on the total space to be used by target database recovery files created in the flash recovery area.
Note that neither block 0 nor the OS block header of each Oracle file is included in this size. Allow an extra 10% for this data when computing the actual disk usage required for the flash recovery area.
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_SIZE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
db_recovery_file_dest_size	0	TRUE	FALSE	IMMEDIATE	FALSE	FALSE	database recovery files size limit

Oracle initializatoin parameters

More Oracle DBA tips, please visit Oracle DBA Tips