ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-15071: ASM disk "VOL_DATA2" is already being dropped

ORA-15071: ASM disk "VOL_DATA2" is already being dropped

原创 Linux操作系统 作者:zzhen163 时间:2010-12-29 16:10:17 0 删除 编辑
SQL> alter diskgroup PQAWEB_DATA1 drop disk 'VOL_DATA1' FORCE ;
alter diskgroup PQAWEB_DATA1 drop disk 'VOL_DATA1' FORCE
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15071: ASM disk "VOL_DATA1" is already being dropped


SQL> alter diskgroup PQAWEB_DATA1 drop disk 'VOL_DATA2'FORCE ;
alter diskgroup PQAWEB_DATA1 drop disk 'VOL_DATA2'FORCE
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15071: ASM disk "VOL_DATA2" is already being dropped

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,MODE_STATUS,TOTAL_MB,FREE_MB,NAME,LABEL from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_S MODE_ST   TOTAL_MB    FREE_MB NAME                           LABEL
------------ ----------- ------- ------- ---------- ---------- ------------------------------ -------------------------------
           0           6 CLOSED  ONLINE         431          0                                V_DATA1
           0           7 CLOSED  ONLINE        1520          0                                V_DATA2
           2           2 MISSING OFFLINE          0          0 VOL_DATA1
           2           3 MISSING OFFLINE          0          0 VOL_DATA2
           1           2 CACHED  ONLINE          87         54 FDATA1                         FDATA1
           1           3 CACHED  ONLINE        1863       1347 FDATA2                         FDATA2
           2           0 CACHED  ONLINE        1951        105 VOL1                           VOL1
           2           1 CACHED  ONLINE        1951        105 VOL2                           VOL2
           1           0 CACHED  ONLINE        1951       1330 VOL3                           VOL3
           1           1 CACHED  ONLINE        1951       1322 VOL4                           VOL4

10 rows selected.

SQL> alter diskgroup PQAWEB_DATA1 rebalance power 11;

Diskgroup altered.

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,MODE_STATUS,TOTAL_MB,FREE_MB,NAME,LABEL from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_S MODE_ST   TOTAL_MB    FREE_MB NAME                           LABEL
------------ ----------- ------- ------- ---------- ---------- ------------------------------ -------------------------------
           0           6 CLOSED  ONLINE         431          0                                V_DATA1
           0           7 CLOSED  ONLINE        1520          0                                V_DATA2
           1           2 CACHED  ONLINE          87         54 FDATA1                         FDATA1
           1           3 CACHED  ONLINE        1863       1347 FDATA2                         FDATA2
           2           0 CACHED  ONLINE        1951        105 VOL1                           VOL1
           2           1 CACHED  ONLINE        1951        105 VOL2                           VOL2
           1           0 CACHED  ONLINE        1951       1330 VOL3                           VOL3
           1           1 CACHED  ONLINE        1951       1322 VOL4                           VOL4

8 rows selected.

SQL> 

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

请登录后发表评论 登录
全部评论

注册时间:2008-09-27

  • 博文量
    35
  • 访问量
    64093