(near)Zero Downtime Upgrades for Oracle 11g/12c — Introduction and Options

So, now that I have completed my series on  OpenLDAP for Oracle Net Service Name resolution, my next little adventure will be exploring the possibilities of zero downtime upgrades for Oracle 11gR2 and 12cR1.  This is an area that I don’t have a lot of experience with, so, I’ll be pretty much starting at ground zero.

Options

Oracle’s suggested solution is GoldenGate.  (Oracle also has a near-zero downtime upgrade ability using Logical Standby, but, my understanding is that there are some datatype limitations with that solution.)  So, my goal last month, in attending Oracle Openworld, was to learn about GoldenGate, and what it can do.  However, I also learned about another product, by a company called dbvisit, that claims to offer the same functionality in replication and (near)zero downtime upgrade abilities.

Continue reading