Re: Slightly Urgent ASM Question - Cancel Rebalance operation

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 24 Apr 2013 12:28:58 -0700 (PDT)
Message-ID: <1366831738.50015.YahooMailNeo_at_web121606.mail.ne1.yahoo.com>

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" <Christopher.Taylor2_at_parallon.net> To: oracle-l_at_freelists.org; Mark.Bobak_at_proquest.com; 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:28:58 CEST