Tuesday, April 15, 2014

Increase the Size of flash recovery area

Flash Recovery Area feature lets you set up a location on disk where the database can create and manage a variety of backup and recovery files on your behalf.
Basically this is the setting of RMAN.
Files that could be found in the FRA include:
  •     RMAN backups
  •     control file
  •     logs
    • online redo log copies
    • archived redo logs
    •  flashback logs
     
Check the size:
select name,
floor(space_limit/1024/1024) "Size_MB",
ceil(space_used/1024/1024) "Used_MB"
from v$recovery_file_dest
order by name
/


Memory Usage of FRA:
Query the V$FLASH_RECOVERY_AREA_USAGE view to find out the percentage of the total disk quota used by different types of files, and how much space for each type of file can be reclaimed by deleting files that are obsolete, redundant, or already backed up to tape.
SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;


To change the size of the recovery area is given command.
ALTER SYSTEM SET db_recovery_file_dest_size=2G SCOPE=BOTH ;


More about FRA  http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup005.htm

No comments:

Post a Comment

web stats