Re: ASM rebalance question
Date: Fri, 15 Mar 2013 13:16:18 -0500
Message-ID: <CAFU3ey7YWU0QZTx8VJ5UBEQpDL8dV+OmRsiRXB8CniES=L+AZw_at_mail.gmail.com>
I would not cancel the rebalance if it were my choice, especially so after what you've been through with the cell replacement. You'll end up spending more time on it than if you just let it finish and then add the disks back in. Remember, it has got to undo what it has done so far if you cancel it. Query v$asm_operation to get an idea of progress. If the time estimate is small, it is probably better to wait it out anyway.
My experience is that the estimates in v$asm_operation fluctuate and are a bit high, but I have only looked at them for single disk rebalance operations. You could always try increasing ASM_POWER_LIMIT to a higher value to see what effect it has on the time estimates and then make the call from there. Maybe it is worth taking the performance hit to power through this so you can then add the lost disks back. On the other hand, if the performance hit is too great, you can drop it back down to 4.
Andy
On Fri, Mar 15, 2013 at 12:20 PM, Mayen Shah <mshah_at_travelclick.com> wrote:
> 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
>
>
>
-- Andy Wattenhofer Manager, Database Administration University of Minnesota -- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 15 2013 - 19:16:18 CET