Configuring Flash Recovery Area Space Parameters for Oracle

The Oracle Flash Recovery Area (FRA) can potentially run out of space, so it is important to regularly schedule backups for Flash Recovery Area to media.

Procedure

  1. Modify the Flash Recovery Area size using the following SQL statement:

    alter system set db_recovery_file_dest_size = <new size>

  2. Configure your retention policy using the following command from RMAN prompt:

    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF n days --- where n is the number of days

  3. Configure the archived log deletion policy using the following command from RMAN prompt:

    CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP n TIMES TO SBT --- where n is the number of times

  4. All the files in FRA location that meet the Retention criteria are set as obsolete. FRA location is not cleaned up automatically until all the space in FRA is full even after meeting the FRA retention policies. The obsolete pieces are pruned when there is a need for additional space. Use the following to verify the usage of FRA space:

    V$FLASH_RECOVERY_AREA_USAGE;