ASM空间虚假耗尽

sys@DLSP>alter 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

 

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?returnToSrId=&_afrLoop=753804223145954&srnum=&type=DOCUMENT&id=460155.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=11997r76ax_49

MOS上的文章

还没来得及看，有时间再研究

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22034023/viewspace-764557/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22034023/viewspace-764557/