Automatic Block Media Recovery is a cool 11gR2 feature. If the database on which a corruption occurs is associated with a real-time query physical standby database, then the database automatically attempts to perform block media recovery. The primary database searches for good copies of blocks on the standby database and, if found, repairs the blocks with no impact to the query that encountered the corrupt block. Only if the database is unable to repair the corruption is the Oracle physical block corruption message (ORA-1578) displayed.

Oracle Database High Availability Overview11g Release 2 (11.2) guide explains the requirements of this feature as below:

Automatic block repair requires the use of the Oracle Active Data Guard option so that you can open a physical standby database for read-write I/O. Also, note that this feature requires that Oracle Data Guard is running in maximum availability mode and has the LOG_ARCHIVE_DEST_n initialization parameter set to the SYNC redo transport mode

But, in a case we experienced in my company last week, we saw in the primary database alert.log, that the database tried to use ABMR in a Maximum Performance Data Guard configuration. Here is the log:



Thu Jan 26 17:01:17 2012
Starting background process ABMR
Thu Jan 26 17:01:17 2012
ABMR started with pid=203, OS id=661
Automatic block media recovery service is active.
Automatic block media recovery requested for (file# 13, block# 1679953)


So we raised an SR to investigate the case and informed that, only requirement is real-time apply and sync or async transport modes are supported for ABMR. This shows that the documentation i mentioned above is not up to date and if you have an 11gR2 Active Data Guard running with Maximum Performance mode, you're able to get benefit from the "Automatic Block Media Recovery" feature.

15 Responses so far.

  1. Thank you :)

    Mohamed Azar.

  2. if you want to start a website I suggest you to purchase your domain and hosting together. In this way it is possible to get your domain for free. Some hosting services offer this gift today.
    data recovery services chicago

  3. Thank you for sharing such a nice and really very helpful article
    Oracle Fusion HCM Online Training

  4. Very interesting blog Awesome post. your article is really informative and helpful for me and other bloggers too
    Oracle Fusion Technical Online Training



  5. McAfee Total Protection provides Windows, Mac and mobile virus protection, mcafee.com/activate spam filtering capabilities, the ability to securely encrypt sensitive files and much, much more. mcafee.com/activate Connect five or ten devices and protect what. McAfee Antivirus Plus includes a mcafee.com/activate variety of tools that can optimize your PC’s performance, keep it clean of cookies and temporary files and even pause annoying autoplay videos so you can enjoy a smoother experience on your PC. mcafee.com/activate Software activation code along with download instructions will be delivered in an e-mail. This code only works in.


  6. All you have to do is to activate your Amazon Prime Video on amazon.com mytv using the activation code you retrieve. amazon.com/mytv Microsoft Office is an application software. amazon.com/mytv It is used in most of the businesses and organizations Install office setup on your Pc's to get best advantage of it. amazon.com/mytv mostly used tasks are ms-word, Ms-excel and Ms-powerpoint.Amazon Web Services Scalable Cloud Computing Services: Audible Download Audio Books: DPReview Digital Photography: IMDb Movies, TV & Celebrities.Now enter the activation or verification code that appears on your tv display. amazon.com/mytv Amazon Prime Video is one of the most amazing and interesting platforms to watch. Amazon Prime on your Roku,Amazon Fire TV, Chromecast, and similar streaming devices.amazon.com/mytv Amazon Prime is a subscription-based platform that gives access to the users of amazon.com/mytv large range of services such as unlimited video streaming, amazon.com/mytv Amazon.com Store Card; Amazon Business Card; Amazon Business Line of Credit; Shop with Points; Credit Card Marketplace;



  7. Amazon Prime on your Roku,Amazon Fire TV, Chromecast, and similar streaming devices. amazon.com/mytv Amazon Prime is a subscription-based platform that gives access to the users of a large range of services such as unlimited video streaming, amazon.com/mytv Amazon.com Store Card; amazon.com/mytv Amazon Business Card; Amazon Business Line of Credit; Shop with Points; Credit Card Marketplace;Amazon Web Services Scalable amazon.com/mytv Cloud Computing Services: Audible Download Audio Books: DPReview Digital Photography: IMDb Movies, TV & Celebrities : Follow the below-stated steps to activate Amazon Prime Video on your Smart TV now: amazon.com/mytv GO to the home page of the Smart TV and search for Amazon Prime Video. Amazon App will open in front of you.amazon.com/mytv Here you will find “Register on the Amazon Website” and “Sign in and Start”. Amazon Video was previously called Amazon Video and before that it was called Amazon Instant Video. Through Amazon Prime you can enjoy new and old movies and TV service. primevideo.com/mytv Amazon Prime is very well known for its name as well as its services. Amazon Prime is the best American Internet video on demand service.


  8. Xfinity is a platform which will keep you entertained and offers HD content at a very exciting price. Xfinity.com/authorize Here you can stream any content online.Xfinity. Let's activate your device. Xfinity.com/authorize Enter your activation code: Access on Roku and smart TV's will be available once your Xfinity.com/authorize Xfinity products have been set up in your home.


    Webroot cyber security is a ultimate internet security suite for complete protection against today's diverse range of threat on windows. webroot.com/safe key features are 100% secure secure shopping, 1 click virus scanning, malicious website filtering, unblock antivirus. webroot.com/safe if you want to install it then visit our site: webroot.com/safe Get instant help for downloading webroot antivirus to protect your device appoint webroot.com/safe where you can find all your problems solved. Antivirus programming, for example, Webroot SecureAnywhere Antivirus baffles malware in two or three different ways. webroot.com/safe install webroot with key code It filters information and squares infections that it recognizes. What's more, it evacuates malware that is as of now held up in a PC. webroot.com/safe Much obliged to you for picking Webroot web security. You're nearly secured! Essentially complete the accompanying strides beneath to finish your introduce.

  9. Kaspersky Anti-Virus features include real-time protection, detection and removal of viruses, trojans, worms, spyware, adware, keyloggers, Kaspersky.com/activationmalicious tools and auto-dialers,Kaspersky.com/activation as well as detection and removal of rootkits.
    Kaspersky.com/activation
    Kaspersky.com/activation
    Kaspersky.com/activation
    Kaspersky.com/activation

  10. Roku empowers you to watch free and Roku.com/link paid video content on your TV by methods for the Internet. For Activating Roku, go to www.roku.com/associate record enter Roku com association code appeared on Roku TV. Initiate Roku tv, go to rokucom link Roku.com/link record enter Roku com connection code showed on Roku TV.
    https://rokuremoteapppcwindows.blogspot.com/
    https://beststreamingchannelsonroku.blogspot.com/
    https://watchrokuonpconwindows.blogspot.com/
    https://rokusmarttv.blogspot.com/
    https://whatchannelscanigetonroku.blogspot.com/

  11. yuvi says:

    Kaspersky Anti-Virus features include real-time protection, Kaspersky.com/activation detection and removal of viruses, trojans, worms, spyware, adware, keyloggers, Kaspersky.com/activation malicious tools and auto-dialers, Kaspersky.com/activation as well as detection and removal of rootkits.
    Kaspersky.com/activation
    Kaspersky.com/activation

  12. Sonu says:

    nfl.com.activate

    To activate NFL channel, go to nfl.com/activate to enter the TV received code. Choose your TV provider. Tap Continue to stream NFL live.

  13. Ame Auto says:

    Very Nice blog! Thanks for sharing this information here!
    Car Air Conditioning Service Perth

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -