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] | |||||
| 修改时间 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.2This 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
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
- 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 inconsistencySQL> Alter diskgroup
2- Perform manual rebalance
SQL> alter diskgroup
(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
产品
| |||
相关的来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/94384/viewspace-1028852/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- Windows WMIC命令详解 (Windows Management Instrumentation Command-line)
- 为monitor打PSU4 (10.2.0.4.4)的步骤
- 重建控制文件 recreate control file
- 停库前执行alter system checkpoint 很重要!
- 参加oracle 数据中心优化高峰会
- 用RMAN迁移文件到ASM或从ASM迁出
- 常用sql
- 分区操作常用sql
- How to Get a 10046 trace for a Parallel Query [ID 1102801.1]
- Master Note Parallel Execution Wait Events [ID 1097154.1]
