RE: Slightly Urgent ASM Question - Cancel Rebalance operation
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <Mark.Bobak@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <Dave.Herring@xxxxxxxxxx>
- Date: Wed, 24 Apr 2013 14:28:43 -0500
Specified as an ADD and DROP in one statement.
GROUP_NUMBER DISK_NUMBER NAME PATH
MOUNT_S HEADER_STATU MODE_ST STATE
------------ ----------- ------------------------------
------------------------------ ------- ------------ ------- --------
1 8 DG_CCMNASP1_ARCHIVE_01_0001 /dev/raw/raw112
CACHED MEMBER ONLINE NORMAL
1 9 DG_CCMNASP1_ARCHIVE_01_0002 /dev/raw/raw113
CACHED MEMBER ONLINE NORMAL
1 10 DG_CCMNASP1_ARCHIVE_01_0003 /dev/raw/raw114
CACHED MEMBER ONLINE NORMAL
1 11 DG_CCMNASP1_ARCHIVE_01_0004 /dev/raw/raw115
CACHED MEMBER ONLINE NORMAL
1 12 DG_CCMNASP1_ARCHIVE_01_0005 /dev/raw/raw116
CACHED MEMBER ONLINE NORMAL
1 13 DG_CCMNASP1_ARCHIVE_01_0006 /dev/raw/raw117
CACHED MEMBER ONLINE NORMAL
1 0 DG_CCMNASP1_ARCHIVE_01_0050 /dev/raw/raw70
CACHED MEMBER ONLINE DROPPING
1 1 DG_CCMNASP1_ARCHIVE_01_0051 /dev/raw/raw71
CACHED MEMBER ONLINE DROPPING
1 2 DG_CCMNASP1_ARCHIVE_01_0052 /dev/raw/raw72
CACHED MEMBER ONLINE DROPPING
1 3 DG_CCMNASP1_ARCHIVE_01_0053 /dev/raw/raw73
CACHED MEMBER ONLINE DROPPING
1 4 DG_CCMNASP1_ARCHIVE_01_0054 /dev/raw/raw79
CACHED MEMBER ONLINE DROPPING
1 5 DG_CCMNASP1_ARCHIVE_01_0055 /dev/raw/raw83
CACHED MEMBER ONLINE DROPPING
1 6 DG_CCMNASP1_ARCHIVE_01_0056 /dev/raw/raw84
CACHED MEMBER ONLINE DROPPING
1 7 DG_CCMNASP1_ARCHIVE_01_0057 /dev/raw/raw97
CACHED MEMBER ONLINE DROPPING
Regarding your PS, I know [unfortunately]. It was a stopgap measure and
temporary and this storage migration will resolve that.
I talked to the storage folks and was acknowledged that they inadvertently
shorted me disks.
Another question, can I run an ADD DISK to add additional DISKS while this
operation is in this state?
Any other thoughts are much appreciated!
Chris
From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxx]
Sent: Wednesday, April 24, 2013 2:22 PM
To: Taylor Christopher - Nashville; oracle-l@xxxxxxxxxxxxx;
Dave.Herring@xxxxxxxxxx
Subject: RE: Slightly Urgent ASM Question - Cancel Rebalance operation
Hi Chris,
Did you just add the new disks, or did you issue a single alter diskgroup
command that specified an add and a drop?
What state are the disks in?
select
group_number,disk_number,name,path,mount_status,header_status,mode_status,state
from v$asm_disk;
If all you did was add new disks, then you should be able to just as easily
drop them again, with no harm.
-Mark
PS Not directly related to your question, but all the disks in a given
diskgroup should be the same size, or you can run into weird space allocation
errors, where there's free space in a DG, but it can't be used, and you'll get
out of space errors with free space available.
From: Christopher.Taylor2@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>
[mailto:Christopher.Taylor2@xxxxxxxxxxxx]
Sent: Wednesday, April 24, 2013 3:15 PM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>; Bobak, Mark;
Dave.Herring@xxxxxxxxxx<mailto:Dave.Herring@xxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
