Re: ASM errors

From: Ram Raman <veeeraman_at_gmail.com>
Date: Tue, 24 Mar 2009 17:07:43 -0500
Message-ID: <effc058d0903241507g2f2a5308x732f1120b03bf8af_at_mail.gmail.com>

1 select group_number, name, TOTAL_MB, FREE_MB

2 from V$asm_disk_stat

3* order by 1

SYS_at_+ASM> /

more..

GROUP_NUMBER NAME TOTAL_MB FREE_MB

• --------------- ---------- ----------

0 20000 0

0 11188 0

1 DATA_0007 20000 19994 1 DATA_0006 20480 38 1 DATA_0005 7120 0 1 DATA_0001 51200 0 1 DATA_0004 5120 0 1 DATA_0000 51200 3 1 DATA_0003 5120 0 1 DATA_0002 22000 1
.....

25 rows selected.

SYS_at_+ASM>

SYS_at_+ASM> alter diskgroup DATA rebalance;

Diskgroup altered.

SYS_at_+ASM> SYS_at_+ASM>

SYS_at_+ASM> select * from v$asm_operation;

no rows selected

SYS_at_+ASM>

I dont see anything in asm-operation view. But I got the message:

---

<server> +ASM Mar24, 09 05:00:00 PM

---

ORA-15041: diskgroup space exhausted

ORA-15041: diskgroup space exhausted

Is it running out of space trying to rebalance because of lack of space in other disks?

On 3/24/09, jason arneil <jason.arneil_at_gmail.com> wrote:
>
> I think you want to do a manual rebalance. First you could check what ASM
> thinks what space each device within the diskgroup has (NOT just the
> diskgroup int total):
>
>
> select group_number, name, TOTAL_MB, FREE_MB
> from V$asm_disk_stat;
>
> If you see a device has no free space within the diskgroup, even if another device has space you will not be able to allocate extents in the diskgroup. If this is case run a manual rebalance:
>
>
> alter diskgroup DATA rebalance;
>
> You should then be able to see the rebalance occurring within v$asm_operation.
>
> cheers,
>
> jason.
>
>
> --
> http://jarneil.wordpress.com
>
>
> 2009/3/24 Ram Raman <veeeraman_at_gmail.com>
>
>> Hi,
>>
>> We ran out of space in one of the ASM volume groups and we added space to
>> it:
>>
>> State Type Rebal Unbal Sector Block AU Total_MB Free_MB
>> Req_mir_free_MB Usable_file_MB Offline_disks Name
>> MOUNTED EXTERN N N 1024 4096 1048576 182240
>> 20036 0 20036 0 DATA/
>>
>> However, this extra space is not being recognized. I want to know if
>> rebalance operation is going on. When I query the v$asm_operation view I do
>> not get any response:
>>
>> 1* select * from v$asm_operation
>> SYS_at_+ASM> /
>>
>> no rows selected
>>
>> SYS_at_+ASM>
>> How can I tell if rebalance operation is going on.
>>
>> Here is last few lines from ASM init.ora:
>>
>> WARNING: allocation failure on disk DATA_0002 for file 4 xnum 0
>> Tue Mar 24 13:50:46 2009
>> Errors in file /xxx/oracle10/app/admin/+ASM/bdump/+asm_arb1_25860.trc:
>> ORA-15041: diskgroup space exhausted
>> Tue Mar 24 13:50:46 2009
>> NOTE: stopping process ARB1
>> NOTE: stopping process ARB6
>> NOTE: stopping process ARB5
>> NOTE: stopping process ARB2
>> Tue Mar 24 13:50:46 2009
>> WARNING: allocation failure on disk DATA_0006 for file 3 xnum 20
>> Tue Mar 24 13:50:46 2009
>> WARNING: allocation failure on disk DATA_0006 for file 6 xnum 0
>> Tue Mar 24 13:50:46 2009
>> Errors in file /xxx/oracle10/app/admin/+ASM/bdump/+asm_arb0_25858.trc:
>> ORA-15041: diskgroup space exhausted
>> Tue Mar 24 13:50:46 2009
>> NOTE: stopping process ARB0
>> Tue Mar 24 13:50:46 2009
>> Errors in file /xxx/oracle10/app/admin/+ASM/bdump/+asm_arb3_25864.trc:
>> ORA-15041: diskgroup space exhausted
>> NOTE: stopping process ARB3
>> NOTE: stopping process ARB4
>> Tue Mar 24 13:50:49 2009
>> WARNING: rebalance not completed for group 1/0xa1129969 (DATA)
>> Tue Mar 24 13:50:49 2009
>> SUCCESS: rebalance completed for group 1/0xa1129969 (DATA)
>> NOTE: PST update: grp = 1
>> NOTE: PST update: grp = 1
>> Tue Mar 24 14:02:50 2009
>> WARNING: allocation failure on disk DATA_0002 for file 374 xnum 1
>>
>>
>> ver 10.2
>>
>> Thanks,
>> Ram.
>>
>>
>>
>
>
>

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

Received on Tue Mar 24 2009 - 17:07:43 CDT