关闭

Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 with an AU siz

标签: fileallocationdiskpatchoracle
6526人阅读 评论(0) 收藏 举报
分类:

Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 with an AU size > 1M [ID 1145365.1]


 

Modified 29-SEP-2010     Type ALERT     Status PUBLISHED

 

In this Document
  Description
  Likelihood of Occurrence
  Possible Symptoms
  Workaround or Resolution
  Patches
  Modification History
  References


Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 to 11.2.0.1 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Description

This problem has been reported for 10gR2 created disk groups with the AU size greater than 1MB and that have fewer than 3585 user files and after migrating to 11.2 ASM.
--导致ORA-15196的条件

SQL> select name,allocation_unit_size from v$asm_diskgroup, will show you the AU size.

 

[oracle@rac1 ~]$ oerr ora 15196

15196, 00000, "invalid ASM block header [%s:%s] [%s] [%s] [%s] [%s != %s]"

// *Cause:  ASM encountered an invalid metadata block.

// *Action: Contact Oracle Support Services.

 

这个是10.2 的一个ASM:

SQL> select name,allocation_unit_size from v$asm_diskgroup;

 

NAME                           ALLOCATION_UNIT_SIZE

------------------------------ --------------------

DATA                                        1048576

FRA                                         1048576

Likelihood of Occurrence

1) 11.2 detects no formatted blocks beyond blocks that hold < 3585 user asm file when the au size is > than 1MB (the default)

2) This is identified due to the unpublished Bug 5100163

-- 导致错误的原因

Possible Symptoms

. After upgrading a 10gR2 ASM instance to 11.2, ASM is able to mount the disk groups but these are dismounted as soon as v$asm_file is queried:

-- bug 没有修复时,将ASM 10gR2 升级到11gR2之后,ASM 可以正常的mount,但是一查询v$asm_file disk groups 就会变成dismounted

 

SUCCESS: diskgroup DATA_DG01 was mounted
SUCCESS: ALTER DISKGROUP DATA_DG01 MOUNT /* asm agent */
Thu Jun 24 15:13:05 2010
NOTE: diskgroup resource ora.DATA_DG01.dg is online
Thu Jun 24 15:18:31 2010
WARNNING: cache read a corrupted block group=DATA_DG01 fn=1 blk=512 from disk 0
NOTE: a corrupted block from group DATA_DG01 was dumped to
/u000/app/grid/diag/asm/+asm/+ASM/trace/+ASM_ora_348464.trc
WARNNING: cache read(retry) a corrupted block group=DATA_DG01 fn=1 blk=512
from disk 0
ERROR: cache failed to read group=DATA_DG01 fn=1 blk=512 from disk(s): 0
DATA_DG01_0000
ORA-15196: invalid ASM block header [kfc.c:23925] [hard_kfbh] [1] [512] [0 !=130]



 

Workaround or Resolution

1) Run the following from 11.2 ASM on each disk group a few times (say 3 times):
--解决方法一

SQL> ALTER DISKGROUP <DG_NAME> CHECK ALL REPAIR;

 On the first time they execute this command, the ASM alert log will show entries like:
 "ERROR: file 1 extent 0: blocks XX to XX are unformatted"
 The next runs, the ASM alert logs will show something like:
 ERROR: file 1 extent 0: blocks XX to XX are unformatted"
 "SUCCESS: file 1 extent 0 repaired"



2) Check if ASM in 11.2 still dismounts the disk group when querying v$asm_file.

3) If the disk group continues to be dismounted with the above errors, then restore the 10gR2 environment (like prior to the ASM upgrade) and then apply
Patch 5100163 to the 10.2.0.4 ASM home To obtain the patch go to MyOracleSupport, if the following link does not work:

https://updates.oracle.com/download/5100163.html

4) After the patch was installed, then run the ALTER DISKGROUP...CHECK ALL REPAIR on all the disk groups. Then retry the ASM upgrade.

Patches

1) Before upgrade ASM from release 10.2 to release 11.2 please apply the Patch 5100163 on the 10.2 ASM Oracle Home

-- 先将patch 打上,然后在将ASM 10.2 升级到11.2.

2) This patch can be obtained  from MOS:

https://updates.oracle.com/download/5100163.html


References

PATCH:5100163 - INVALID BLOCK HEADER AFTER CRASH RECOVERY W/ 2M AUS

 

 

 

 

 

-------------------------------------------------------------------------------------------------------

QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave

DBA1 群:62697716();   DBA2 群:62697977()   DBA3 群:62697850()  

DBA 超级群:63306533();  DBA4 群: 83829929  DBA5群: 142216823   

聊天 群:40132017   聊天2群:69087192

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

0
0
查看评论

OCP-1Z0-053-200题-168题-528

QUESTION 168 What is the default AU size of an ASM disk group? Whatis the maximum AU size in an ASM disk group? A. 100KB default, 10TB maximum B. 2...
  • rlhua
  • rlhua
  • 2014-02-04 21:59
  • 2348

OCP-1Z0-053-V12.02-528题

528.What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group? A. 100KB default, 10TB maximum B. 256KB def...
  • rlhua
  • rlhua
  • 2013-11-04 14:58
  • 4819

Oracle ASM - 概念之AU,分区,条带,模板

Oracle11gR2官方文档对ASM进行了详细介绍 http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmcon.htm#i1021951 -------------------------------------------------...
  • deanza
  • deanza
  • 2013-08-26 16:01
  • 1224

asm 磁盘头丢失,损坏

BUG 14693394 – ORA-15196: INVALID ASM BLOCK HEADER [KFC.C:26076] [ENDIAN_KFBH] BUG 14758001 – ORA-15196: INVALID ASM BLOCK HEADER [KFC.C:23924] [ENDI...
  • jlhnxly
  • jlhnxly
  • 2014-10-08 23:12
  • 1426

Oracle 11g asm中不同au size下datafile的au分布初探

今天有朋友问11g中asm 的au size不为1m的情况下,datafile的au 分布是怎么样的?通过10g的方式去kfed read, 发现不对了,原帖地址:~~【高手请进】在oracle11g中通过kfed找到ASM AU空间分布信息? 下午花了一点时间研究了一下,其中还有些没有明白,不...
  • lovewifelovelife
  • lovewifelovelife
  • 2012-08-27 21:31
  • 1209

11G RAC安装运行ASMCA遇到的小问题:ASMCA detected pre 11gR2 ASM, but it does not have a local instance configure

问题描述: 11G RAC安装时,GI已经安装完成,各服务状态正常,运行ASMCA时出错(ASM实例状态都是正常的)。 提示是:ASMCA detected pre 11gR2 ASM, but it does not have a local instance configure on t...
  • q947817003
  • q947817003
  • 2014-09-07 15:05
  • 2869

一步一步在Linux上升级10gR2 RAC到11gR2 RAC

概述:     继本人上一个系列的Oracle 11gR2 RAC+DG项目实战教程发布已一年有余,在此期间,那个系列的教程得到众多网友的喜爱与好评,更是在互联网上畅销不衰。为此,众多网友也一直希望本人推出Oracle 10...
  • x252513
  • x252513
  • 2014-11-14 16:05
  • 238

#ASM 翻译系列第三十三弹:ASM 高级知识 REQUIRED_MIRROR_FREE_MB

原文: REQUIRED_MIRROR_FREE_MB 作者: Bane Radulovic 译者:陈亚军,沃趣科技数据库技术工程师,主要参与公司产品实施、测试、维护以及优化。 审校:魏兴华 责编:仲培艺 REQUIRED_MIRROR_FREE_MB和USABLE_FILE...
  • woqutechteam
  • woqutechteam
  • 2017-02-24 14:47
  • 234

MYSQL 连接数据库命令收藏

MYSQL 连接数据库命令收藏 一、MySQL 连接本地数据库,用户名为“root”,密码“123”(注意:“-p”和“123” 之间不能有空格) C:\>mysql -h localhost -u root -p123 二、MySQL 连接远程数据库(192.168.0...
  • jaray
  • jaray
  • 2014-02-28 15:18
  • 394

v$asm_diskgroup和v$asm_disk中对于 disk 大小的不同含义

v$asm_diskgroup和v$asm_disk中对于 disk 大小的不同含义
  • msdnchina
  • msdnchina
  • 2015-02-17 12:00
  • 5770
    Oracle数据库问题解决方案和故障排除手册
    Dave 新博客
    CNDBA 社区交流QQ群

    • CNDBA_1: 62697850 (大量空闲)
    • CNDBA_2: 62697716(大量空闲)
    • CNDBA_3: 283816689
    • CNDBA_4: 391125754
    • CNDBA_5: 104207940(满)
    • CNDBA_6: 62697977
    • CNDBA_7: 142216823(满)
    个人资料
    • 访问:12431721次
    • 积分:118755
    • 等级:
    • 排名:第4名
    • 原创:1006篇
    • 转载:86篇
    • 译文:2篇
    • 评论:1576条
    Oracle 组织

    安徽DBA俱乐部
    • 安徽DBA俱乐部,俱乐部整合安徽地区的IT资源,现有成员已经包含安徽大部分IT公司,俱乐部除了资讯信息分享之外,也会定期举行线下活动。欢迎安徽地区的DBA 加入.

      QQ群:363076776 安徽DBA俱乐部/ahdba.com ,备注,加群必须注明籍贯,该群只对安徽地区开放。

    • 网址:www.ahdba.com
    最新评论