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 进行数据导出导入。如是索引，对索引进行重建。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/66634/viewspace-1059635/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/66634/viewspace-1059635/