DBV-00201: Block, DBA 1175408467, marked corrupt for invalid redo application 處理

DBV-00201: Block, DBA 1175408467, marked corrupt for invalid redo application

[@more@]

問題：

　　　一個朋友在做資料庫異機恢復時，整個 restore , recover 過程都順利進行，資料庫也可以正常 open 。 但是他對一些資料檔案執行 dbv 時報以下錯誤。

DBV-00201: Block, DBA 1175408467, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408468, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408469, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408470, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408471, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408472, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408473, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408474, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408475, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408476, marked corrupt for invalid redo application

DBV-00201: Block, DBA 1175408477, marked corrupt for invalid redo application

DBVERIFY - Verification complete

Total Pages Examined : 1024000

Total Pages Processed (Data) : 752883

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 251359

Total Pages Failing (Index): 0

Total Pages Processed (Other): 17910

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 1848

Total Pages Marked Corrupt : 5998

Total Pages Influx : 0

Highest block SCN : 2841013938 (4.2841013938)

故障分析：

該問題很有可能是由於資料庫中一些表或索引設定了　nologging ，從而導致資料庫無法把　這些表透過應用歸檔日誌來和資料庫中其他表保持一致。

解決辦法：

找出原庫中處於 nologging 的表或索引，在恢復出的庫中 刪除重建表，再透過 exp/imp 進行資料匯出匯入。如是索引，對索引進行重建。