Configuring the Size of the Fast Recovery Area
To evaluate the space needed for the FRA. The amount of disk space to allocate for FRA depends on the size and activity levels of your database.
-
- Ideally, the FRA should be large enough for copies of your data and control files, as well as for flashbacks, online redo and archived logs needed to recover the database with the backups kept based on the retention policy.
- FRA should be at least twice the size of the database so that it can hold one backup and several achieved logs.
- The DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters values are not null meaning the fast recovery area is enabled.
- we can change the location and size of the fast recovery area and no need to restart for change because the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters are dynamic.
SQL> show parameter recover NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/fast_recovery_ area/ORCL db_recovery_file_dest_size big integer 12918M db_unrecoverable_scn_tracking boolean TRUE recovery_parallelism integer 0 remote_recovery_file_dest string SQL> alter system set db_recovery_file_dest_size = 12G scope=both; System altered. SQL> show parameter recover NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/fast_recovery_ area/ORCL db_recovery_file_dest_size big integer 12G db_unrecoverable_scn_tracking boolean TRUE recovery_parallelism integer 0 remote_recovery_file_dest string SQL> alter system set db_recovery_file_dest = '/u01/app/oracle/' scope=both; System altered. SQL> show parameter recover NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/ db_recovery_file_dest_size big integer 12G db_unrecoverable_scn_tracking boolean TRUE recovery_parallelism integer 0 remote_recovery_file_dest string SQL> alter system set db_recovery_file_dest = '/u01/app/oracle/fast_recovery_area/ORCL' scope=both; System altered. SQL> show parameter recover NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/fast_recovery_ area/ORCL db_recovery_file_dest_size big integer 12G db_unrecoverable_scn_tracking boolean TRUE recovery_parallelism integer 0 remote_recovery_file_dest string SQL>