Flash Recovery Area

Flash recovery area or Fast recovery area is a space designed by Oracle for keeping backup files. It is a centralized location where RMAN writes backup file (backup sets) to. Here is what you will see in the FRA:

1. A directory containing backup sets
2. A directory containing controlfiles
3. A directory containing archivelog files

To check the size of your recovery area, issue this command:

select name, space_limit, space_used from v$recovery_file_dest

SPACE_USED/1024/1024/1024 SPACE_LIMIT/1024/1024/1024
------------------------- --------------------------
0 3.8203125

or

select space_used/1024/1024/1024 from v$recovery_file_dest;


To check the usage of FRA, issue this command:

select * from v$flash_recovery_area_usage;

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
CONTROL FILE 0 0
0

REDO LOG 0 0
0

ARCHIVED LOG 0 0
0


FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
BACKUP PIECE 0 0
0

IMAGE COPY 0 0
0

FLASHBACK LOG 0 0
0


FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
FOREIGN ARCHIVED LOG 0 0
0



increasing size of FRA

alter system set db_recovery_file_dest_size=10G;

NOTE: before increasing your FRA, please verify your server has a space to accommodate the new 10G you want to create.

on Linux/Unix, issue this command:

df -h

SIZE of database
You may need to check the size of your database in order to make a report or for capacity planning. Here are some of the commands you can use.

Segments:
select sum(BYTES/1024/1024/1024) from dba_segments;


Datafile:
select sum(BYTES/1024/1024/1024) from dba_data_files;


Tablespace:
select sum(BYTES/1024/1024/1024) from dba_free_space where TABLESPACE_NAME='KUNLE';

or

select sum(BYTES/1024/1024/1024) from v$datafile where TABLESPACE_NAME='KUNLE';