Archive for 02/01/2012 - 03/01/2012

My Presentation at OUG Ireland Conference 2012





I'll present at OUG Ireland Conference, Wednesday 21st March in Dublin. My presentation will be on Oracle Data Guard as in the Open World last year. I'm looking forward to present, listen to and meet with new people. There are a wide range of topics from Oracle professionals in the agenda. There will be 6 streams and 35 sessions in total. Well known Oracle ACEs/ACE Directors and Oracle employees will be on the stage. Some of the presentations are:

Roel Hartman, ACE Director - LOGICA - 5 Cool things you can do with HTML5
Mark Rittman, ACE Director - Rittman Mead - Inside Oracle Data Integrator 11g
Simon Haslam, ACE Director - Veriton Limited - WebLogic for DBAs
Frits Hoogland, ACE Director - VX Company - About multiblock reads
Lonneke Dikmans, ACE Director - Vennster - How do we integrate our packaged app?
Grant Ronald, ACE - Oracle - What is The Future of Forms?
Marcin Przepiorowski, ACE - Amazon - Performance troubleshooting using Active Session History
David Hall, ACE - Peak Indicators Ltd - OBIEE in Education in Action
Brendan Tierney, ACE - Dublin Institute of Technology ; Co-Presenter Antony Heljula – Peak Indicators Ltd - Getting Started with Oracle Data Miner

Event page is here and the full agenda is here.


Automatic Block Media Recovery on Maximum Performance Mode

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:

Powered by Blogger.

Page Views

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