[Oracle DataBase Server 12.2 Installation on Oracle Linux 7.4]: Setting FAST RECOVERY AREA Parameters


Fast Recovery Area (FRA) is space for database backups and archive log files (if redo log archiving mode is enabled). It is necessary to ensure that the database has enough space to write its data. If necessary, it can be increased and/or cleaned of outdated data. Cleaning can only be done using RMAN.


$ sqlplus / as sysdba



SQL> alter system set db_recovery_file_dest_size="20G";



SQL> alter system set db_recovery_file_dest="/u03/oracle/oradata/12.2/orcl12/backups";



SQL> show parameter db_recovery;



SQL> show parameter db_recovery;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest		     string	 /u03/oracle/oradata/12.2/orcl12/backups
db_recovery_file_dest_size	     big integer 20G



SQL> exit