ASM rebalance question

From: Mayen Shah <mshah_at_travelclick.com>
Date: Fri, 15 Mar 2013 17:20:32 +0000
Message-ID: <4AF37DF85FABC641A090D23044A9C9B46B8BE209_at_EXMBWLM01.TRAVELCLICK.NET>

Environment : Oracle 11.2.0.2 on exadata Linux 2.6 We had one storage cell go south. Oracle took almost 24 hours to replace bad parts. Meanwhile disk_repair_time exceeded, disks were dropped and rebalance started. The rebalance is still going on and estimated time to completion is 20 hours.

Meanwhile the storage cell was repaired and disks are back, but the disks cannot be added to diskgroup until rebalance is completed. I know once disks are added back it will trigger another rebalance with will run for lot longer. Increasing rebalance power has performance impact on the database.

We stopped the rebalance by changing the power to 0 and tried to add disk but resulted in ORA-15074.

alter diskgroup DATA_DG01 add disk

'............',  '..........',
'..............', '...........',
'............'  REBALANCE POWER 4;

*
ERROR at line 1:
ORA-15032: not all alterations performed ORA-15074: diskgroup DATA_DG01 requires rebalance completion

My question: Is there any way to terminate the rebalance and add disks to the diskgroup?

Thank you in advance.

• Mayen

TravelClick Privacy Policy

This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of TravelClick. Before opening any attachments, please check them for viruses and defects.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 15 2013 - 18:20:32 CET