Skip to Main Content

Feature Details

Buttons

Feature Details Container

Automatic Block Repair

Availability → RMAN

Automatic block repair allows corrupt blocks on the primary database or physical standby database to be automatically repaired, as soon as they are detected, by transferring good blocks from the other destination. In addition, RECOVER BLOCK is enhanced to restore blocks from a physical standby database. The physical standby database must be in real-time query mode.

Business Benefit: This feature reduces time when production data cannot be accessed, due to block corruption, by automatically repairing the corruptions as soon as they are detected in real-time using good blocks from a physical standby database. This reduces block recovery time by using up-to-date good blocks from a real-time, synchronized physical standby database as opposed to disk or tape backups or flashback logs.

Release Availability
11.2
12.1
12.2
18c
19c
21c
23ai
Parent Feature
Automatic Block Repair
Available On
  • Enterprise Edition
  • Oracle Database Appliance
  • Exadata
  • Exadata Cloud Service / Cloud@Customer
  • Database Cloud Service Enterprise Edition - Extreme Performance

Notes:

EE, ODA, and Exa: Requires the Oracle Active Data Guard option

Initial Release
11.2.0.1