ORA-15196 WITH ASM DISKS LARGER THAN 2TB [ID 736891.1]

简介:   In this Document  Description   Likelihood of Occurrence   Possible Symptoms   Workaround or Resolution     ...

 

In this Document
  Description
  Likelihood of Occurrence
  Possible Symptoms
  Workaround or Resolution
     Workaround:
     Solution
     NOTES:
  Patches


Applies to:

  Oracle Server - Enterprise Edition - Version: 10.1.0.3 to 11.1.0.6 - Release: 10.1 to 11.1
Information in this document applies to any platform.
***Checked for relevance on 28-May-2010***

Description

A diskgroup with one or more disks of size of 2TB or larger may encounter this problem if data is allocated beyond 2TB. 

All platforms are affected as well as configurations using ASMLIB.


Likelihood of Occurrence

  • You will likely hit this problem if any of the diskgroups have disks larger than 2TB and data is allocated beyound 2TB.


 

Possible Symptoms

  • Without fix for bug 6453944, it is possible to configure a diskgroup using disks larger than 2TB.  When the space beyond 2TB is allocated, any subsequent read operation on the affected ASM metadata will return error ORA-15196.
  • Diskgroups configured with external redundancy are dismounted once error ORA-15196 is reported. 
  • Diskgroups configured with normal or high redundancy should not be affected as long as redundancy is enforced.
  • Error ORA-15196 is reported when a  block verification fails.  An indication of this problem will have the format:
ORA-15196 : invalid ASM block header [kfc.c:7997] [ hard_kfbh] [4] [4] [34 != 130]







 


@ The first line reports the asm file number (fn=4) and the block (blk4).  In this example,


  
@ kfbh.type: 0 ; 0x002: KFBTYP_INVALID

@ kfbh.type: 0 ; 0x002: KFBTYP_INVALID



Workaround or Resolution

Workaround:

  • Don't use disks larger than 2TB.

Solution

  • For diskgroups configured with external redundancy, diskgroup needs to be rebuilt using  disks under 2TB and data will need to be restored.
  • For diskgroups configured with normal or high redundancy, the only way to successfully remove the disk is via DROP DISK FORCE.
    You should not do a normal DROP DISK nor RESIZE the disk.

NOTES:

  • For Oracle Exadata Storage Server, disks larger than 2TB are supported with the fix for unpublished bug 7553876.

  • It is mandatory to drop from diskgroup any disk larger of 2TB even after applying fix for bug 6453944

Patches

The fix  prevents using disks larger than 2TB and is included in the following patchsets:

  • 10.2.0.4
  • 11.1.0.7
The patch availability can be found in metalink, searching for bug 6453944

 

目录
相关文章
创建asm disk 磁盘组出错! ORA-15018 And ORA-15107 (Doc ID 2678808.1)
ORA-15018: diskgroup cannot be created ORA-15107: missing or invalid ASM disk name
385 0
|
SQL
How To Resize An ASM Disk? (Doc ID 470209.1)
1) Please backup the database(s) contained inside the associated diskgroup. 2) Then shutdown the databases contained inside the associated diskgroup. 3) Dismount the associated diskgroup to verify no client database connections are accessing this specific diskgroup: SQL> alter diskgroup <diskgro
258 2
|
Oracle 关系型数据库 Linux
ASMFD (ASM Filter Driver) Support on OS Platforms (Certification Matrix). (文档 ID 2034681.1)
1) Starting with Oracle Grid Infrastructure 12C Release 1 (12.1.0.2), Oracle ASM Filter Driver (Oracle ASMFD) is installed with an Oracle Grid Infrastructure installation.
3036 0
|
存储 Oracle 关系型数据库
【MOS】零宕机迁移ASM磁盘组到另一个SAN/磁盘阵列/DAS的准确步骤 (文档 ID 1946664.1)
【MOS】零宕机时间迁移 ASM 磁盘组到另一个 SAN/磁盘阵列/DAS 的准确步骤 (文档 ID 1946664.1) 文档内容 目标   提问,获得帮助,并分享您对于这篇文档的经验。
1461 0
|
存储 Oracle 关系型数据库
Oracle 11gR2 restart 单机使用asm存储 主机名发生更改处理过程 (文档 ID 986740.1)
How to Reconfigure Oracle Restart (文档 ID 986740.1) In this Document Goal ...
1238 0
|
Oracle 关系型数据库
How to Copy ASM Files Across Nodes [ID 1147859.1]
  How to Copy ASM Files Across Nodes [ID 1147859.1] --------------------------------------------------------------------...
1171 0
|
SQL Oracle 关系型数据库
How to move ASM spfile to a different disk group [ID 1082943.1]
  How to move ASM spfile to a different disk group [ID 1082943.1] Goal The goal is to move ASM spfile from one disk group to another.
1442 0
|
Oracle 关系型数据库 Linux
How to use ASMCA in silent mode to configure ASM for a stand-alone server [ID 1068788.1]
  How to use ASMCA in silent mode to configure ASM for a stand-alone server [ID 1068788.
1168 0