When I check the ASM disk groups, I see that only ~112 G left out of 7 T in DATA but when I check from ASMCMD I see only 1.4 T used. Where has the difference gone and how can I reclaim it?
SQL> select GROUP_NUMBER,NAME,TOTAL_MB,FREE_MB,USABLE_FILE_MB from v$asm_diskgroup ;
GROUP_NUMBER NAME TOTAL_MB FREE_MB USABLE_FILE_MB
------------ ------------------------------ ---------- ---------- --------------
1 DATA 7372800 112504 -208258
2 RECO 9796800 5100308 1373542
3 REDO 763120 707204 108548
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED HIGH N 512 4096 4194304 7372800 112504 737280 -208258 0 Y DATA/
MOUNTED HIGH N 512 4096 4194304 9796800 5100308 979680 1373542 0 N RECO/
MOUNTED HIGH N 512 4096 4194304 763120 707204 381560 108548 0 N REDO/
ASMCMD> pwd
+
ASMCMD> ls
DATA/
RECO/
REDO/
ASMCMD> du DATA
Used_MB Mirror_used_MB
1395328 4185984
ASMCMD> cd DATA
ASMCMD> ls
BEANDEV/
BEANS/
BEANTSTL/
SLX81TST/
beanstore-c/
ASMCMD> du *
Used_MB Mirror_used_MB
1395328 4185984
ASMCMD>
ASMCMD> du BEANDEV/
Used_MB Mirror_used_MB
98324 294972
ASMCMD> du BEANS/
Used_MB Mirror_used_MB
513724 1541172
ASMCMD> du BEANTSTL/
Used_MB Mirror_used_MB
391540 1174620
ASMCMD> du SLX81TST/
dUsed_MB Mirror_used_MB
391468 1174404
ASMCMD> u beanstore-c/
Used_MB Mirror_used_MB
272 816