28 Ocak 2015 Çarşamba
ORA-15041: diskgroup "DG_NAME" space exhausted
In 11.1.0.7 database version;
When you want to add new datafile in ASM or resize the datafile which in ASM,you may hit this error that ORA-15041: diskgroup "DG_NAME" space exhausted.
If ASM diskgroup can't rebalance this issue is normal.You can check disk free space with query below:
select group_number,free_mb from v$asm_disk order by 1;
An ideal disk group rebalance and each of the asm disks contains same free_mb.If it isn't same you hit a bug:)
Problem:
--------------
ORA-15041: diskgroup "DG_NAME" space exhausted
I hit an error diskgroup "DG_NAME" space exhausted.But I have free space on this diskgroup.
This is 11.1.0.7 bug
Solution(Workaround):
-----------------------------
alter system set "_asm_imbalance_tolerance"=0;
alter diskgroup <DG_NAME> rebalance power 5;
FREE_MB in Same Size Disks Differ Even After Successful Rebalance (Doc ID 813013.1)
Kaydol:
Kayıtlar (Atom)