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

 

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

 

时间: 2024-10-29 12:56:58

ORA-15196 WITH ASM DISKS LARGER THAN 2TB [ID 736891.1]的相关文章

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.1] --------------------------------------------------------------------------------     修改时间 05-OCT-2011     类型 HOWTO     状态 PUBLISHED   In this Document   Goal  

ASM Diskgroup Creation Failed with "IBM AIX RISC system/6000: 6:no such device or address" [ID 12634

In this Document  Symptoms   Cause   Solution   References Applies to:   Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ] IBM AIX on POWER Systems (64-bit) Symptoms When attempting to create an ASM(Automat

Master Note For Automatic Storage Management (ASM) For Operating System (OS) Administrators [ID 1345

In this Document  Purpose   Scope   Master Note For Automatic Storage Management (ASM) For Operating System (OS) Administrators      All Platforms      Linux x86-64      Solaris      HP-UX      IBM AIX      Microsoft Windows      IBM Linux on Z Appli

ASM 翻译系列第三弹:基础知识 About ASM disk groups, disks and files

Oracle ASM使用磁盘组来存放数据文件,每一个ASM的磁盘组由一些ASM磁盘组成,每一个ASM磁盘组本身是一个独立的存储单元,是自描述的,对于ASM磁盘组中数据库文件,ASM提供一个文件系统的接口,方便DBA做管理.存放在ASM磁盘组中的文件被均匀的分布在磁盘组中的所有磁盘上,通过这种方式,每一块磁盘都可以提供一致的性能,同时ASM的性能可以比得上裸设备的性能.[摘录自11GR2版本的ASM官方文档] ASM Disk Groups 一个ASM磁盘组是由一个或多个ASM磁盘组成的,每个AS

centos 5.4 上安装 Oracle11g R2 RAC (ASM)

-------------- 环境介绍:  -------------- 节点名称:       rac001 , rac002  数据库名称:  racdb   内存分配:      每节点 800M IP及SCANIP :  Public IP:        10.161.32.177 ,   10.161.32.179   Private IP:       10.1.1.11,     10.1.1.12    VIP:               10.161.32.187 ,  1

10G RAC RAW+ASM rhel-server-5.5-x86_64

由于学校老师只讲了11g的RAC安装,所以想自己试试,中间出了很多错误,借鉴了很多前辈写的文档,无抄袭之意,仅为自己学习所整理,可能有很多错误,欢迎指正 这里我会提供我安装过程中所需要的所有安装包和光盘镜像等,省的大家跟我似的苦逼呵呵找半天虚拟机镜像: http://pan.baidu.com/s/1dDvNcopASM软件:http://pan.baidu.com/s/1hGbz410g linux x86_64 clusterware:http://pan.baidu.com/s/1hqHv

Grid+ASM+Oracle Database 12c安装配置教程

备注:工作需要开始学习oracle,之前只学习过mysql的一些基础东东,oracle对我而言是一个新的数据体系,作为初学者,很多地方可能写的不对,只是个人理解,误导之处,请谅解,求指正![Byrd:2016年7月3日]   环境基础:   虚拟机IP(LINUX):1.1.1.212  本地IP(WIN):1.1.1.1  变量配置:   [root@oracle01 ~]# uname -a  Linux oracle01.db.hangzhou.t4x.org 2.6.32-358.el6

【RAC】在ESX 上安装asm 共享磁盘

1 修改虚拟机的所有节点的*.vmx配置文件 [root@anrac rac1]# ls rac1_1-flat.vmdk  rac1_1.vmdk  rac1-ad5ae35a.vswp  rac1-flat.vmdk  rac1.nvram  rac1.vmdk  rac1.vmsd  rac1.vmx  rac1.vmxf  添加 disk.locking = "false" 对节点rac2 重复同样的操作! 2 对磁盘进行分区(根据各个的实际情况) [root@rac1 asm

创建ASM实例及ASM数据库

--======================== -- 创建ASM实例及ASM数据库 --========================   一.ASM相关概念     1.什么是ASM(Auto Storage Management)         简称自动存储管理,是一种用于管理磁盘的工具         能够在多个物理设备之间实现条带化.镜像数据文件.恢复文件等         文件按分配单元AUs(allocation units)平衡分布在磁盘组的所有磁盘中,ASM使用索引技术