Re: ASM errors

From: jason arneil <jason.arneil_at_gmail.com>
Date: Tue, 24 Mar 2009 20:56:55 +0000
Message-ID: <fda4898f0903241356s476d11abo7dd889b97023e162_at_mail.gmail.com>

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 - 15:56:55 CDT