RE: ASM rebalance question

From: John Hallas <John.Hallas_at_morrisonsplc.co.uk>
Date: Tue, 19 Mar 2013 08:11:50 +0000
Message-ID: <EC65ECF8123FEE4D8FC5B212637C30400165FF228DEE_at_EXCH1.morrisonsplc.co.uk>

I would certainly try and increase the power level until it is noticeably hitting performance - you may well be able to get it up to 7 without any impact. Andy, interesting point about the undo being necessary if you cancel. I have never tested this but I thought that most of the changes would apply and it would only 'put back' block changes that were in flight as there is no requirement or necessity to move all blocks back to where they were originally.

There again logic tells me that if you add a disk to a diskgroup and rebalance at the same time then if you kill the command then the newe disk would not have any data in at the end of the activity.

John
www.jhdba.wordpress.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andy Wattenhofer Sent: 15 March 2013 18:16
To: oracle-l
Subject: Re: ASM rebalance question

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.
>
>
> - 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-l


______________________________________________________________________
Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential. 

If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. 
If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way. 

This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989.

Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at: http://www.morrisons.co.uk/gscop

Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, 
and it is the responsibility of recipients to carry out their own virus checks. 
______________________________________________________________________
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 19 2013 - 09:11:50 CET