RE: Slightly Urgent ASM Question - Cancel Rebalance operation

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Wed, 24 Apr 2013 15:31:13 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F018D92A3FA_at_AAPQMAILBX02V.proque.st>

Well, certainly he should not physically drop them from the system, but if he issues 'alter diskgroup ... drop disk ....' And waits for rebalance to complete, and if the drop doesn't leave a space deficit in the diskgroup, then I don't see why he wouldn't be able to drop the disks. The DG should go back to the same state it was in before the disks were added.... -Mark

From: David Fitzjarrell [mailto:oratune_at_yahoo.com] Sent: Wednesday, April 24, 2013 3:29 PM
To: Christopher.Taylor2_at_parallon.net; oracle-l_at_freelists.org; Bobak, Mark; Dave.Herring_at_acxiom.com Subject: Re: Slightly Urgent ASM Question - Cancel Rebalance operation

I would say no, you cannot drop these disks as there may be extents moved to them that you would lose by dropping them. Other opinions may be forthcoming.

David Fitzjarrell

From: "Christopher.Taylor2_at_parallon.net<mailto:Christopher.Taylor2_at_parallon.net>" <Christopher.Taylor2_at_parallon.net<mailto:Christopher.Taylor2_at_parallon.net>> To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>; Mark.Bobak_at_proquest.com<mailto:Mark.Bobak_at_proquest.com>; Dave.Herring_at_acxiom.com<mailto:Dave.Herring_at_acxiom.com> Sent: Wednesday, April 24, 2013 1:14 PM
Subject: Slightly Urgent ASM Question - Cancel Rebalance operation

We're in the process of migrating existing ASM Disk Groups to a new storage configuration (new disks (metavolumes), same array). We've done this in DEV/QA and everything went fine.

Now, in Prod, I started the ARCHIVELOG diskgroup migration and discovered that the disks I was given aren't enough for the space I'm currently using.

So, the first thing I did was set the REBALANCE POWER for the operation to 0.

Now v$asm_operation shows no rows.

My Diskgroup in question now shows the below - what I need to know is: Can I now REMOVE the disks I started to add which are RAW112 through RAW117 until I get the right number of disks from storage, or am I in a weird/bad situation?

Thanks!!

DG_DATABASE_NAME_ARCHIVE_01

/dev/raw/raw112    DG_DATABASE_NAME_ARCHIVE_01_0001            69,044          2,326      3.37


                        /dev/raw/raw113    DG_DATABASE_NAME_ARCHIVE_01_0002            69,044          2,324      3.37

                        /dev/raw/raw114    DG_DATABASE_NAME_ARCHIVE_01_0003            69,044          2,326      3.37

                        /dev/raw/raw115    DG_DATABASE_NAME_ARCHIVE_01_0004            69,044          2,325      3.37

                        /dev/raw/raw116    DG_DATABASE_NAME_ARCHIVE_01_0005            69,044          2,326      3.37

                        /dev/raw/raw117    DG_DATABASE_NAME_ARCHIVE_01_0006            69,044          2,327      3.37

                        /dev/raw/raw70    DG_DATABASE_NAME_ARCHIVE_01_0050          138,097        71,422    51.72

                        /dev/raw/raw71    DG_DATABASE_NAME_ARCHIVE_01_0051          138,097        71,422    51.72

                        /dev/raw/raw72    DG_DATABASE_NAME_ARCHIVE_01_0052          138,097        71,412    51.71

                        /dev/raw/raw73    DG_DATABASE_NAME_ARCHIVE_01_0053          138,097        71,412    51.71

                        /dev/raw/raw79    DG_DATABASE_NAME_ARCHIVE_01_0054          138,097        71,832    52.02

                        /dev/raw/raw83    DG_DATABASE_NAME_ARCHIVE_01_0055            69,044        35,717    51.73

                        /dev/raw/raw84    DG_DATABASE_NAME_ARCHIVE_01_0056            69,044        35,733    51.75

                        /dev/raw/raw97    DG_DATABASE_NAME_ARCHIVE_01_0057            69,044        35,734    51.76

Chris Taylor
Oracle DBA
Parallon IT&S

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




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

Received on Wed Apr 24 2013 - 21:31:13 CEST