oracle中asm磁盘不足,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.

表空间可以成功创建

同时可以通过oracleasm命令查看ASM可以访问的磁盘

$ /etc/init.d/oracleasm listdisks

ORAARCH0

ORAARCH1

ORAARCH2

ORAARCH3

ORADATA0

ORADATA1

ORADATA11

ORADATA12

ORADATA14

ORADATA2

ORADATA3

ORADATA4

ORADATA5

ORADATA6

ORADATA7

ORADATA8

ORADATA9