Oracle GoldenGate
11
g
Complete
Cookbook
Over 60 simple and easy-to-follow recipes to perform
various GoldenGate administration tasks such as installing,
conguring, and maintaining GoldenGate replication
Ankur Gupta
BIRMINGHAM - MUMBAI
Oracle GoldenGate 11
g
Complete Cookbook
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: September 2013
Production Reference: 2200913
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-84968-614-3
www.packtpub.com
Cover Image by Karl Moore (karl@karlmoore.co.uk)
Credits
Author
Ankur Gupta
Reviewers
Judy (Shuxuan) Nie
Jos van den Oord
Gavin Soorma
Michael Verzijl
Acquisition Editor
Antony Lowe
Lead Technical Editor
Ankita Shashi
Technical Editors
Ruchita Bhanshali
Vrinda A. Bhosale
Kapil Hemnani
Mrunmayee Patil
Project Coordinators
Anurag Banerjee
Abhijit Suvarna
Proofreader
Joanna McMahon
Indexer
Priya Subramani
Graphics
Ronak Dhruv
Production Coordinator
Melwyn D'sa
Cover Work
Melwyn D'sa
About the Author
Ankur Gupta is an Oracle Database Consultant based in London. He has a Master's degree
in Computer Science. He started his career as an Oracle developer and later on moved into
database administration. He has been working with Oracle Technologies for over 11 years in
India and the UK. Over the last 6 years, he has worked as an Oracle Consultant with some of
the top companies in the UK in the areas of investment banking, retail, telecom and media.
He is an Oracle Certied Exadata, GoldenGate Specialist, and OCP 11g DBA. His main areas
of interest are Oracle Exadata, GoldenGate, Dataguard, RAC, and Linux.
Outside the techie world, he is an avid cook, photographer, and enjoys travelling.
I would like to thank my wife for putting up with my long writing sessions
over late nights and weekends that I spent working on this book. Without
her love and support, this book would not have been possible.
My deepest gratitude to my parents for allowing me to realize my own
potential. I would also like to thank my mentors Dr. Prateek Bhatia and
Bikramjit Singh whose excellent teaching methods built my interest in the
eld of databases.