ORA-15032 Problem while dropping disks from disk group in (HPUX 11.31 ASM 11gR2 standalone db)

ORA-15032 Problem while dropping disks from disk group in ASM.

PROBLEM:

SQL> ALTER DISKGROUP DATA DROP DISK DATA_0003;

 

Diskgroup altered.

 

SQL>

SQL>

SQL>

SQL> SELECT name, header_status, path FROM V$ASM_DISK

2  ;

 

NAME                           HEADER_STATU PATH

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

FORMER       /dev/rdisk/disk14

DATA_0001                      MEMBER       /dev/rdisk/disk15

DATA_0002                      MEMBER       /dev/rdisk/disk16

DATA_0003                      MEMBER       /dev/rdisk/disk17

DATA_0004                      MEMBER       /dev/rdisk/disk38

DATA_0005                      MEMBER       /dev/rdisk/disk39

DATA_0006                      MEMBER       /dev/rdisk/disk40

DATA_0007                      MEMBER       /dev/rdisk/disk41

DATA_0008                      MEMBER       /dev/rdisk/disk42

DATA_0009                      MEMBER       /dev/rdisk/disk43

DATA_0010                      MEMBER       /dev/rdisk/disk44

DATA_0011                      MEMBER       /dev/rdisk/disk45

DATA_0012                      MEMBER       /dev/rdisk/disk46

DATA_0013                      MEMBER       /dev/rdisk/disk47

 

14 rows selected.

 

SQL> SELECT name, type, total_mb, free_mb, required_mirror_free_mb, usable_file_mb FROM V$ASM_DISKGROUP;

 

NAME                           TYPE     TOTAL_MB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB

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

DATA                           EXTERN    5888000    5748724                       0        5748724

 

SQL>

SQL>

SQL> ALTER DISKGROUP DATA rebalance wait;

ALTER DISKGROUP DATA rebalance wait

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15001: diskgroup "DATA" does not exist or is not mounted

 

 

SQL> ALTER DISKGROUP DATA rebalance;

ALTER DISKGROUP DATA rebalance

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15001: diskgroup "DATA" does not exist or is not mounted

 

SQL>

 

 

CAUSE :



To be honest I cannot find the real cause, only the side effect. I tried running asmca, if it caused this, but cannnot reproduce the case. All I know is I had rebooted the OS, and then login to asmcmd, made some alterations, run asmca, and after a while I got this error.

trlogdb01:/dev/rdisk#ll

total 0

crw-r-----   1 bin        sys         13 0x00000a Oct 13 16:48 disk14

crw-r-----   1 bin        sys         13 0x00000b Oct 13 16:53 disk15

crw-r-----   1 bin        sys         13 0x00000c Oct 13 16:53 disk16

crw-r-----   1 bin        sys         13 0x00000d Oct 13 16:53 disk17

crw-r-----   1 bin        sys         13 0x000000 May 13 12:44 disk3

crw-r-----   1 bin        sys         13 0x00000f Oct 13 16:56 disk38

crw-r-----   1 bin        sys         13 0x000010 Oct 13 16:56 disk39

crw-r-----   1 bin        sys         13 0x000006 May 13 12:44 disk3_p1

crw-r-----   1 bin        sys         13 0x000007 May 13 12:44 disk3_p2

crw-r-----   1 bin        sys         13 0x000008 May 13 12:44 disk3_p3

crw-r-----   1 bin        sys         13 0x000001 May 13 12:44 disk4

crw-r-----   1 bin        sys         13 0x000011 Oct 13 16:56 disk40

crw-r-----   1 bin        sys         13 0x000012 Oct 13 16:56 disk41

crw-r-----   1 bin        sys         13 0x000013 Oct 13 16:53 disk42

crw-r-----   1 bin        sys         13 0x000014 Oct 13 16:53 disk43

crw-r-----   1 bin        sys         13 0x000015 Oct 13 16:53 disk44

crw-r-----   1 bin        sys         13 0x000016 Oct 13 16:53 disk45

crw-r-----   1 bin        sys         13 0x000017 Oct 13 16:53 disk46

crw-r-----   1 bin        sys         13 0x000018 Oct 13 16:56 disk47

crw-r-----   1 bin        sys         13 0x000002 May 13 12:44 disk5

crw-r-----   1 bin        sys         13 0x000003 May 13 12:44 disk5_p1

crw-r-----   1 bin        sys         13 0x000004 May 13 12:44 disk5_p2

crw-r-----   1 bin        sys         13 0x000005 May 13 12:44 disk5_p3

 

 

SOLUTION:

trlogdb01:/dev/rdisk#chown oracle:dba disk14 disk15 disk16 disk17

…

trlogdb01:/dev/rdisk#ll

total 0

crw-r-----   1 oracle     dba         13 0x00000a Oct 13 16:48 disk14

crw-r-----   1 oracle     dba         13 0x00000b Oct 13 16:53 disk15

crw-r-----   1 oracle     dba         13 0x00000c Oct 13 16:53 disk16

crw-r-----   1 oracle     dba         13 0x00000d Oct 13 16:53 disk17

crw-r-----   1 bin        sys         13 0x000000 May 13 12:44 disk3

crw-r-----   1 oracle     dba         13 0x00000f Oct 13 16:56 disk38

crw-r-----   1 oracle     dba         13 0x000010 Oct 13 16:56 disk39

crw-r-----   1 bin        sys         13 0x000006 May 13 12:44 disk3_p1

crw-r-----   1 bin        sys         13 0x000007 May 13 12:44 disk3_p2

crw-r-----   1 bin        sys         13 0x000008 May 13 12:44 disk3_p3

crw-r-----   1 bin        sys         13 0x000001 May 13 12:44 disk4

crw-r-----   1 oracle     dba         13 0x000011 Oct 13 16:56 disk40

crw-r-----   1 oracle     dba         13 0x000012 Oct 13 16:56 disk41

crw-r-----   1 oracle     dba         13 0x000013 Oct 13 16:53 disk42

crw-r-----   1 oracle     dba         13 0x000014 Oct 13 16:53 disk43

crw-r-----   1 oracle     dba         13 0x000015 Oct 13 16:53 disk44

crw-r-----   1 oracle     dba         13 0x000016 Oct 13 16:53 disk45

crw-r-----   1 oracle     dba         13 0x000017 Oct 13 16:53 disk46

crw-r-----   1 oracle     dba         13 0x000018 Oct 13 16:56 disk47

crw-r-----   1 bin        sys         13 0x000002 May 13 12:44 disk5

crw-r-----   1 bin        sys         13 0x000003 May 13 12:44 disk5_p1

crw-r-----   1 bin        sys         13 0x000004 May 13 12:44 disk5_p2

crw-r-----   1 bin        sys         13 0x000005 May 13 12:44 disk5_p3