Friday Dec 19, 2014

Oracle Maximum Availability Architecture Blog

Check out the Maximum Availability Architecture blog for the latest on Oracle Database high availability and data protection offerings, best practices and technology strategy. Oracle Maximum Availability Architecture (MAA) enables organizations to address all types of unplanned and planned outages - from component failures to region-wide disasters to planned maintenance, upgrades and migrations. These blog postings are created and maintained by members of Oracle’s Maximum Availability Architecture team within Oracle’s Server Technology Development group and the Oracle Database HA product marketing team. The MAA team interacts with Oracle’s customers around the world on various critical high availability (HA) initiatives. Our goal is to enrich the Oracle ecosystem with an interesting, informative and interactive conversation around Oracle MAA.

Recent updates to the MAA blog include the following topics:

Maximum Availability Architecture

Data Protection

High Availability

Please refer to the MAA website on OTN -, for the latest collection of best practices for Oracle MAA.

Monday Nov 04, 2013

Makes Sure To Learn About Oracle GoldenGate 12c

Whether you use, or are interested in using, Oracle GoldenGate for

  • real-time data integration
  • database upgrades or migrations, or
  • heterogeneous database replication

the recently launched GoldenGate 12c release will certainly proof very interesting for you.

To learn more about it, make sure to attend the upcoming webcast:

In addition, there are several great blog entries over at the Oracle Data Integration blog:

Oracle GoldenGate 12c - Leading Enterprise Replication

Replicating between Cloud and On-Premises using Oracle GoldenGate

Welcome Oracle Data Integration 12c: Simplified, Future-Ready Solutions with Extreme Performance 

Friday Mar 15, 2013

In North America, there's a MAA Workshop near you !

MAA, or the Oracle Maximum Availability Architecture, is Oracle's best practices blueprint based on Oracle high availability (HA) technologies, extensive validation performed by the Oracle MAA development team, and the accumulated production experience of customers who have successfully deployed business critical applications on Oracle.

There is great information about it on Oracle's web properties such as here or here

But sometimes, it's just great to hear straight from the experts that are in the same room than you. And that's why we organize these free MAA Workshops in a city near you:

Building a Highly Available "Always On" Oracle Database Environment

Check out the locations and dates here, and make sure to register. Enjoy !

Tuesday Feb 19, 2013

MetLife Saves With Active Data Guard and Advanced Compression

MetLife, a leading global provider of insurance, annuities and employee benefits, has been an Oracle customer and user for many years, and uses Oracle technology for many of its mission-critical applications. On top of the Oracle Database, they deployed business applications from Oracle such as PeopleSoft, Enterprise Performance Management solutions, and OBIEE.
For failover scenarios, MetLife deployed Oracle Data Guard a while back, and soon realized that with new capabilities introduced with Oracle Active Data Guard, internal global reporting functionality can easily be improved by generating reports from the open, and otherwise idle, standby database.
To increase internal resource utilization even more, MetLife made the decision to use Oracle Advanced Compression, that reduced disk space considerably for archiving requirements and production systems alike. In production environments, the savings were even multiplied as it also reduced the amount of data that gets shipped over the wire to, and stored at, every standby database.

Watch Margaret Maglione, Director of Oracle Implementation, explain how her team realized just that:

In addition, learn from Asha Santosh, Lead DBA in the Oracle Implementation Team at MetLife, how she and her team achieved all this:

Tuesday Jan 15, 2013

Maximum Availability With Oracle GoldenGate

Real-time, heterogeneous, and transactional data replication capabilities make Oracle GoldenGate a key component of the Oracle Database Maximum Availability Architecture.

Listen to this recently recorded podcast to hear Nick Wagner from Oracle GoldenGate product management team, and Joe Meeks from Oracle Database product management team discuss how to use GoldenGate for maximum availability and the new features of GoldenGate 11gR2 that strengthen its high availability solutions.

This podcast is a little recap of the great live webcast we hosted back in December 2012. In case you missed it, make sure to watch it on demand, at your convenience.

Great questions were asked during that webcast, and our expert Joe Meeks was able to answer plenty of them. Here are some great examples of that:

Q: What is the difference between the logical standby and GoldenGate ?
Joe: Data Guard logical standby (SQL Apply) is an included feature of Oracle Enterprise Edition.  It utilizes all of the same transport and role management features used by Data Guard Redo Apply (physical standby database), but it uses SQL to apply changes to a standby database that is open read-write  (physical standby uses media recovery).  The focus SQL Apply is as a feature of Data Guard for database rolling upgrades.  The process begins with a primary and Data Guard physical standby.  The standby is converted to a logical and upgraded.  Production is then switched to the standby and the original primary (now a standby) is upgraded.  From 11g onward we use the Transient Logical Rolling Upgrade Process - this results in the upgrade concluding with a primary and physical standby both at the new version.  SQL Apply is only used for replication across version

GoldenGate is our comprehensive logical replication product.  It is meant to address all advance replication needs and is the preferred solution for requirements such as reporting offload where the target database must be open read-write, bi-directional and multi-master replication, zero downtime upgrades/migrations, data integration, etc.

Q: What is it that Oracle Data Guard can do that Oracle GoldenGate can't ?
Joe: This is a backward way of asking this question :-).  GoldenGate is a comprehensive, feature rich replication product.  It can do many things Oracle Data Guard can't.

Data Guard is very focused - simple physical replication.  Unlike GoldenGate, it maintains an exact physical replica of the primary (backups are interchangeable), it has no datatype or other restrictions to consider, it uses standard Oracle Media Recovery so has very high performance for all workkloads, it has advanced corruption protection - lost-write protection and automatic block repair.  It offers both Synchronous (a guarantee of zero data loss) and Asynchronous replication.

Data Guard's primary goal is to provide the simplest, fastest, most complete data protection for Oracle Database, period.

GoldenGates primary goal is to provide the most feature-rich replication solution for the broadest possible range of requirements.

My recommendation is to first understand your requirements and preferences, then chose the right tool for that job.

Q: How can we use the new DBFS in conjunction with Oracle Data Guard and GoldenGate ?
Joe: DBFS is useful in a GoldenGate configuration to store the GoldenGate trail files and checkpoint files in DBFS to provide recoverability and failover capabilities in the event of a system failure. Using DBFS is fundamental to the continuing availability of the checkpoint and trail files in the event of a node failure. Ensuring the availability of the checkpoint files is essential to ensure that, after a failure occurs, the Extract process can continue mining from the last known archived redo log file position and Replicat processes can start applying from the same trail file position before a failure occurred. Using DBFS allows one of the surviving database instances to be the source of an Extract process or destination for the Replicat processes.

From a Data Guard perspective - anything that is in DBFS is protected just as any other database data is protected.  So DBFS provides a way to have Data Guard protect file system content for you as well that would otherwise be external to the Oracle database.

Monday Dec 03, 2012

Webcast: Maximum Availability with Oracle GoldenGate

Make sure to register here for this upcoming live webcast, with great speakers, and a live Q&A chat session.
It is scheduled for Thursday, December 13th, 2012, at 10am Pacific Time.

There are no doubts about the strength, and depth, of Oracle's offerings for highly available database environments. But depending on the nature of your data center environments, your different uses cases and workloads, your service level agreements and expectations, there might still be some open questions about what the best solutions and architectures are to assure high availability and/or affordable, efficient disaster recovery.

Therefore, this webcast will answer questions such as:

Thursday Nov 15, 2012

The Calmest IT Guy in the World

Unplanned outages and downtime still result not only in major productivity losses, but also major financial losses. Along the same lines, if zero planned downtime and zero data loss are key to your IT environment and your business requirements, planning for those becomes very important, all while balancing between performance, high availability, and cost.

Oracle Database High Availability technologies will help you achieve these mission-critical goals, and are reflected in Oracle's best practices offerings of the Maximum Availability Architecture, or MAA.

We created three neat, short videos showcasing some typical use cases, and highlighting three important components (amongst many more) of MAA:

Make sure to watch those videos here, and learn about challenges, and solutions, around High Availability database environments from a recent Independent Oracle Users Group (IOUG) survey. 

Tuesday Apr 03, 2012

Take the Oracle Database Assessment for Midsize Businesses and Enterprise Departments

Midsize businesses and enterprise departments often face the dual challenge of having to ensure 24x7 availability while operating with limited resources.  Take this assessment to see how your organization stacks up in terms of simplicity, reliability, and affordability.  And find out how the Oracle Database Appliance helps midsize businesses balance the challenge of high availability and limited resources by simplifying deployment, maintenance, and support of high-availability database workloads.

Visit this link to take the assessment:



« July 2016