1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. DB_RECOVERY_FILE_DEST_SIZE

1.89 DB_RECOVERY_FILE_DEST_SIZE

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 fast recovery area.

Property Description

Parameter type

Big integer

Syntax

DB_RECOVERY_FILE_DEST_SIZE = integer [K | M | G]

Default value

0

Modifiable

ALTER SYSTEM ... SID='*'

Modifiable in a PDB

No

Basic

Yes

Oracle RAC

You must set this parameter for every instance, and multiple instances must have the same value.

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 fast recovery area.

See Also: