ASM drop diskgroup ORA-15032: not all alterations performed

 

Hi all we recently wants to perform ASM LUN migration activity we face some error,  Although this error not related the ASM LUN migration.  When we try to delete asm diskgroup name is NEWBACKUP using asmca we got error as well is in command prompt. Earlier in another scenario we deleted the same but do not encountered any issue. After troubleshooting  we dismount the disk group from another instance and deleted the same. 

Error:

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15250: insufficient diskgroup space for rebalance completion

ORA-15039: diskgroup not dropped

ORA-15073: diskgroup BACKUPNEW is mounted by another ASM instance

Dropping disks from disk group BACKUPNEW failed with the following message:

ORA-15032: not all alterations performed

ORA-15250: insufficient diskgroup space for rebalance completion

• Query to check diskgroup status 

SQL> set lines 999;

SQL> col diskgroup for a10

col diskname for a12

col path for a30

select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;SQL> SQL> SQL>

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

BACKUPNEW  BACKUPNEW_00      12284         96      12188 /dev/oracleasm/disks/BACKUPNEW MEMBER

           00

BACKUP     BACKUP_0000       12284         96      12188 /dev/oracleasm/disks/BACKUP    MEMBER

CRSNEW     CRSNEW_0000       12284         96      12188 /dev/oracleasm/disks/CRSNEW    MEMBER

CRS        CRS_0000          12284       4472       7812 /dev/oracleasm/disks/CRS       MEMBER

DATANEW    DATANEW_0000      20473         96      20377 /dev/oracleasm/disks/DATANEW   MEMBER

DATA       DATA_0000         20473       2281      18192 /dev/oracleasm/disks/DATA      MEMBER

FRANEW     FRANEW_0000       20473         96      20377 /dev/oracleasm/disks/FRANEW    MEMBER

FRA        FRA_0000          20473        580      19893 /dev/oracleasm/disks/FRA       MEMBER

8 rows selected.

• Login grid user and execute command using sysasm

SQL> alter diskgroup BACKUPNEW drop disk BACKUPNEW_0000;

alter diskgroup BACKUPNEW drop disk BACKUPNEW_0000

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15250: insufficient diskgroup space for rebalance completion

SQL> drop diskgroup BACKUPNEW;

drop diskgroup BACKUPNEW

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-15073: diskgroup BACKUPNEW is mounted by another ASM instance

• Login using grid user to remote node and dismount particular diskgroup 

SQL> exit

Disconnected

[grid@srv1 ~]$ . oraenv

ORACLE_SID = [+ASM2] ? +ASM1

The Oracle base remains unchanged with value /u01/app/grid

[grid@srv1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Wed Mar 31 16:07:08 2021

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 Real Application Clusters and Automatic Storage Management options

SQL> set lines 200

SQL> select  name, compatibility, database_compatibility from v$asm_diskgroup;

NAME                           COMPATIBILITY                                                DATABASE_COMPATIBILITY

------------------------------ ------------------------------------------------------------ ------------------------------------------------------------

BACKUP                         12.1.0.0.0                                                   10.1.0.0.0

DATANEW                        12.1.0.0.0                                                   10.1.0.0.0

FRANEW                         12.1.0.0.0                                                   10.1.0.0.0

FRA                            12.1.0.0.0                                                   10.1.0.0.0

CRSNEW                         12.1.0.0.0                                                   10.1.0.0.0

DATA                           12.1.0.0.0                                                   10.1.0.0.0

BACKUPNEW                      12.1.0.0.0                                                   10.1.0.0.0

CRS                            12.1.0.0.0                                                   10.1.0.0.0

8 rows selected.

SQL> alter diskgroup BACKUPNEW dismount;

Diskgroup altered.

• Login grid user to Local node and drop particular diskgroup

 

SQL> drop diskgroup BACKUPNEW including contents;

Diskgroup dropped.

SQL> select path from v$asm_disk;

PATH

------------------------------

/dev/oracleasm/disks/CRSNEW

/dev/oracleasm/disks/DATANEW

/dev/oracleasm/disks/BACKUPNEW

/dev/oracleasm/disks/FRANEW

/dev/oracleasm/disks/FRA

/dev/oracleasm/disks/DATA

/dev/oracleasm/disks/CRS

/dev/oracleasm/disks/BACKUP

8 rows selected.

SQL> set pages 40000 lines 120

col PATH for a30

select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK;SQL> SQL>

DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    PATH

----------- ------- ------------ ------- -------- ------------------------------

          0 CLOSED  FORMER       ONLINE  NORMAL   /dev/oracleasm/disks/CRSNEW

          1 CLOSED  FORMER       ONLINE  NORMAL   /dev/oracleasm/disks/DATANEW

          2 CLOSED  FORMER       ONLINE  NORMAL   /dev/oracleasm/disks/BACKUPNEW

          3 CLOSED  FORMER       ONLINE  NORMAL   /dev/oracleasm/disks/FRANEW

          0 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/FRA

          0 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/DATA

          0 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRS

          0 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/BACKUP

8 rows selected.