Automatic Repair of Corrupt Data Blocks on Standby Database- 11g R2 –Posted: 20/11/2010
Automatic Repair of Corrupt Data Blocks
A physical standby database operating in real-time query mode can also be used to repair corrupt data blocks in a primary database. If possible, any corrupt data block encountered when a primary database is accessed is automatically replaced with an uncorrupted copy of that block from a physical standby database operating in real-time query mode. Note that for this to work, the standby database must be synchronized with the primary database.
If a corrupt data block is discovered on a physical standby database, the server attempts to automatically repair the corruption by obtaining a copy of the block from the primary database if the following database initialization parameters are configured on the standby database:
LOG_ARCHIVE_CONFIGparameter is configured with a
DG_CONFIGlist and a
nparameter is configured for the primary database
FAL_SERVERparameter is configured and its value contains an Oracle Net service name for the primary database
If automatic repair is not possible, an
ORA-1578 error is returned.