筆者認為不能簡單的說物理硬盤的損壞導致塊的物理損壞，Oracle bug導致塊的邏輯損壞。這篇文章我們來詳細討論一下Oracle數據庫的物理損壞以及邏輯損壞的概念。下面是一篇METALINK的文章：

Physical and Logical Block Corruptions. All you wanted to know about it. [ID 840978.1]
		修改時間 21-MAY-2012     類型 BULLETIN     狀態 PUBLISHED

In this Document

創新互聯建站于2013年成立，是專業互聯網技術服務公司，擁有項目成都網站設計、成都網站制作網站策劃，項目實施與項目整合能力。我們以讓每一個夢想脫穎而出為使命，1280元濟南做網站,已為上家服務,為濟南各地企業和個人服務,聯系電話:18980820575

Purpose

Scope

Details

Physical Block Corruptions

Fractured Block

Bad Checksum

Block Misplaced

Logical Block Corruptions

References

---

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-May-2012***

Purpose

Oracle classifies the Data File Block corruptions as Physical and Logical.  This is also referred as intra block corruptions.  This document is intended to provide detailed information and errors example about it.

Scope

This document is intended for Database Administrators.

Details

Physical Block Corruptions

This kind of block corruptions are normally reported by Oracle with error ORA-1578 and the detailed corruption description is printed in the alert log. 

Corruption Examples are:

• Bad header - the beginning of the block (cache header) is corrupt with invalid values
• The block is Fractured/Incomplete - header and footer of the block do not match
• The block checksum is invalid
• The block is misplaced
• Zeroed out blocks / ORA-8103

Detailed Corruption Description:

Fractured Block

A Fractured block means that the block is incomplete. Information from the block header does not match the block tail.

Corrupt block relative dba: 0x0380e573 (file 14, block 58739)
Fractured block found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0380e573
last change scn: 0x0288.8e5a2f78 seq: 0x1 flg: 0x04
consistency value in tail: 0x00780601
check value in block header: 0x8739, computed block checksum: 0x2f00
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0380e573 (file 14, block 58739) found same corrupted data

文章名稱：Oracle數據庫塊的物理損壞與邏輯損壞-創新互聯
鏈接分享：http://vcdvsql.cn/article42/cdeghc.html

成都網站建設公司_創新互聯，為您提供網頁設計公司、網站設計、品牌網站建設、移動網站建設、服務器托管、外貿建站

廣告

聲明：本網站發布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創新互聯