Configuring and Backing Up Oracle Databases Using RMAN - OCP: Oracle Database 12c Administrator Certified Professional - page 117

indicate that your database can consume only up to 100GB of space within the FRA while
assigning the FRA to the 500GB file system.
You use the ALTER SYSTEM command to configure the FRA. Note that DB_RECOVERY_
FILE_DEST is not dynamic, while DB_RECOVERY_FILE_DEST_SIZE is dynamic. To configure
the FRA, do the following:
1. Create the base FRA directory:
/u01>mkdir /oracle01/fra
2. Log into SQL*Plus:
C:\oracle\orabackup\orcl>sqlplus sys as sysdba
C:\Users\Robert>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Feb 20 13:52:34 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
SQL>
3. Use the ALTER SYSTEM command to set the parameter DB_RECOVERY_FILE_DEST to /
oracle01/fra and DB_RECOVERY_FILE_DEST_SIZE to 2GB.
sql>alter system set db_recovery_file_dest_size=2GB scope=both;
sql>alter system set db_recovery_file_dest='/oracle01/fra' scope=spfile;
4. Shut down and restart the database. Once the database has been restarted, the FRA
will become operational.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 397557760 bytes
Fixed Size 1333452 bytes
Variable Size 268437300 bytes
Database Buffers 121634816 bytes
Redo Buffers 6152192 bytes
Database mounted.
Database opened.