Archive
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
Derya Oktay's Weblog 
Recent Comments