Managing the Flash Recovery Area
Oracle Database 11g XE stores database backups, redo logfiles, and archive redo logfiles in Flash Recovery Area (FRA). Optionally you can place a member of the multiplexed control file in FRA. The V$RECOVERY_FILE_DEST view provides details of FRA location and usage. Run the following query to determine the FRA details:
SQL> set line 100
SQL> column name format a45
SQL>
SQL> SELECT name,
2 ROUND(space_limit/1024/1024) space_limit,
3 ROUND(space_used/1024/1024) space_used,
4 ROUND(space_reclaimable/1024/1024) space_reclaimable
5 FROM v$recovery_file_dest;
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE
--------------------------------------------- ----------- ---------- -----------------
C:\oraclexe\app\oracle\ fast_recovery_area 10240 100 0
SQL>
Using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters we can define the FRA location and size. To set the flash recovery area to 50 GB, enter the following commands...
