FRA in Single Instance

The FRA is essentially a disk location for the storage of files related to the recovery process.  These files in the FRA are managed by Oracle and RMAN automatically.  Files that could be found in the FRA include:

• RMAN backups
• Control files
• Online redo log copies
• Archived redo logs
• Flashback logs

Using an FRA to automate the management of backup-related files can greatly simplify the administration of the database by providing automatic space management for files related to backup and recovery.  Otherwise, the DBA has to manually manage the space.

Setting up FRA :-

Environment : Oracle 11gR2 on Windows 2008 Server

SQL> alter system set db_recovery_file_dest_size=10g scope=both;

System altered.

SQL> alter system set db_recovery_file_dest='K:\fast_recovery_area\IECHR';

System altered.

SQL> alter database open;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> archive log list;

Database log mode                  Archive Mode

Automatic archival                 Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence            9

Next log sequence to archive         13

Current log sequence                 13

•   Now go to K:\ drive and check how archives are generating in   FAST_RECOVERY_AREA location..

Monitoring FRA :-

SQL> select name,floor(space_limit/1024/1024) "Size MB", ceil(space_used/1024/1024) "Used MB" from v$recovery_file_dest order by name;

SQL> SELECT rau.file_type,rfd.space_used * rau.percent_space_used /      1024/1024 as USED_MB,rfd.space_reclaimable *                        rau.percent_space_reclaimable/1024/1024 as                          RECLAIMABLE_MB,rau.number_of_files as NUMBER_OF_FILES FROM          v$recovery_file_dest rfd,v$flash_recovery_area_usage rau;


>> To determine the disk quota and current disk usage in the flash  recovery area, query the view V$RECOVERY_FILE_DEST.

SQL> select * from v$flash_recovery_area_usage;

Happy Learning...