Oracle數(shù)據(jù)庫塊的物理損壞與邏輯損壞-創(chuàng)新互聯(lián)

       
        筆者認(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]
 修改時間 21-MAY-2012     類型 BULLETIN     狀態(tài) PUBLISHED 

In this Document

創(chuàng)新互聯(lián)建站于2013年成立，是專業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司，擁有項目成都網(wǎng)站設(shè)計、成都網(wǎng)站制作網(wǎng)站策劃，項目實施與項目整合能力。我們以讓每一個夢想脫穎而出為使命，1280元濟(jì)南做網(wǎng)站,已為上家服務(wù),為濟(jì)南各地企業(yè)和個人服務(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://bm7419.com/article42/cdeghc.html

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

廣告

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

成都網(wǎng)頁設(shè)計公司