Select Page

Oracle GoldenGate: The Challenges of Maintaining Zero Downtime During Upgrades

Ravish Naik | | November 16, 2017

EBS, GoldenGate, Oracle

As the Internet continues to facilitate and speed up business transactions, the well-being of a number of industries is highly dependent on how strong, available, and reliable their network connection is. Financial companies must stay constantly open during trading hours, healthcare providers always require access to patient data, and retail outlets need to check and update their inventory after every sale.

Even the slightest amount of downtime for mission-critical databases can spell a significant loss of revenue for businesses in these domains. According to a 2011 survey by IT intelligence firm IDC, for example, companies in the financial services industry lose an average of nearly $10,000 per hour of downtime. Apart from lost revenue, downtime also negatively affects consumers’ opinion of your company and harms your business reputation.

Like overworked, fatigued employees who can’t spare the time to go to the doctor, these companies are often unable to schedule upgrades and maintenance to improve the availability of their database. The question then becomes: how and when can you have extended downtime windows and planned outages?

Fortunately, there are solutions to this apparent dilemma. By forming a plan of action well in advance, you can minimize the amount of downtime that your applications need in between disconnecting and reconnecting to databases.

One of the most popular tools in this regard is Oracle GoldenGate, an application for real-time capture, routing, transformation, and delivery of data across a variety of heterogeneous business systems. This post will give a brief overview of some of the challenges of getting zero downtime when completing upgrades and migrations, and discuss how GoldenGate and other strategies can maximize uptime.

The Challenges of Getting to Zero Downtime

Because in-place database upgrades do require some degree of downtime, any business seeking to avoid downtime and planned outages must perform a rolling upgrade instead. However, such an arrangement requires you to carefully consider how you’ll deal with a number of thorny technical challenges, including:

  • Instantiation: During instantiation, the source data is copied and loaded into the target database. Throughout the migration, GoldenGate must make sure that the two databases are synchronized. This is particularly difficult when the target database is located on a different platform, or the source database has multiple terabytes of information to deal with. Testing the instantiation process with GoldenGate before using it in a production environment is highly recommended.
  • Failbacks and Backups: Once you’ve upgraded or migrated to your new solution, you should still have a failback strategy in case you experience instability or performance issues, so that you can continue to service your customers seamlessly. While using your new database, you should continue to perform the same transactions on your old database as well so that you can quickly and easily switch over if necessary.

Final Thoughts

Although it’s entirely possible to use GoldenGate for achieving zero downtime, by no means is it necessarily easy. If you need assistance with a zero-downtime migration or upgrade of your own, contact an experienced Oracle partner who can help you through the process at every step of the way. For more detailed information on maximizing the use of GoldenGate, download our white paper, Top 9 Challenges of GoldenGate – and How to Solve Them.


Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

ORA-12154: TNS:could not resolve the connect identifier specified

Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.

Jeremiah Wilton | March 4, 2009

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

12c Upgrade Bug with SQL Tuning Advisor

Learn the steps to take on your Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.