【ASM學習】手工刪除ASM磁碟組時提示錯誤ORA-15039

SQL> drop diskgroup sysdata;
drop diskgroup sysdata
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "SYSDATA" does not exist or is not mounted

SQL> drop diskgroup flaskback;
drop diskgroup flaskback
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "FLASKBACK" does not exist or is not mounted
--檢視狀態顯示為DISMOUNTED
SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
SYSDATA                        DISMOUNTED
FLASKBACK                   DISMOUNTED
---mount磁碟組的狀態
SQL> alter diskgroup flaskback mount;
Diskgroup altered.
---再次刪除依然提示錯誤 含有檔案。
SQL> drop diskgroup flaskback;
drop diskgroup flaskback
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15053: diskgroup "FLASKBACK" contains existing files
---只要使用含有including contents子句刪除就可以了
SQL> drop diskgroup flaskback including contents;
Diskgroup dropped.
---system 磁碟組也一樣。。
SQL> drop diskgroup sysdata including contents;
drop diskgroup sysdata including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "SYSDATA" does not exist or is not mounted
SQL> alter diskgroup sysdata mount;
Diskgroup altered.
SQL> drop diskgroup sysdata including contents;
Diskgroup dropped.