Home > Oracle > Corrupted Block Recovery – using standby

Corrupted Block Recovery – using standby


In 11g you can open the Physical standby database in Real Time Query while in recovery.  Using this physical  standby database  the corrupted blocks in primary will be automatically recovered by a new process ABMR (ABMR stand for Automatic Block Media Recovery). 

Oracle documentation says,

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. An ORA-1578 error is returned when automatic repair is not possible.

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 as described on the standby database:

 Also see a test case from Gavin Soorma,

http://gavinsoorma.com/2010/09/11g-active-standby-database-automatic-block-corruption-repair/

And even ABMR process is able to recover a corrupted block in a standby using a good block from Primary.  This is interesting.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: