drop diskgroup ORA-15039 ORA-15027

最新推荐文章于 2022-10-02 12:03:57 发布

EVISWANG

最新推荐文章于 2022-10-02 12:03:57 发布

阅读量734

点赞数

分类专栏： oracle 文章标签： drop diskgroup ORA-15039 ORA-15027

本文链接：https://blog.csdn.net/EVISWANG/article/details/85072197

版权

oracle 专栏收录该内容

11 篇文章 1 订阅

订阅专栏

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>