1st Edition

Working with Oracle GoldenGate 12c From Implementation to Troubleshooting

By Gavin Powell Copyright 2019
    200 Pages 30 B/W Illustrations
    by Auerbach Publications

    200 Pages 30 B/W Illustrations
    by Auerbach Publications

    200 Pages 30 B/W Illustrations
    by Auerbach Publications

    This book teaches the basics of Oracle GoldenGate, which is a product that is used to simplify the process of Oracle Database Replication. GoldenGate can be used for reporting, failover, high availability, live reporting, data warehousing, and BigData ETL process, as well as connecting to multiple other data sources outside of Oracle Database such as SQL Server, MySQL, Teradata, PostgreSQL, and many others. The purpose of GoldenGate and its popularity is its ability to make the highly complex architecture of database replication into a much more simplistic task. This book teaches the reader how to use Oracle GoldenGate, from installation to troubleshooting.



    Dedication



    Contents



    List of Figures



    List of Tables



    About the Author



    Introduction





    Chapter 1 GoldenGate Architecture



    Chapter 2 Installing GoldenGate



    Chapter 3 Configuring GoldenGate



    Chapter 4 Basic GoldenGate Administration



    Chapter 5 Loading Data into GoldenGate



    Chapter 6 Applying Replication



    Chapter 7 Wrapping It Up





    Glossary



    Index

    Biography

    Gavin Powell is an experienced professional database subject matter expert after spending thirty years as an IT professional, doing interesting things like database architecture, DBA work, performance tuning, trouble shooting and even development. Around the end of the DOT Com era, Gavin added technical writing to his many activities and now has over twenty titles published in print and online. Gavin has worked in leadership, operational and functional development roles, including complex OLTP and warehouse/Big data installations. Gavin has worked extensively with multiple relational, Big data and object databases, including Oracle, Hadoop, MySQL, PostgreSQL, Netezza, and quite a few more. Gavin has a BSc in Computer Science, has almost completed a leadership MBA, is a semiprofessional songwriter, a Berklee trained vocalist and performer; but is also an average downhill skier and is only vaguely useful as a speed-skater.