11g新功能:自动坏块修复

官档:

Automatic Block Repair

The enhancements to corrupt block detection make block repair more efficient and increase availability. The automatic block repair enhancement complements the Oracle Database 11g Release 1 automatic block corruption detection.

A detected corrupt block (for example, through a user's SQL query) is now automatically repaired by using a good block from a physical standby database. With automatic block repair, a user querying data in the corrupt block no longer sees the corrupt block error message displayed (ORA-01578). Instead, there is a pause while the corrupt block is repaired, and then the results of the SQL query are returned. The automatic block repair is transparent to the user unless the repair fails. Block recovery is faster because no redo must be applied to the block that is taken from the physical standby database.

Automatic block repair requires an Oracle Active Data Guard license because real-time query mode must be enabled on the physical standby database.

The operation occurs automatically but can also be explicitly invoked with the RMAN RECOVER BLOCK command.

自动坏块修过需要11g 的Active Data Guard 并且在physical standby 应用real-time query

-----先开个头，有空测试下