11g新功能:自动坏块修复_automatic block repair-优快云博客

本文介绍Oracle 11g Release 1中引入的自动坏块修复功能，该功能通过从物理备用数据库获取良好区块来自动修复损坏的区块，提高了数据可用性和查询效率。自动修复过程对用户透明，除非修复失败。此特性需要Oracle Active Data Guard许可并启用实时查询模式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

官档:

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

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