筆者認(rèn)為不能簡單的說物理硬盤的損壞導(dǎo)致塊的物理損壞，Oracle bug導(dǎo)致塊的邏輯損壞。這篇文章我們來詳細(xì)討論一下Oracle數(shù)據(jù)庫的物理損壞以及邏輯損壞的概念。下面是一篇METALINK的文章：

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

In this Document

創(chuàng)新互聯(lián)建站于2013年成立，是專業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司，擁有項(xiàng)目成都網(wǎng)站設(shè)計(jì)、成都網(wǎng)站制作網(wǎng)站策劃，項(xiàng)目實(shí)施與項(xiàng)目整合能力。我們以讓每一個(gè)夢想脫穎而出為使命，1280元濟(jì)南做網(wǎng)站,已為上家服務(wù),為濟(jì)南各地企業(yè)和個(gè)人服務(wù),聯(lián)系電話: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數(shù)據(jù)庫塊的物理損壞與邏輯損壞-創(chuàng)新互聯(lián)
鏈接分享：http://sd-ha.com/article42/cdeghc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)頁設(shè)計(jì)公司、網(wǎng)站設(shè)計(jì)、品牌網(wǎng)站建設(shè)、移動(dòng)網(wǎng)站建設(shè)、服務(wù)器托管、外貿(mào)建站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)