Re: ASM errors
- From: Ram Raman <veeeraman@xxxxxxxxx>
- To: jason arneil <jason.arneil@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Mar 2009 17:07:43 -0500
1 select group_number, name, TOTAL_MB, FREE_MB
2 from V$asm_disk_stat
3* order by 1
SYS@+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@+ASM>
SYS@+ASM> alter diskgroup DATA rebalance;
Diskgroup altered.
SYS@+ASM> SYS@+ASM>
SYS@+ASM> select * from v$asm_operation;
no rows selected
SYS@+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@xxxxxxxxx> 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@xxxxxxxxx>
>
>> 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@+ASM> /
>>
>> no rows selected
>>
>> SYS@+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.
>>
>>
>>
>
>
>
Other related posts:
