Oracle Database Discussions

Hey, I am a bit confused about the calculation of the my FRA

I am using FRA in 10.2.0.4 on SLES9

The configured parameter for FRA size is set to 147GB even when the physical size is 138GB - I have to change this. I know.
But anyway - according to v$flash_recovery_area_usage the FRA is only 43 percent full - so at least 63 GB should be free.
But I only see 6 GB free space - how come ????
There are no additional files in the asm diskgroups when I do an 'ls' on the subfolders of '+FLASH'

Any ideas ?

db_recovery_file_dest string +FLASH
db_recovery_file_dest_size big integer 147000

ASMCMD> lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED NORMAL N N 512 4096 1048576 276680 174545 69170 52687 0 DATA/
MOUNTED NORMAL N N 512 4096 1048576 138340 6164 0 3082 0 FLASH/

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

CONTROLFILE .02 0 1
ONLINELOG 2.37 0 27
ARCHIVELOG .01 0 6
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 40.14 28.94 1269

+FLASH = 4x 72 GB - Normal redundancy

Edited by: Christian on 20.08.2010 10:19