ITPub博客

首页 > 数据库 > Oracle > ASM磁盘组空间不足

ASM磁盘组空间不足

原创 Oracle 作者:myownstars 时间:2012-02-02 17:20:10 0 删除 编辑

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

将其中一个添加至磁盘组DATAASM使用的是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


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

上一篇: 误删online redolog
下一篇: ora-12518错误小结
请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3095002