Re: ASM errors
- From: jason arneil <jason.arneil@xxxxxxxxx>
- To: veeeraman@xxxxxxxxx
- Date: Tue, 24 Mar 2009 20:56:55 +0000
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:
