ASM磁碟組空間不足

為RAC新建一個表空間，報告磁碟組沒有空間了，檢視v$asm_diskgroup發現DATA只有2M的可用空間，透過ASMCMD進入發現DATA資料夾下沒有可移除的檔案；

在確定為系統新增空間之前，先檢查v$asm_disk確認是否還有尚未使用的disk；

果然找到了幾個顯示group 0的，

SQL> select GROUP_NUMBER,DISK_NUMBER,NAME,PATH, state,mode_status,FAILGROUP,redundancy from v$asm_disk;

GROUP_NUMBER DISK_NUMBER NAME                           PATH                                               STATE    MODE_ST FAILGROUP                      REDUNDA

------------ ----------- ------------------------------ -------------------------------------------------- -------- ------- ------------------------------ -------

           0           0                                /dev/oracleasm/disks/ORADATA14                     NORMAL   ONLINE                                 UNKNOWN

           0           1                                /dev/oracleasm/disks/ORADATA12                     NORMAL   ONLINE                                 UNKNOWN

           0           2                                /dev/oracleasm/disks/ORADATA11                     NORMAL   ONLINE                                 UNKNOWN

           2           9 DATA_0009                      /dev/oracleasm/disks/ORADATA9                      NORMAL   ONLINE  DATA_0009                      UNKNOWN

           2           8 DATA_0008                      /dev/oracleasm/disks/ORADATA8                      NORMAL   ONLINE  DATA_0008                      UNKNOWN

           2           6 DATA_0006                      /dev/oracleasm/disks/ORADATA6                      NORMAL   ONLINE  DATA_0006                      UNKNOWN

           2           7 DATA_0007                      /dev/oracleasm/disks/ORADATA7                      NORMAL   ONLINE  DATA_0007                      UNKNOWN

           2           5 DATA_0005                      /dev/oracleasm/disks/ORADATA5                      NORMAL   ONLINE  DATA_0005                      UNKNOWN

           1           3 ARCH_0003                      /dev/oracleasm/disks/ORAARCH3                      NORMAL   ONLINE  ARCH_0003                      UNKNOWN

           1           2 ARCH_0002                      /dev/oracleasm/disks/ORAARCH2                      NORMAL   ONLINE  ARCH_0002                      UNKNOWN

           1           1 ARCH_0001                      /dev/oracleasm/disks/ORAARCH1                      NORMAL   ONLINE  ARCH_0001                      UNKNOWN

           1           0 ARCH_0000                      /dev/oracleasm/disks/ORAARCH0                      NORMAL   ONLINE  ARCH_0000                      UNKNOWN

           2           4 DATA_0004                      /dev/oracleasm/disks/ORADATA4                      NORMAL   ONLINE  DATA_0004                      UNKNOWN

           2           3 DATA_0003                      /dev/oracleasm/disks/ORADATA3                      NORMAL   ONLINE  DATA_0003                      UNKNOWN

           2           2 DATA_0002                      /dev/oracleasm/disks/ORADATA2                      NORMAL   ONLINE  DATA_0002                      UNKNOWN

           2           1 DATA_0001                      /dev/oracleasm/disks/ORADATA1                      NORMAL   ONLINE  DATA_0001                      UNKNOWN

           2           0 DATA_0000                      /dev/oracleasm/disks/ORADATA0                      NORMAL   ONLINE  DATA_0000                      UNKNOWN

將其中一個新增至磁碟組DATA，ASM使用的是spfile因此不用修改asm_disk引數

SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/ORADATA11' name DATA_0011;

Diskgroup altered.

表空間可以成功建立