在尝试使用SQL命令drop diskgroup DG1时遇到ORA-15001错误。问题源于diskgroup未被正确挂载。通过查询v$asm_diskgroup，发现DG1处于DISMOUNTED状态。为解决此问题，清空了与DG1相关的磁盘sdc1、sdd1、sde1和sdf1，并用/dev/zero填充。执行后，v$asm_diskgroup中未找到相关条目，表明问题已解决，可以重新创建Diskgroup。
SQL> alter diskgroup dg1 mount;
alter diskgroup DG1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15130: diskgroup "DG1" is being dismounted
ORA-15066: offlining disk "" may result in a data loss
SQL> select name,state from v$asm_diskgroup
NAME STATE
----- ----------------------------------------------------
DG1 DISMOUNTED
RECOVERYDEST DISMOUNTED
SQL> drop diskgroup dg1;
drop diskgroup dg1
*
ERROR at l
最低0.47元/天 解锁文章
扫一扫
819
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
