step by step for droping diskgroup within ASM
sqlplus / as sysasm
set line 400
SELECT NAME, GROUP_NUMBER, TOTAL_MB, FREE_MB, USABLE_FILE_MB, STATE FROM v$asm_diskgroup;
SQL> !srvctl status diskgroup -diskgroup DATA
SQL> !srvctl status diskgroup -diskgroup DATA_GRUP
SQL> !srvctl stop diskgroup -diskgroup DATA -f
SQL> alter diskgroup DATA MOUNT;
SQL> DROP DISKGROUP DATA INCLUDING CONTENTS;
SQL> SELECT NAME, GROUP_NUMBER, TOTAL_MB, FREE_MB, USABLE_FILE_MB, STATE FROM v$asm_diskgroup;
SQL> !crsctl status resource -t
Droping diskgroup within ASM
[oracle@ol7-121-server1 sf_scripts_agap]$ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.2.0 Production on Sat Sep 23 10:23:03 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
SQL> set line 400
SQL> SELECT NAME, GROUP_NUMBER, TOTAL_MB, FREE_MB, USABLE_FILE_MB, STATE FROM v$asm_diskgroup;
NAME GROUP_NUMBER TOTAL_MB FREE_MB USABLE_FILE_MB STATE
------------------------------ ------------ ---------- ---------- -------------- -----------
DATA 1 9207 4504 4504 MOUNTED
DATA_GRUP 2 12285 7094 7094 MOUNTED
SQL> !srvctl status diskgroup -diskgroup DATA
Disk Group DATA is running on ol7-121-server1
SQL> !srvctl status diskgroup -diskgroup DATA_GRUP
Disk Group DATA_GRUP is running on ol7-121-server1
SQL> alter diskgroup DATA dismount;
alter diskgroup DATA dismount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "DATA" precludes its dismount
SQL> !srvctl stop diskgroup -diskgroup DATA
PRCR-1065 : Failed to stop resource ora.DATA.dg
CRS-5017: The resource action "ora.DATA.dg stop" encountered the following error:
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "DATA" precludes its dismount
. For details refer to "(:CLSN00108:)" in "/u01/app/oracle/diag/crs/ol7-121-server1/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2675: Stop of 'ora.DATA.dg' on 'ol7-121-server1' failed
SQL> !srvctl stop diskgroup -diskgroup DATA -f
SQL> !srvctl status diskgroup -diskgroup DATA_GRUP
Disk Group DATA_GRUP is running on ol7-121-server1
SQL> DROP DISKGROUP DATA INCLUDING CONTENTS;
DROP DISKGROUP DATA INCLUDING CONTENTS
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "DATA" does not exist or is not mounted
SQL> alter diskgroup DATA MOUNT;
Diskgroup altered.
SQL> DROP DISKGROUP DATA INCLUDING CONTENTS;
Diskgroup dropped.
SQL> SELECT NAME, GROUP_NUMBER, TOTAL_MB, FREE_MB, USABLE_FILE_MB, STATE FROM v$asm_diskgroup;
NAME GROUP_NUMBER TOTAL_MB FREE_MB USABLE_FILE_MB STATE
------------------------------ ------------ ---------- ---------- -------------- -----------
DATA_GRUP 2 12285 7094 7094 MOUNTED
SQL> !crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA_GRUP.dg
ONLINE ONLINE ol7-121-server1 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE ol7-121-server1 STABLE
ora.asm
ONLINE ONLINE ol7-121-server1 Started,STABLE
ora.ons
OFFLINE OFFLINE ol7-121-server1 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.agap.db
1 ONLINE ONLINE ol7-121-server1 Open,STABLE
ora.cssd
1 ONLINE ONLINE ol7-121-server1 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE ol7-121-server1 STABLE
--------------------------------------------------------------------------------
SQL>
for Oracle Database Administrators
