22,79 €
Mehr erfahren.
- Herausgeber: Packt Publishing
- Kategorie: Fachliteratur
- Sprache: Englisch
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.
Das E-Book können Sie in Legimi-Apps oder einer beliebigen App lesen, die das folgende Format unterstützen:
Seitenzahl: 71
Veröffentlichungsjahr: 2013
Ähnliche
Table of Contents
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 Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at <[email protected]> for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.
http://PacktLib.PacktPub.com
Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books.
Why Subscribe?
Free Access for Packt account holders
If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access.
Instant Updates on New Packt Books
Get notified! Find out when new books are published by following @PacktEnterprise on Twitter, or the Packt Enterprise Facebook page.
Preface
Data duplication is ubiquitous in enterprises today. Almost every application in an organization needs information from some other part of the organization. Oracle GoldenGate has become such a predominant tool in the industry today thus allowing organizations to share data between disparate environments. Its adoption rate is increasing very quickly because of the ease of use, economy of speed, and small footprint required to implement it.
What this book covers
Implementing design considerations (Simple) presents a number of design decisions to consider, such as your platform of choice, physical memory requirements, storage, and network considerations such as high and low latency networks.
Installing Oracle GoldenGate (Simple) guides you through the step-by-step process of downloading the software from Oracle's website, unpacking the software, and installing it on your server host.
Creating one-way replication (Simple) will explore how to implement a downstream replication by creating Extract and Pump processes on the source system for capturing and transporting source data to your target system. A Replicat process is created on your target server which applies changes received from the source system.
Creating bidirectional replication (Simple) also sometimes referred to as master to master replication, performs the same steps as in the recipe, Creating one-way replication (Simple) and in the opposite direction.
Creating heterogeneous replication (Simple) lets you start discovering the ease of implementing replication between disparate RDBMS environments, such as Oracle to SQL Server. However, there are a number of other different RDBMS combinations as well.
Configuring Oracle GoldenGate for High Availability (HA) (Simple) although might sound more complex than it really is, it is quite simple and differs slightly from a single-instance installation.
Configuring advanced settings (Simple) discovers the power and flexibility of Oracle GoldenGate to perform tasks such as data mapping, filtering, and data transformation.
Performing encryption in OGG (Simple) discusses encrypting the Oracle GoldenGate user ID and trail files at rest and in flight using Blowfish and AES algorithms for 128, 192, and 256 bits.
Managing Oracle GoldenGate (Simple) allows you to explore some of the more interactive commands to view, monitor, and troubleshoot Oracle GoldenGate processes during a running instance.
Performance tuning (Simple) explores plausible solutions to increase efficiencies and data throughput in your environment, even under high latency networks, as one of the most common concerns regarding replication is how to get data faster to the target system.
What you need for this book
In order to use Oracle GoldenGate, you need an existing Oracle database in place, or any of the supported databases for Oracle GoldenGate such as SQL Server, Teradata, Sybase, and so on. Then, and only then, you can download and use the Oracle GoldenGate software. For a complete list of supported database, you can reference Oracle® GoldenGate Windows and Unix Administrator's Guide 11g Release 2 Patch Set 1 (11.2.1.0.1) E29397-01.
