Re: ASM alter diskgroup is hanging
Date: Mon, 8 Sep 2014 07:36:09 -0700 (PDT)
Message-ID: <c30ee29d-f6e6-4e9b-a2ff-84d94ee78ff0_at_googlegroups.com>
Mon, 08 Sep 2014 07:36:09 -0700 (PDT)
X-Received: by 10.182.126.37 with SMTP id mv5mr4382obb.33.1410186969187; Mon,
08 Sep 2014 07:36:09 -0700 (PDT)
Path: textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!192.71.180.34.MISMATCH!newsfeed1.swip.net!newspeer1.nac.net!border2.nntp.dca1.giganews.com!nntp.giganews.com!m5no6731615qaj.0!news-out.google.com!ht4ni0igb.0!nntp.google.com!r2no16852804igi.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.oracle.server
Date: Mon, 8 Sep 2014 07:36:09 -0700 (PDT)
In-Reply-To: <2184a3ef-f3ff-4cb8-ac8b-3efd5d840563_at_googlegroups.com>
Complaints-To: groups-abuse_at_google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host&01:4:1980:483:1deb:3557:e542:4742;
posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
NNTP-Posting-Host: 2601:4:1980:483:1deb:3557:e542:4742
References: <2184a3ef-f3ff-4cb8-ac8b-3efd5d840563_at_googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <c30ee29d-f6e6-4e9b-a2ff-84d94ee78ff0_at_googlegroups.com>
Subject: Re: ASM alter diskgroup is hanging
From: Mark D Powell <markp28665_at_gmail.com>
Injection-Date: Mon, 08 Sep 2014 14:36:09 +0000
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Bytes: 2389
Lines: 32
Xref: textnews.cambrium.nl comp.databases.oracle.server:98913
On Monday, September 8, 2014 2:45:11 AM UTC-4, mjm..._at_gmail.com wrote:
> I am a newcomer to using ASM for data storage (so be gentle :) )
>
> We are on version 11.2.0.4.0
>
> I am running the following from the +ASM instance :
>
>
> SQL> alter diskgroup DATADG add disk '/dev/md/rdsk/d29';
>
> However the problem is that this statement is hanging.
>
> I have 2 questions :
>
> 1. Is there any way to identify what is preventing this statement from completing?
>
> 2. Should I shutdown the other databases which use this ASM instance before attempting the
>
> above command?
>
> Many Thanks.
I have not used ASM in a while but when you add a disk to a diskgroup you trigger a rebalance operation. The rebalance can take hours depending on how many disks are in the diskgroup and the underlying speed of your physical disk. If you have multiple disks to add you should add then in a single operation so you rebalance all the disks at one time.
Check the manuals. You should be able to see if a rebalance is in effect.
HTH -- Mark D Powell -- Received on Mon Sep 08 2014 - 16:36:09 CEST