Oracle GoldenGate 11g Implementer's guide

Oracle GoldenGate 11g Implementer's guide

By : John P Jeffries, John P Jeffries

Buy this Book

Oracle GoldenGate 11g Implementer's guide

By: John P Jeffries, John P Jeffries

Buy this Book

Overview of this book

Data replication is an important part of any database system that is growing due to today's demand for real-time reporting and regulatory requirements. GoldenGate has recently become Oracle's strategic real-time data replication solution. Until now, very little has been written about how to implement GoldenGate in a production enterprise environment where performance, scalability, and data integrity are paramount. Your days of dismay over the lack of documentation over Oracle GoldenGate are over. Welcome to Oracle GoldenGate 11g Implementer's guide – a comprehensive practical book, which will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. Based on the author's own experience, this long awaited GoldenGate administration book has all that is required to install, design, configure, and tune data replication solutions suited to every environment. Be the first to master GoldenGate's power and flexibility by reading this unique hands-on implementation companion. Systems need to send data from one system to another in a timely manner to satisfy the ever-increasing need for speed. Regardless of whether you are a novice or an expert – or someone in between – this book will guide you through all the steps necessary to build a high-performance GoldenGate solution on Oracle11gR1. Expert users can dive into key topic areas such as performance tuning or troubleshooting, while novice users can step through the early installation and configuration chapters, later progressing to the advanced chapters. This book is more than an implementation guide. It offers detailed real-life examples, encouraging additional thought and discussion by going beyond the manual. With Oracle GoldenGate 11g Implementer's guide in hand, you'll be designing, installing, and configuring high-performance solutions using GoldenGate in less time than you can say "replicate"

Oracle GoldenGate 11 Implementer's guide

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Getting Started

What is GoldenGate?

Oracle GoldenGate evolution

Oracle GoldenGate solutions

Oracle GoldenGate technology overview

Oracle GoldenGate architecture

Supported platforms and databases

Oracle Goldengate topology

Design considerations

What to Replicate?

Summary

Installing and Preparing GoldenGate

Prerequisites

Software installation

Preparing the environment

Creating the initial configuration

Uninstalling GoldenGate from Linux/UNIX

Summary

Design Considerations

Replication methods

Networking

Non-functional requirements (NFRs)

Hardware considerations

Changed data management

Summary

Configuring Oracle GoldenGate

GoldenGate parameters

Configuring the Initial Load

Performing the Initial Load

Configuring Change Data Capture

Configuring Change Delivery

Testing Change Data Capture and Delivery

Stopping GoldenGate processes

More about trail files

Configuring the Manager process

Summary

Configuration Options

Bi-directional configuration options

Heterogeneous environments

DDL replication

Summary

Configuring GoldenGate for HA

GoldenGate on RAC

GoldenGate on Exadata

Failover

Summary

Advanced Configuration

Mapping your data

Data selection and filtering

Data transformation

DDL support

The SQLEXEC parameter

Using and defining macros

User tokens

User Exits

Using logic in data replication

Licensing

Summary

Managing Oracle GoldenGate

Command level security

Trail file management

Managing process startup

Managing TCP/IP errors

Reporting and statistics

Summary

Performance Tuning

Before tuning GoldenGate

Balancing the load across parallel process groups

Splitting large tables into row ranges across process groups

Configuring multiple parallel process groups

New releases

Tuning the network

Summary

Troubleshooting GoldenGate

Troubleshooting tips

Exception handling

Handling Oracle Sequences

Using LOGDUMP

Upgrading GoldenGate

Summary

GGSCI Commands

GoldenGate Installed Components

The Future of Oracle GoldenGate

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Appendix B. GoldenGate Installed Components

GoldenGate is architecturally a simple product with relatively few installed components. This is one of the main reasons for its performance and flexibility. Let's take a look at the software bundle that is installed on both the source and target database servers.

The following table of files and directories make up the "GoldenGate Home":

Sub-directories	Description
dirchk	Stores GoldenGate checkpoint files
dirdat	Stores GoldenGate trail files
dirdef	Stores GoldenGate definition mapping files
dirout	Stores GoldenGate output files
dirpcs	Stores GoldenGate process files
dirprm	Stores GoldenGate process parameter files
dirrpt	Stores GoldenGate process report files
dirsql	Stores GoldenGate user defined SQL files
dirtmp	Stores GoldenGate temporary files
dirver	Stores GoldenGate Veridata files
UserExitExamples	Stores GoldenGate User Exit example files

SQL Filename	Description
chkpt_ora_create.sql	Creates the Goldengate checkpoint table
ddl_cleartrace.sql	Clears GoldenGate DDL Replication Trace file
ddl_ddl2file.sql	Saves DDL from marker table to a file
ddl_disable.sql	Disables GoldenGate DDL Replication trigger
ddl_enable.sql	Enables GoldenGate DDL Replication trigger
ddl_nopurgeRecyclebin.sql	Allows the use of the Oracle database recyclebin functionality
ddl_ora10.sql	Support script for version specific Oracle10g logic
ddl_ora10upCommon.sql	Support script for version specific Oracle10g and 11g common logic
ddl_ora11.sql	Support script for version specific Oracle11g logic
ddl_ora9.sql	Support script for version specific Oracle9i logic
ddl_pin.sql	Pins GoldenGate DDL Replication packages in memory (Shared Pool)
ddl_purgeRecyclebin.sql	Purges the Oracle database recyclebin
ddl_remove.sql	Removes GoldenGate DDL Replication trigger and package
ddl_session1.sql	Support script for proceeding with DDL installation in case of other sessions active
ddl_session.sql	Support script for proceeding with DDL installation in case of other sessions active
ddl_setup.sql	Installation script for GoldenGate DDL Replication trigger and package
ddl_status.sql	Obtain status of GoldenGate DDL Replication Installation
ddl_staymetadata_off.sql	Turns OFF STAYMETADATA
ddl_staymetadata_on.sql	Turn ON STAYMETADATA
ddl_tracelevel.sql	Sets Tracing Level for GoldenGate DDL Replication trigger
ddl_trace_off.sql	Turns OFF Trace DDL execution
ddl_trace_on.sql	Turns ON Trace DDL execution for use with TKPROF
demo_more_ora_create.sql	Demonstration SQL
demo_more_ora_insert.sql	Demonstration SQL
demo_ora_create.sql	Demonstration SQL
demo_ora_insert.sql	Demonstration SQL
demo_ora_lob_create.sql	Demonstration SQL
demo_ora_misc.sql	Demonstration SQL
demo_ora_pk_befores_create.sql	Demonstration SQL
demo_ora_pk_befores_insert.sql	Demonstration SQL
demo_ora_pk_befores_updates.sql	Demonstration SQL
marker_remove.sql	Removal script for GoldenGate Marker table
marker_setup.sql	Installation script for GoldenGate Marker table
marker_status.sql	Obtains status GoldenGate Marker Installation
params.sql	Customizable parameters for GoldenGate
role_setup.sql	Installation script for GoldenGate Security Role

TPL Filename	Description
bcpfmt.tpl	Template file used specify the BCP version
db2cntl.tpl	DB2 Control File Template
ddl_access.tpl	Template file used by DEFGEN to determine how Tandem types are defined in MS Access
ddl_db2_os390.tpl	Template file used by DEFGEN to determine how Tandem types are defined in MS Access
ddl_db2.tpl	Template file used by DEFGEN to determine how Tandem types are defined in DB2
ddl_informix.tpl	Template file used by DEFGEN to determine how Tandem types are defined in Informix
ddl_mss.tpl	Template file used by DEFGEN to determine how Tandem types are defined in MS SQL Server
ddl_mysql.tpl	Template file used by DEFGEN to determine how Tandem types are defined in MySQL
ddl_nssql.tpl	Template file used by DEFGEN to determine how to convert Tandem Enscribe DDL to NS SQL DDL
ddl_oracle.tpl	Template file used by DEFGEN to determine how Tandem types are defined in Oracle
ddl_sqlmx.tpl	Template file used by DEFGEN to determine how to convert Tandem Enscribe DDL to NS SQL/MX DDL
ddl_sybase.tpl	Template file used by DEFGEN to determine how Tandem types are defined in Sybase
ddl_tandem.tpl	Template file used by DEFGEN to determine how to convert Tandem Enscribe DDL to NS SQL DDL
sqlldr.tpl	SQLLDR Control File Template
bcrypt.txt	Copyright/License agreement file
freeBSD.txt	Copyright file/License agreement
help.txt	GoldenGate help file for GGSCI
libxml2.txt	Copyright/License agreement file
notices.txt	Notices
zlib.txt	Copyright/License agreement file

Executable Filename	Description
cobgen	Source definition generator utility for Cobol
convchk	Oracle GoldenGate checkpoint conversion utility for newer versions
ddlcob	DDL generator for Cobol
ddlgen	DDL generator utility
defgen	Source table definitions generator utility
emsclnt	Program to send messages to an Event Management System
extract	GoldenGate Extract process program
ggsci	GoldenGate Command Line Interpreter
keygen	Encryption key generator utility
logdump	Log Dump utility
mgr	GoldenGate Manager process program
replicat	GoldenGate Replicat process program
reverse	A utility that reverses the order of transactional operations
server	GoldenGate Collector process program

User Created Filename	Description
ENCKEYS	Stores encryption keys generated by the `keygen` utility
GLOBALS	Stores global parameters for the GoldenGate instance

Oracle GoldenGate 11g Implementer's guide

By : John P Jeffries, John P Jeffries

Oracle GoldenGate 11g Implementer's guide

By: John P Jeffries, John P Jeffries

Overview of this book

Related Content you might be interested in

Current Title:

Oracle GoldenGate 11g Implementer's guide

Appendix B. GoldenGate Installed Components