ASM Diskgroup Unbalanced, Dropping Disk Fails With ORA-15041, And Disk Becomes HUNG [ID 452897.1]

ASM Diskgroup Unbalanced, Dropping Disk Fails With ORA-15041, And Disk Becomes HUNG [ID 452897.1][@more@]

ASM Diskgroup Unbalanced, Dropping Disk Fails With ORA-15041, And Disk Becomes HUNG [ID 452897.1]
		修改时间 13-MAR-2008 类型 PROBLEM 状态 MODERATED

In this Document
Symptoms
Cause
Solution
References

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2
This problem can occur on any platform.

Symptoms

When trying to drop a disk from a diskgroup with external redundancy, the following events occur:

- Getting error: ORA-15041: diskgroup space exhausted. Although there is much free space on diskgroup!
- Rebalance not completed and disk couldn't be dropped.
- Disk becomes is status HUNG.

When disk is undropped, then performing manual rebalance (using ALTER DISKGROUP REBALANCE) completes successfully, but data is not really evenly distributed among disks in the diskgroup (i.e. it seems a fake rebalance).

There might be other symptoms like:
- Many of the warning message below in the alert log of the ASM instance:
WARNING: allocation failure on disk for file xnum
- A resize of a datafile results in ORA-1237
- Errors extending objects (e.g ORA-1652, ORA-1654)

Cause

Data was not evenly distributed among disks even after manaul rebalance.
There might be inconsistency remaining in the metadata.

Solution

1- check and repair metadata inconsistency
SQL> Alter diskgroup check all repair;

2- Perform manual rebalance
SQL> alter diskgroup rebalance power 11;

(we used power 11 to make rebalance as fast as possible)

3- Monitor v$asm_operation and wait until rebalance is complete

4- Check v$asm_disk to see if data is now balanced across disks.

5- If data is now balanced correctly, then try to drop the disk you want to drop.

References

NOTE:419014.1 - ORA-15041 V$ASM_DISK Shows HUNG State for Dropped Disks

---

相关的 产品 Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition 关键字 ASM; DISK GROUP; FREE SPACE; HANGING; METADATA 错误 ORA-1237; ORA-15041; ORA-1652; ORA-1654

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/94384/viewspace-1028852/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/94384/viewspace-1028852/