Re: Resizing ASM disk

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 7 May 2009 08:04:32 +0200
Message-ID: <cd8f74560905062304l6cee3f50g5c266d052148e5e2_at_mail.gmail.com>

Steve,
have you checked
v$asm_operation
if there where any ongoing operation?
a resize implicite performs a rebalance.

just a starting question so far ...

On Wed, May 6, 2009 at 23:17, Steve Baldwin <stbaldwin_at_multiservice.com>wrote:

> More on this ...
>
> After resizing the disk in ASM I shrunk the disk volume in our storage
> array. ASM was of course down at the time.
>
> When I attempted to restart ASM I saw this ...
>
> SQL> startup
> ASM instance started
>
> Total System Global Area 283930624 bytes
> Fixed Size 2158992 bytes
> Variable Size 256605808 bytes
> ASM Cache 25165824 bytes
> ORA-15032: not all alterations performed
> ORA-15036: disk '/dev/iscsi/dbR1' is truncated
>
> None of my diskgroups are mounted ...
>
> SQL> select group_number, name, state from v$asm_diskgroup;
>
> GROUP_NUMBER NAME STATE
> ------------ --------------- ---------------------------------
> 0 DATA DISMOUNTED
> 0 FRA DISMOUNTED
>
> Any clues?
>
> Thanks,
>
> Steve
>
>
> On 07/05/2009, at 6:41 AM, Steve Baldwin wrote:
>
> I just tried to resize an ASM disk and although the feedback was
>> 'successful', there doesn't appear to have been any change.
>>
>> I was attempting to shrink disk DATA_0001 from 200G to 100G. Am I missing
>> something obvious?
>>
>> SQL> select group_number, name, path, os_mb, total_mb, free_mb from
>> v$asm_disk;
>>
>> GROUP_NUMBER NAME PATH
>> OS_MB TOTAL_MB FREE_MB
>> ------------ -------------------- ------------------------------
>> ---------- ---------- ----------
>> 0 /dev/iscsi/rman11 20489
>> 0 0
>> 0 /dev/iscsi/rmanB11 102398
>> 0 0
>> 0 /dev/iscsi/rman1 20490
>> 0 0
>> 0 /dev/iscsi/vote3 300
>> 0 0
>> 0 /dev/iscsi/vote1 300
>> 0 0
>> 0 /dev/iscsi/rmanP11 204805
>> 0 0
>> 0 /dev/iscsi/vote2 300
>> 0 0
>> 0 /dev/iscsi/rmanP1 204810
>> 0 0
>> 0 /dev/iscsi/rmanB1 102405
>> 0 0
>> 1 DATA_0000 /dev/iscsi/db1 10245
>> 10245 10109
>> 2 FRA_0000 /dev/iscsi/flshbk1 20490
>> 20490 20465
>>
>> GROUP_NUMBER NAME PATH
>> OS_MB TOTAL_MB FREE_MB
>> ------------ -------------------- ------------------------------
>> ---------- ---------- ----------
>> 2 FRA_0001 /dev/iscsi/flshbkR1 409605
>> 409605 409262
>> 1 DATA_0001 /dev/iscsi/dbR1 204810
>> 204810 202297
>>
>> 13 rows selected.
>>
>> SQL> alter diskgroup data resize disk 'data_0001' size 100g;
>>
>> Diskgroup altered.
>>
>> SQL> select group_number, name, path, os_mb, total_mb, free_mb from
>> v$asm_disk;
>>
>> GROUP_NUMBER NAME PATH
>> OS_MB TOTAL_MB FREE_MB
>> ------------ -------------------- ------------------------------
>> ---------- ---------- ----------
>> 0 /dev/iscsi/rman11 20489
>> 0 0
>> 0 /dev/iscsi/rmanB11 102398
>> 0 0
>> 0 /dev/iscsi/rman1 20490
>> 0 0
>> 0 /dev/iscsi/vote3 300
>> 0 0
>> 0 /dev/iscsi/vote1 300
>> 0 0
>> 0 /dev/iscsi/rmanP11 204805
>> 0 0
>> 0 /dev/iscsi/vote2 300
>> 0 0
>> 0 /dev/iscsi/rmanP1 204810
>> 0 0
>> 0 /dev/iscsi/rmanB1 102405
>> 0 0
>> 1 DATA_0000 /dev/iscsi/db1 10245
>> 10245 10004
>> 2 FRA_0000 /dev/iscsi/flshbk1 20490
>> 20490 20465
>>
>> GROUP_NUMBER NAME PATH
>> OS_MB TOTAL_MB FREE_MB
>> ------------ -------------------- ------------------------------
>> ---------- ---------- ----------
>> 2 FRA_0001 /dev/iscsi/flshbkR1 409605
>> 409605 409262
>> 1 DATA_0001 /dev/iscsi/dbR1 204810
>> 204810 202402
>>
>> 13 rows selected.
>>
>> The free_mb seems to have increased, but otherwise I can't see the effect
>> of my change. Maybe I'm looking in the wrong place??
>>
>> I tried restarting the ASM instance but it made no difference.
>>
>> Thanks,
>>
>> Steve
>>
>> This email is intended solely for the use of the addressee and may
>> contain information that is confidential, proprietary, or both.
>> If you receive this email in error please immediately notify the
>> sender and delete the email.
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
> This email is intended solely for the use of the addressee and may
> contain information that is confidential, proprietary, or both.
> If you receive this email in error please immediately notify the
> sender and delete the email.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Martin Berger           martin.a.berger_at_gmail.com
Lederergasse 27/2/14           +43 660 660 83306
1080 Wien                                       http://berx.at/

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

Received on Thu May 07 2009 - 01:04:32 CDT