ORA-15074: diskgroup requires rebalance completion

Sometimes when you add or remove disks in ASM diskgroup without rebalancing, you can stumbled upon this error.

SQL> alter diskgroup SOMEGROUP add failgroup FG1 disk 'ORCL:DISK10[0-9]','ORCL:DISK11[0-9]','ORCL:DISK12[0-2]' rebalance power 10;
alter diskgroup SOMEGROUP add failgroup FG1 disk 'ORCL:DISK10[0-9]','ORCL:DISK11[0-9]','ORCL:DISK12[0-2]' rebalance power 10
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15074: diskgroup SOMEGROUP requires rebalance completion

It could mean that you’ve stumbled upon overfill counter for partner disks. In general maximum disk partners should be 8. And only one solution for this. You should done successful rebalancing for diskgroup.

SQL> select  disk,count(NUMBER_KFDPARTNER), count(ACTIVE_KFDPARTNER) from x$kfdpartner where grp=1 group by disk;

      DISK COUNT(NUMBER_KFDPARTNER) COUNT(ACTIVE_KFDPARTNER)
---------- ------------------------ ------------------------
	 1			  9			   9
	 2			  9			   9
	 3			  9			   9
	 4			  9			   9
	 5			 10			  10
	 6			 10			  10
	 7			  9			   9
	 8			 10			  10
	 9			  9			   9
	10			 10			  10
	11			  9			   9

      DISK COUNT(NUMBER_KFDPARTNER) COUNT(ACTIVE_KFDPARTNER)
---------- ------------------------ ------------------------
	12			 11			  11
	13			  8			   8
	14			 10			  10
	15			  9			   9
	16			 12			  12
	17			 10			  10
	18			  9			   9
	19			  9			   9
	20			 11			  11
	21			  9			   9
	22			 10			  10

      DISK COUNT(NUMBER_KFDPARTNER) COUNT(ACTIVE_KFDPARTNER)
---------- ------------------------ ------------------------
	23			 13			  13
	24			  8			   8
	25			 14			  14
	26			 12			  12
	27			  9			   9
	28			 12			  12
	29			 11			  11
	30			  9			   9
	31			 10			  10
	32			 10			  10
	33			  9			   9

      DISK COUNT(NUMBER_KFDPARTNER) COUNT(ACTIVE_KFDPARTNER)
---------- ------------------------ ------------------------
	34			  9			   9
	35			  9			   9
	36			  9			   9
	37			  9			   9
	38			  9			   9
	39			  9			   9
	40			  8			   8
	41			  9			   9
	42			  9			   9
	43			  8			   8
	44			 10			  10

      DISK COUNT(NUMBER_KFDPARTNER) COUNT(ACTIVE_KFDPARTNER)
---------- ------------------------ ------------------------
	45			 11			  11
	46			 11			  11
Advertisements

4 thoughts on “ORA-15074: diskgroup requires rebalance completion

    1. mczimm Post author

      Igor, in general you need just run rebalancing diskgroup (alter diskgroup DG rebalance power 10). The main task of rebalancing is be sure that all data are available and mirrored, also take care about meta information in library, which you can see through X$ views, and meta information in header of disks.

      Off course if diskgroup has not typical state you can see random artifacts. For this rarely cases you can make demo stand and do some experiments and even can contact MOS.

      Reply
  1. Pingback: Reasoning about ASM PST | Yet Another Oracle Blog

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