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-2010Type ALERTStatus 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.
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
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
-- 导致错误的原因
. 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]
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.
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
PATCH:5100163 - INVALID BLOCK HEADER AFTER CRASH RECOVERY W/ 2M AUS
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
Exam Ref 70-761 Querying Data with Transact-SQL by Itzik Ben-Gan English | 4 Apr. 2017 | ASIN: B06Y21QGGQ | 352 Pages | AZW3 | 23.79 MB Prepare for Microsoft Exam 70-761–and help demonstrate your ...
Human Interaction With Graphs: A Visual Querying Perspective (Synthesis Lectures on Data Management) By 作者: Sourav S Bhowmick – Byron Choi – Chengkai Li ISBN-10 书号: 1681733765 ISBN-13 书号: ...
Wifi (802.11) In a wireless LAN, wireless users transmit/receive packets to/from an base station (i.e., wireless access point) within a radius of few tens of meters. The base station is typically ...
"The DHCP client was unable to obtain an IP network address from a DHCP server. Do you want to see future DHCP messages?" This message means that TCP/IP has initialized but without any addressing ...
3 Enhancements to the GROUP BY Clause Objectives 3-2 Review of Group Functions 3-3 Review of the GROUP BY Clause 3-4 Review of the HAVING Clause 3-5 GROUP BY with ROLLUP and CUBE Operators 3-6 ROLLUP ...
An isolation level determines the degree to which data is isolated for use by one process and guarded against interference from other processes. Prior to SQL Server 7.0, REPEATABLE READ and ...
搜索需要高效的搜索效率,该文档讲了有效率的信息检索,倒排索引排序的优化。
TSQL_Querying_20061113
Delve into the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from a highly regarded T-SQL expert and members of Microsoft's SQL ...
I had met Itzik Ben-Gan briefl y a couple of times and knew of his reputation, so I was looking forward to his afternoon session on avoiding cursors in SQL programming at PASS. I was lucky to get ...
Querying Microsoft SQL Server 2012
The format of the symbol name should be <PROJECT>_<PATH>_<FILE>_H_. To guarantee uniqueness, they should be based on the full path in a project's source tree. For example, the file foo/src/bar/baz.h...
In the tradition of the best-selling Getting to Know series, Getting to Know ArcGIS Pro teaches new and existing GIS users how to get started solving problems by visualizing, querying, creating, ...
2: PART 1 – C# 7.1 3: SPEAKING C# 4: CONTROLLING THE FLOW AND CONVERTING TYPES 5: WRITING, DEBUGGING, AND TESTING FUNCTIONS 6: BUILDING YOUR OWN TYPES WITH OBJECT-ORIENTED PROGRAMMING 7: IMPLEMENTING...
Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain ...
Chapter 2: Simple Querying 25 Chapter 3: Simple Insertion 59 Chapter 4: Exception Handling 101 Chapter 5: Results Record-by-Record 129 Chapter 6: Inserting Multiple Entries 161 Chapter 7: Creating and...
In earlier revisions, the error status light was cleared after a VsSetWavelength() call failed, so the user did not see the light turn red to alert that an error had occurred. This has been fixed in ...
Although it sounds like an easy task to build and maintain database applications, it can be challenging to get beyond the basics and develop applications that meet your needs perfectly. The ...
MongoDB has grown to become the de facto NoSQL database with millions of users—from small startups to Fortune 500 companies. Addressing the limitations of SQL schema-based databases, MongoDB ...
Take your data access skills to the next level with Entity Framework About This Book Learn how to create, retrieve, update, and delete the data in a relational database using .NET Choose from an ...