ORA-15039: diskgroup not droppedORA-15001: diskgroup “DATA” does not exist or is not mounted

Cause:

I try to drop an asm diskgroup which is not properly created but i get the error that diskgroup is not mounted

SQL> drop diskgroup DATA;
drop diskgroup DATA
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "DATA" does not exist or is not mounted

Error code:

[oracle@exdbadm02 ~]$ oerr ora 15039 && oerr ora 15001
15039, 00000, "diskgroup not dropped"
// *Cause:  An attempt to drop a diskgroup failed.
// *Action: See the associated messages for details about why the drop
//          was not successful.
//
15001, 00000, "diskgroup \"%s\" does not exist or is not mounted"
// *Cause:  An operation failed because the diskgroup specified does not
//          exist or is not mounted by the current ASM instance.
// *Action: Verify that the diskgroup name used is valid, that the
//          diskgroup exists, and that the diskgroup is mounted by
//          the current ASM instance.
//

When i checked the logfile,i can see couple of errors because the physical disks are removed from the storage tier

ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
ERROR: alter diskgroup DATA MOUNT /* ASMCA */
Sat Feb 06 16:58:19 2021
NOTE: No asm libraries found in the system
ASM Health Checker found 1 new failures
Sat Feb 06 16:59:11 2021
SQL> drop diskgroup DATA
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "DATA" does not exist or is not mounted

Workaround:

If graceful drop doesnot work ,then we can forcefully drop the diskgroup with contents option

SQL>  drop diskgroup DATA force including contents;

Diskgroup dropped.

Oracle forcefully erase the diskgroup header and metadata of the diskgroups

NOTE: Assigning number (2,9) to disk (o/192.168.56.33/DATA_CD_cell19_stocell)
NOTE: Assigning number (2,8) to disk (o/192.168.56.33/DATA_CD_cell09_stocell)
NOTE: erasing header on grp 2 disk DATA_CD_CELL09_STOCELL
NOTE: erasing header on grp 2 disk DATA_CD_CELL19_STOCELL
NOTE: Disk DATA_CD_CELL09_STOCELL in mode 0x19 marked for de-assignment
NOTE: Disk DATA_CD_CELL19_STOCELL in mode 0x19 marked for de-assignment
SUCCESS: diskgroup DATA was force dropped
SUCCESS:  drop diskgroup DATA force including contents

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s