Oracle GoldenGate - migrate on prem & in the cloud

Oracle GoldenGate in the near future will be the most significant tool option for "into the cloud" migration strategy for many Oracle technology customers. Currently GoldenGate PaaS offering  is not publicly available, but tomorrow in the evening it will be changed for sure! As a consequence I believe it is necessary to understand some foundation & basics of Oracle GoldenGate technology for future smooth implementations & migrations into Oracle Public Cloud. 

But let's talk for a moment about history:-) GoldenGate Software Inc was founded in 1995 in San Francisco, what explain the name after the famous Golden Gate Bridge. Company founders, Todd Davidson and Eric Fish primary designed the solution for the fault tolerant Tandem computers with secure & fast data replication functionality. Initially GoldenGate was used in banks as a foundation for ATM network transfers (cash machines to mainframes traffic). Data integrity and no data loss lays in the heart of GoldenGate technology and this has not been changed since the beginning. Oracle has acquired GoldenGate Software in September 2009. At that particular moment product named Oracle GoldenGate could provide such replication features as:

• High Availability with live-standby and active-active solutions
• Zero-Downtime Upgrade and Migrations
• Transactional Data Integration feeding messaging systems and SOA
• Live Reporting by feeding reporting databases
• Operational Business Intelligence (BI)

For our "into the cloud" scenario we will utilize the second position from the list. I mean Zero-Downtime Upgrade and Migration. Now just few words about Oracle GoldenGate architecture. Below you can find a picture which should explain lot of details:

In the first step Extract process monitors the changes (Change Data Capture) within source database redologs. All changes are written to trail files. In the subsequent step Pump process delivers those changes online to Server Collector process on the other side of replication (via TCP network). Service Collector use to write these changes again in trail files. And finally Replicat process delivers the changes and apply it on target database. All of the work on both sides are under control of Manager (MGR) processes.

Within Oracle Public Cloud, with the usage of wizards it will be simplified.  I hope all of details we will be defined tomorrow during Webcast. The link to Webcast you can see here. 

BTW: Some small parts of wizard mystery you can see in this YT movie. :-)

Stay tuned for more :-)

Luke.

PS. For people hungry for knowledge I can recommend the book Oracle GoldenGate 12c Implementer's Guide by John P Jeffries.