ASM空間虛假耗盡

tablespace users add datafile '+DATA/dlsp/user93.dbf' size 20g;
alter tablespace users add datafile '+DATA/dlsp/user93.dbf' size 20g
*
ERROR at line 1:
ORA-01119: error in creating database file '+DATA/dlsp/user93.dbf'
ORA-17502: ksfdcre:4 Failed to create file +DATA/dlsp/user93.dbf
ORA-15041: diskgroup "DATA" space exhausted

 

select path,total_mb,free_mb from v$asm_disk_stat;

PATH                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
/dev/rhdisk15                      204800      11259
/dev/rhdisk16                      204800      11121
/dev/rhdisk17                      204800      11190
/dev/rhdisk18                      204800      11162
/dev/rhdisk19                      204800     100156
/dev/rhdisk20                      204800     100172
/dev/rhdisk21                      204800     100143
/dev/rhdisk22                      204800     100168
/dev/rhdisk23                      204800     100183
/dev/rhdisk24                      204800     100180
/dev/rhdisk25                      204800     100167
/dev/rhdisk26                      204800     100183
/dev/rhdisk27                      204800     100157
/dev/rhdisk28                      204800     100166
/dev/rhdisk29                      204800     100147

 

MOS上的文章

還沒來得及看，有時間再研究