High availability with Oracle Standard Edition

Simple Continuous Operation

Live Activation

Live activation of replication followed. This approach ran smoothly at the beginning but, unfortunately, further problems gradually arose during continued production. These were minor bugs in Windows and a bigger problem in the context of CLOBs that were not replicated cleanly. These obstacles had to be worked through step by step.

Because the provision of the HA environment was not ensured at this time, a standby database was set up in parallel with Dbvisit Standby. This was not a problem regarding either performance aspects or a license. Dbvisit provided the Standby license free of charge for as long as the problems with replication were not solved.

All in all, a number of checks and procedures need to be established for the regular operation and a possible switchover, as well as for the failover, to ensure smooth replication and a secure HA environment. Difficulties, complexities, and limitations resulted in an unexpected solution at the end of this project. Together with Dbvisit Standby, a double strategy, so to speak, was implemented that benefitted from the advantage of both solutions: All restrictions regarding non-replicated DDLs, SYS and SYSTEM schemes, and data types using Dbvisit Standby were bypassed, which allowed losses of actual production data to remain as low as possible using replication.

Another advantage is seen in the ease of handling Dbvisit Standby during a switchover. The replication is simply suspended. When a failover occurs (i.e., a total failure of the primary server), the standby database can be activated and, in case of doubt, lost data that has reached the other side via replication, can be imported using a DB Compare.

Conclusions

Is logical replication therefore suitable for implementing a high-availability environment? Sadly, the unsatisfactory answer is: It depends. A standby database provides the advantage of close integration in the database architecture. However, it is static, but very robust, when it is installed correctly.

In this case, several problems and all the options in Oracle Database Standard Edition bring the logical replication to its limits. The more complex the database structure, the less advisable it becomes to rely solely on logical replication. With additional goals, such as a user-friendly switchover, the IT manager must opt for the simpler standby solution with time offset or accept additional costs in the Enterprise Edition and Data Guard (or other products).

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy ADMIN Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

  • PostgreSQL Replication Update
    High availability, replication, and scaling are everyday necessities in the database world. What features does PostgreSQL offer in this context, and how good are they?
  • What's new in PostgreSQL 9.4
    The PostgreSQL Global Development Group recently introduced the new major version 9.4 of the popular free database, which includes innovative functions as well as a whole range of changes regarding speed and functionality.
  • Setting up MariaDB replication with the help of XtraBackup
    If your database is so important that the content must not be lost between periodic data backups, replication is a possible solution. We describe how to set up replication for MariaDB with the aid of XtraBackup.
  • Oracle Database 12c: Cloud computing with multitenant architecture
    More than 500 new features have been incorporated into the current release of Oracle Database 12c. Among other things, these changes offer a new architecture with pluggable databases that facilitate the management of a private and public cloud database and database consolidation.
  • Replication between SQL Server and Azure SQL
    Wherever Microsoft SQL Server runs on local networks, individual or all databases can be migrated to Azure SQL by transactional replication. Various opportunities unfold, including analytics in the Azure cloud and global access routes for mobile users and home and branch offices.
comments powered by Disqus