Setting FAST RECOVERY AREA for Oracle

Today I have a new database that was just cloned from a VM. I wanted to make improvements on it by putting a backup on both disk and tape.

The first command I use was to show the existing parameters on the database.

show parameter recovery

SQL> show parameter recovery

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

SQL>

We see that there is nothing set. The first thing we want to do is to set a recovery size and after that the destination.

SQL> alter system set db_recovery_file_dest_size=150G;

System altered.

SQL> alter system set db_recovery_file_dest ='/backup/fast_recovery_area';

System altered.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter db_reco

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /backup/fast_recovery_area
db_recovery_file_dest_size           big integer 150G
SQL> alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST';

System altered.