ASM disk rebalance ORA-15041

I wanted to free up some space from the existing ASM disks in a EXTERNAL DG. So added a new disk

SQL> ALTER DISKGROUP DG1 ADD DISK ‘/dev/rdsk/c2t20120002AC000212d27s6’
/
And set the rebalance power to maximum

SQL> ALTER DISKGROUP DG1 REBALANCE POWER 10
/

But in some time, I got an WARNING in alert+ASM.log

“WARNING: rebalance not completed for group 1/0x7d1cb755 (DG1)”

Section from of alert+ASM.log
=============================
Sun Dec 11 22:36:56 2010
NOTE: Assigning number (1,20) to disk (/dev/rdsk/c2t20120002AC000212d27s6)
NOTE: requesting all-instance membership refresh for group=1
NOTE: initializing header on grp 1 disk DG1_0020
NOTE: cache opening disk 20 of grp 1: DG1_0020 path:/dev/rdsk/c2t20120002AC000212d27s6
NOTE: requesting all-instance disk validation for group=1
Sun Dec 11 22:36:58 2010
NOTE: disk validation pending for group 1/0x7d1cb755 (DG1)
SUCCESS: validated disks for 1/0x7d1cb755 (DG1)
NOTE: initiating PST update: grp = 1
kfdp_update(): 19
Sun Dec 11 22:37:02 2010
kfdp_updateBg(): 19
NOTE: PST update grp = 1 completed successfully
NOTE: membership refresh pending for group 1/0x7d1cb755 (DG1)
kfdp_query(): 20
kfdp_queryBg(): 20
kfdp_query(): 21
kfdp_queryBg(): 21
SUCCESS: refreshed membership for 1/0x7d1cb755 (DG1)
SUCCESS: alter diskgroup DG1 add disk ‘/dev/rdsk/c2t20120002AC000212d27s6’
NOTE: starting rebalance of group 1/0x7d1cb755 (DG1) at power 10
Starting background process ARB0
Starting background process ARB1
Sun Dec 11 22:37:04 2010
ARB0 started with pid=16, OS id=7019
Starting background process ARB2
ARB1 started with pid=17, OS id=7021
Starting background process ARB3
……..
……..
ARB7 started with pid=23, OS id=7033
Starting background process ARB9
ARB8 started with pid=24, OS id=7035
NOTE: assigning ARB0 to group 1/0x7d1cb755 (DG1)
Sun Dec 11 22:37:05 2010
ARB9 started with pid=25, OS id=7037
NOTE: assigning ARB1 to group 1/0x7d1cb755 (DG1)
NOTE: assigning ARB2 to group 1/0x7d1cb755 (DG1)
NOTE: assigning ARB3 to group 1/0x7d1cb755 (DG1)
NOTE: assigning ARB4 to group 1/0x7d1cb755 (DG1)
NOTE: assigning ARB5 to group 1/0x7d1cb755 (DG1)
NOTE: assigning ARB6 to group 1/0x7d1cb755 (DG1)
NOTE: assigning ARB7 to group 1/0x7d1cb755 (DG1)
NOTE: assigning ARB8 to group 1/0x7d1cb755 (DG1)
NOTE: assigning ARB9 to group 1/0x7d1cb755 (DG1)
……..
……..
>>>>>>>>>
>>>>>>>>>WARNING: rebalance not completed for group 1/0x7d1cb755 (DG1)
>>>>>>>>>

So I checked the V$ASM_OPERATION view to see what is exactly happening.

SQL> SELECT GROUP_NUMBER, OPERATION , STATE, ERROR_CODE , POWER FROM V$ASM_OPERATION
/

GROUP_NUMBER OPERA STAT ERROR_CODE POWER
———— —– —- ——————————————– ———-
1 REBAL ERRS ORA-15041 10

It tried rebalancing, but failed with ORA-15041 (diskgroup space exhausted). It could not rebalance the disk, with available space. So added another disk

SQL> ALTER DISKGROUP DG1 ADD DISK ‘/dev/rdsk/c2t20120002AC000212d78s6′
/

and rebalance was successful this time.

SQL> SELECT GROUP_NUMBER, OPERATION , STATE, ERROR_CODE , POWER FROM V$ASM_OPERATION
/
no rows selected

SUCCESS: rebalance completed for group 1/0x7d1cb755 (DG1)
SUCCESS: refreshed membership for 1/0x7d1cb755 (DG1)

Once the rebalance was done, I removed second disk from the DG.

SQL> SELECT NAME FROM V$ASM_DISK WHERE PATH=’/dev/rdsk/c2t20120002AC000212d78s6’
/

NAME
——————————
DG1_0021

SQL> ALTER DISKGROUP DG1 DROP DISK DG1_0021
/

Advertisements
This entry was posted in Oracle Automatic Storage Management and tagged . Bookmark the permalink.

One Response to ASM disk rebalance ORA-15041

  1. Pingback: ASM Adding and Removing disk in single operation | Oracle-Hands-On

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s