为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.

表空间可以成功创建