I am using Oracle 10.2.0.4 RAC(2 node) database on Linux.
Please find the details of space used in ASM
ASMCMD> lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N N 512 4096 1048576 153597 73296 0 73296 0 DG_ARCH/
MOUNTED EXTERN N N 512 4096 1048576 10239 9871 0 9871 0 DG_CONFIG1/
MOUNTED EXTERN N N 512 4096 1048576 10239 9742 0 9742 0 DG_CONFIG2/
MOUNTED EXTERN N N 512 4096 1048576 10239 9484 0 9484 0 DG_CONFIG3/
MOUNTED EXTERN N N 512 4096 1048576 81925 3271 0 3271 0 DG_DATA/
MOUNTED EXTERN N N 512 4096 1048576 51199 17417 0 17417 0 DG_TEMP/
DG_ARCH is the db_recovery_file_dest
I have around 200 archived log files in the flash recovery area and lo_archive_dest1 is set to +DG_ARCH.
The information from v$flash_recovery_area_usage and v$recovery_file_dest are follows
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 0 0 0
BACKUPPIECE .01 0 2
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL> SQL> SELECT * FROM V$RECOVERY_FILE_DEST;
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
---------- ----------- ---------- ----------------- ---------------
DG_ARCH 1.1863E11 16777216 0 2
From RMAN I tried
rman>crosscheck archivelog all;
rman>delete expired archivelog all;
But they didn't help, still information shown in v$recovery_file_dest is incorrect.