Instant Oracle GoldenGate
()
About this ebook
Oracle GoldenGate is a comprehensive package for low-impact, real-time data capture, distribution, and delivery of transactional data across heterogeneous systems for continuous availability, zero downtime migration, and disaster recovery. All in all, it is a precise tool for data replication, regardless of the platform that you use in today's environment.
Instant Oracle GoldenGate exemplifies the ease of use of this package through the use of real-world examples. This book gives a good overview and hands-on approach to the most commonly used implementations in an Oracle GoldenGate environment.
This How-to book will take you through a number of real-world examples quickly and effectively by eliminating much of the guess work for all users from novices to experienced users.
You will learn about the key components of the architecture and simple one-way replication for a number of database tables or an entire schema. You'll be covering key concepts and the implementation of high availability configurations such as Oracle RAC, encryption, and many different ways to transform and filter data to your target systems.
ApproachFilled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. Get the job done and learn as you go. A how-To book with practical recipes accompanied with rich screenshots for easy comprehension.This is a Packt Instant How-to guide, which provides concise and clear recipes for performing the core task of replication using Oracle GoldenGate.
Who this book is forThe book is aimed at DBAs from any of popular RDBMS systems such as Oracle, SQL Server, Teradata, Sybase, and so on. The level of detail provides quick applicability to beginners and a handy review for more advanced administrators.
Tony Bruzzese
Tony Bruzzese is a seasoned Oracle and Unix practitioner with more than 20 years of experience in architecting, troubleshooting, optimizing, and maximizing large scale clusters,highly complex systems using Oracle, UNIX, and third party technologies. He has worked in the Telecom Industry at Bell Canada,moved on to a consulting firm at CGI, and more recently in the BlackBerry Manufacturing arm of BlackBerry.Now a freelance IT consultant, he specializes in helping customers to resolve Oracle performance problems, designing disaster recovery for Oracle databases, implementing high availability solutions,and general database architecting. Tony's consulting endeavors are usually brief because he diagnoses and fixes problems quickly, generally in a few days.Tony is also Oracle 11g certified (OCP) and has maintained his certifications since Oracle 8.0.
Related to Instant Oracle GoldenGate
Related ebooks
Oracle GoldenGate 11g Implementer's guide Rating: 5 out of 5 stars5/5Mastering Oracle Scheduler in Oracle 11g Databases Rating: 0 out of 5 stars0 ratingsPractical Oracle Cloud Infrastructure: Infrastructure as a Service, Autonomous Database, Managed Kubernetes, and Serverless Rating: 0 out of 5 stars0 ratingsOracle 10g Data Warehousing Rating: 5 out of 5 stars5/5Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos Rating: 0 out of 5 stars0 ratingsOracle APEX Best Practices Rating: 0 out of 5 stars0 ratingsMonitoring Hadoop Rating: 0 out of 5 stars0 ratingsConcise Oracle Database For People Who Has No Time Rating: 0 out of 5 stars0 ratingsInstant PostgreSQL Backup and Restore How-to Rating: 0 out of 5 stars0 ratingsOracle Information Integration, Migration, and Consolidation Rating: 0 out of 5 stars0 ratingsOracle Quick Guides: Part 1 - Oracle Basics: Database and Tools Rating: 0 out of 5 stars0 ratingsPostgreSQL 11 Administration Cookbook: Over 175 recipes for database administrators to manage enterprise databases Rating: 0 out of 5 stars0 ratingsMastering PostgreSQL 9.6 Rating: 0 out of 5 stars0 ratingsOracle Quick Guides: Part 3 - Coding in Oracle: SQL and PL/SQL Rating: 0 out of 5 stars0 ratingsCouchbase Essentials Rating: 0 out of 5 stars0 ratingsTroubleshooting PostgreSQL Rating: 5 out of 5 stars5/5Implementing Azure Solutions Rating: 0 out of 5 stars0 ratingsOracle Warehouse Builder 11g: Getting Started Rating: 0 out of 5 stars0 ratingsModern Oracle Enterprise Architecture: Discover Oracle's Hidden Gems for Next Generation Database and Application Migrations Rating: 0 out of 5 stars0 ratingsPostgreSQL for Data Architects Rating: 0 out of 5 stars0 ratingsImplementing NetScaler VPX™ - Second Edition Rating: 0 out of 5 stars0 ratingsUnderstanding Azure Data Factory: Operationalizing Big Data and Advanced Analytics Solutions Rating: 0 out of 5 stars0 ratingsLearning ELK Stack Rating: 0 out of 5 stars0 ratingsExploring Hadoop Ecosystem (Volume 2): Stream Processing Rating: 0 out of 5 stars0 ratingsLearning Couchbase Rating: 0 out of 5 stars0 ratingsOracle Database 12c Release 2 New Features Rating: 0 out of 5 stars0 ratingsOracle 11g R1/R2 Real Application Clusters Essentials Rating: 5 out of 5 stars5/5Oracle GoldenGate 12c Implementer's Guide Rating: 0 out of 5 stars0 ratingsOracle 11g Streams Implementer's Guide Rating: 0 out of 5 stars0 ratingsOracle Goldengate 11g Complete Cookbook Rating: 5 out of 5 stars5/5
Enterprise Applications For You
Bitcoin For Dummies Rating: 4 out of 5 stars4/5The Ridiculously Simple Guide to Google Docs: A Practical Guide to Cloud-Based Word Processing Rating: 0 out of 5 stars0 ratingsQuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsCreating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Scrivener For Dummies Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Excel 2019 For Dummies Rating: 3 out of 5 stars3/5Systems Thinking: Managing Chaos and Complexity: A Platform for Designing Business Architecture Rating: 4 out of 5 stars4/550 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5ChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 0 out of 5 stars0 ratingsThe New Email Revolution: Save Time, Make Money, and Write Emails People Actually Want to Read! Rating: 5 out of 5 stars5/5QuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsExcel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5Data Governance: How to Design, Deploy and Sustain an Effective Data Governance Program Rating: 4 out of 5 stars4/5QuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsMrExcel XL: The 40 Greatest Excel Tips of All Time Rating: 4 out of 5 stars4/5Enterprise AI For Dummies Rating: 3 out of 5 stars3/5Experts' Guide to OneNote Rating: 5 out of 5 stars5/5Mastering QuickBooks 2020: The ultimate guide to bookkeeping and QuickBooks Online Rating: 0 out of 5 stars0 ratingsMicrosoft Power Platform A Deep Dive: Dig into Power Apps, Power Automate, Power BI, and Power Virtual Agents (English Edition) Rating: 0 out of 5 stars0 ratingsQuickBooks 2021 For Dummies Rating: 0 out of 5 stars0 ratingsExcel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Excel 2016 For Dummies Rating: 4 out of 5 stars4/5Managing Humans: Biting and Humorous Tales of a Software Engineering Manager Rating: 4 out of 5 stars4/5101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5
Reviews for Instant Oracle GoldenGate
0 ratings0 reviews
Book preview
Instant Oracle GoldenGate - Tony Bruzzese
Table of Contents
Instant Oracle GoldenGate
Credits
About the Author
About the Reviewer
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Errata
Piracy
Questions
1. Instant Oracle GoldenGate
Implementing design considerations (Simple)
How to do it…
How it works...
Installing Oracle GoldenGate (Simple)
Getting ready
How to do it...
How it works...
Creating one-way replication (Simple)
Getting ready
How to do it...
How it works...
Creating bidirectional replication (Simple)
Getting ready
How to do it...
How it works...
Creating heterogeneous replication (Simple)
Getting ready
How to do it...
How it works...
Configuring Oracle GoldenGate for High Availability (HA) (Simple)
How to do it…
How it works…
Configuring advanced settings (Simple)
How to do it…
How it works…
Performing encryption in OGG (Simple)
How to do it…
How it works…
Managing Oracle GoldenGate (Simple)
How to do it…
How it works...
Performance tuning (Simple)
How to do it…
How it works…
Instant Oracle GoldenGate
Instant Oracle GoldenGate
Copyright © 2013 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: July 2013
Production Reference: 1160713
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-78217-024-2
www.packtpub.com
Credits
Author
Tony Bruzzese
Reviewer
Satishbabu Gunukula
Acquisition Editor
Kevin Colaco
Commissioning Editor
Yogesh Dalvi
Technical Editor
Sonali S. Vernekar
Project Coordinator
Sherin Padayatty
Proofreader
Stephen Copestake
Production Coordinator
Conidon Miranda
Cover Work
Conidon Miranda
About the Author
Tony Bruzzese is a seasoned Oracle and Unix practitioner with more than 20 years of experience in architecting, troubleshooting, optimizing, and maximizing large scale clusters, highly complex systems using Oracle, UNIX, and third party technologies. He has worked in the Telecom Industry at Bell Canada, moved on to a consulting firm at CGI, and more recently in the BlackBerry Manufacturing arm of BlackBerry. Now a freelance IT consultant, he specializes in helping customers to resolve Oracle performance problems, designing disaster recovery for Oracle databases, implementing high availability solutions, and general database architecting. Tony's consulting endeavors are usually brief because he diagnoses and fixes problems quickly, generally in a few days. Tony is also Oracle 11g certified (OCP) and has maintained his certifications since Oracle 8.0.
About the Reviewer
Satishbabu Gunukula has over 13 years of experience in the IT Industry. He has extensive experience in Oracle and SQLServer Database Technologies and specializes in high availability solutions such as Oracle RAC, Data Guard, Grid Control, and SQLServer Cluster. He has done Master's degree in Computer Applications.
Satishbabu Gunukula has been honored with the prestigious Oracle ACE Award. He has experience on and wide range of products such as Essbase, Hyperion, Agile, SAP Basis, MySQL, Linux, Windows, and Business Apps administration, and he has implemented many business critical systems for fortune 500, 1000 companies.
He reviews articles for SELECT Journal – the publication of IOUG-and also books for Packt Publishing. He is an active member in IOUG, Oracle RAC SIG, UKOUG, and OOW. He has written articles for major publications and websites and spoken at Oracle-related events. He shares knowledge on his websites http://www.oracleracexpert.com and http://www.sqlserver-expert.com.
www.PacktPub.com
Support files, eBooks, discount offers, and more
You might want to visit www.PacktPub.com for support files and downloads related to your book.
Did you know that