drop diskgroup报ora-15001

最新推荐文章于 2024-08-14 20:32:47 发布

原创最新推荐文章于 2024-08-14 20:32:47 发布 · 4k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #disk

Oracle 专栏收录该内容

4 篇文章

订阅专栏

在尝试使用SQL命令drop diskgroup DG1时遇到ORA-15001错误。问题源于diskgroup未被正确挂载。通过查询v$asm_diskgroup，发现DG1处于DISMOUNTED状态。为解决此问题，清空了与DG1相关的磁盘sdc1、sdd1、sde1和sdf1，并用/dev/zero填充。执行后，v$asm_diskgroup中未找到相关条目，表明问题已解决，可以重新创建Diskgroup。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "DG1" does not exist or is not mounted

尝试清空DG1用的sdc1、sdd1,RECOVERY用的sde1、sdf1,确认这两个DG已经不需要使用

[root@Oracle ~]#dd if=/dev/zero of=/dev/sdc1 bs=1M count=10000

[root@Oracle ~]#dd if=/dev/zero of=/dev/sdd1 bs=1M count=10000

[root@Oracle ~]#dd if=/dev/zero of=/dev/sde1 bs=1M count=10000

[root@Oracle ~]#dd if=/dev/zero of=/dev/sdf1 bs=1M count=10000

SQL> select name,state from v$asm_diskgroup

no rows selected

至此就可以重新建立Diskgroup了