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

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/223555/viewspace-682813/