Re: Resizing ASM disk
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: stbaldwin@xxxxxxxxxxxxxxxx
- Date: Thu, 7 May 2009 08:04:32 +0200
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@xxxxxxxxxxxxxxxx>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.
>>
>> --
>> //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.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Martin Berger martin.a.berger@xxxxxxxxx
Lederergasse 27/2/14 +43 660 660 83306
1080 Wien http://berx.at/
Other related posts:
