ASM errors
Date: Tue, 24 Mar 2009 14:17:44 -0500
Message-ID: <effc058d0903241217yf8a6b32j70fcc9d7f6feb0b8_at_mail.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-lReceived on Tue Mar 24 2009 - 14:17:44 CDT