FRA – FLASH RECOVERY AREA

 FRA – Flash Recover area

•   Central location for backup data
• Logs
• Archive logs
• Backups
• Control file
• Location a
• ASM
• filesystem
• Allow RMAN Retention policies
• Parameters
• DB_RECOVERY_FILE_DEST
• DB_RECOVERY_DEST_SIZE

 How to .. 

--- check the flash_recovery_area parameters

SQL> show parameter DB_RECOVERY_FILE_DEST

NAME                                             TYPE               VALUE

------------------------------------         -----------         ------------------------------

db_recovery_file_dest                string              /u01/app/oracle/flash_recovery_area

db_recovery_file_dest_size       big integer     3852M

SQL>

col name form a30

col value form a30

select name, value from v$parameter where name like 'log_arc%' order by 1 asc

NAME                           VALUE

------------------------------ ------------------------------

log_archive_config

log_archive_dest

l...

log_archive_dest_31
..

log_archive_dest_state_1       enable
..

log_archive_dest_state_31      enable

..

log_archive_duplex_dest

log_archive_format             %t_%s_%r.dbf

log_archive_local_first        TRUE

log_archive_max_processes      4

log_archive_min_succeed_dest   1

log_archive_start              FALSE

log_archive_trace              0

71 rows selected.

SQL> set lines 200

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE                  PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

--------------------          ------------------                   -------------------------                          ---------------

CONTROL FILE                                    0                        0                                                 0

REDO LOG                                          0                        0                                                 0

ARCHIVED LOG                                   .65                     0                                                 1

BACKUP PIECE                                    0                        0                                                 0

IMAGE COPY                                      0                         0                                                 0

FLASHBACK LOG                                0                         0                                                 0

FOREIGN ARCHIVED LOG                    0                         0                                                 0

7 rows selected.

SQL> select * from v$recovery_file_dest

NAME                                          SPACE_LIMIT SPACE_USED  SPACE_RECLAIMABLE NUMBER_OF_FILES

--------------------------------           ---------- ----------------- ---------------

/u01/app/oracle/flash_recovery_area  4039114752            26259456                 0               1

--- Change the size of the flash recovery area to 5GB:

SQL> alter system set db_recovery_file_dest_size = 5G scope=both;