[Installing Oracle Database 12c Release 1 on Microsoft Windows 2008 Server]: Setting FAST RECOVERY AREA Parameters

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

sqlplus / as sysdba

SQL> show parameter db_recovery;

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0

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

SQL> alter system set db_recovery_file_dest="f:\app\oracle\oradata\ora121\backups";

SQL> show parameter db_recovery;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      f:\app\oracle\oradata\ora121\backups
db_recovery_file_dest_size           big integer 20G