當前位置:成語大全網 - 新華字典 - Oracle數據庫遇到ORA-01578壞塊錯誤的原因是什麽,求解釋?

Oracle數據庫遇到ORA-01578壞塊錯誤的原因是什麽,求解釋?

Oracle數據恢復ORA-01578錯誤解析

壹般認為ORA-1578是 數據塊物理壞塊/損壞的壹種,不同於邏輯損壞/壞塊,其錯誤信息如下:

[oracle@oel8 dirdat]$ oerr ora 1578

01578, 00000, "ORACLE data block corrupted (file # %s, block # %s)"

// *Cause: The data block indicated was corrupted, mostly due to software

// errors.

// *Action: Try to restore the segment containing the block indicated. This

// may involve dropping the segment and recreating it. If there

// is a trace file, report the errors in it to your ORACLE

// representative

這個1578壹般 會伴隨ORA-1110出現,壹旦ORACLE讀取到存在損壞的塊就會報出:

SQL> select * from scott.emp;

select * from scott.emp

*

ERROR at line 1:

ORA-01578: ORACLE data block corrupted (file # 11, block # 34) 這裏的FILE#是 RFN

ORA-01110: data file 6:'/home/oracle/corrclass.dbf' 這裏的是AFN

斷裂的數據塊Fractured Block:

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

或者錯誤的校驗和checksum

Corrupt block relative dba: 0x0380a58f (file 14, block 42383)

Bad check value found during buffer read

Data in bad block -

type: 6 format: 2 rdba: 0x0380a58f

last change scn: 0x0288.7784c5ee seq: 0x1 flg: 0x06

consistency value in tail: 0xc5ee0601

check value in block header: 0x68a7, computed block checksum: 0x2f00

spare1: 0x0, spare2: 0x0, spare3: 0x0

***

Reread of rdba: 0x0380a58f (file 14, block 42383) found same corrupted data

或者錯誤的塊頭

Corrupt block relative dba: 0x0d805a89 (file 54, block 23177)

Bad header found during buffer read

Data in bad block -

type: 6 format: 2 rdba: 0x0d805b08

last change scn: 0x0692.86dc08e3 seq: 0x1 flg: 0x04

consistency value in tail: 0x08e30601

check value in block header: 0x2a6e, computed block checksum: 0x0

spare1: 0x0, spare2: 0x0, spare3: 0x0

***

Reread of rdba: 0x0d805a89 (file 54, block 23177) found valid data

壹些可能引起ORA-1578的BUG 列表如下:

如果自己搞不定可以找ASKMACLEAN專業數據庫修復團隊成員幫您恢復!