drop diskgroup ORA-15039 ORA-15027

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

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

0 ·

CC 4.0 BY-SA版权

文章标签：

#drop diskgroup #ORA-15039 #ORA-15027

oracle 专栏收录该内容

11 篇文章

订阅专栏

本文详细记录了在Oracle数据库中遇到的ASM磁盘组DATAGRP1无法删除的问题及其解决过程。通过更改参数文件，重启实例并重新加载参数，最终成功删除了磁盘组，为数据库维护人员提供了宝贵的故障排除经验。

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

SQL>drop diskgroup DATAGRP1 including contents;

[DBT-30012] Dropping disk group DATAGRP1 failed.
ORA-15039: diskgroup not dropped
ORA-15027: active use of diskgroup "DATAGRP1" precludes its dismount

[grid@Trestoredb ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 18 17:00:39 2018

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show parameter pfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATAGRP1/ASM/ASMPARAMETERFILE
/registry.253.991764285
SQL> create pfile='/tmp/pfiasm.ora' from spfile;

File created.

SQL> shutdown immediate
ASM diskgroups volume disabled
ASM diskgroups dismounted
ASM instance shutdown
SQL>
SQL>
SQL>

SQL> startup pfile ='/tmp/pfiasm.ora';
ASM instance started

Total System Global Area 1140850688 bytes
Fixed Size 8629704 bytes
Variable Size 1107055160 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
SQL>

SQL> drop diskgroup datagrp1 including contents;

Diskgroup dropped.

SQL>