Oracle GoldenGate 11g Complete Cookbook

Name: Oracle GoldenGate 11g Complete Cookbook | Dig deep into administering Oracle Goldengate 11g using this comprehensive cookbook. From the very basics of installation to advanced features like migration, you'll learn the practical way through code scripts and examples.
Brand: Packt Publishing
Availability: OnlineOnly

Dig deep into administering Oracle Goldengate 11g using this comprehensive cookbook. From the very basics of installation to advanced features like migration, you'll learn the practical way through code scripts and examples.

Ankur Gupta(Autor*in)

Packt Publishing

1. Auflage

Erschienen am 26. September 2013

363 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-1-84968-615-0 (ISBN)

ab 39,99 €

Als Download verfügbar

Merkliste: siehe Preise

Beschreibung

Alle Preise

Weitere Details

Weitere Ausgaben

Inhalt

Intro
Oracle GoldenGate 11g Complete Cookbook
Table of Contents
Oracle GoldenGate 11g Complete Cookbook
Credits
About the Author
About the Reviewers
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
Downloading the example code
Errata
Piracy
Questions
1. Installation and Initial Setup
Introduction
Installing Oracle GoldenGate in a x86_64 Linux-based environment
Getting ready
How to do it...
How it works...
Installing Oracle GoldenGate in a Windows environment
Getting ready
How to do it...
How it works...
Enabling supplemental logging in the source database
Getting ready
How to do it.
How it works.
There's more.
See also
Supported datatypes in Oracle GoldenGate
Getting ready
How to do it.
How it works.
There's more.
Preparing the source database for GoldenGate setup
Getting ready
How to do it.
How it works.
There's more.
The Classic Capture mode
The Integrated Capture mode
See also
Preparing the target database for GoldenGate setup
Getting ready
How to do it.
How it works.
There's more.
Setting up a Manager process
Getting ready
How to do it.
How it works.
There's more.
Setting up a Classic Capture Extract process
Getting ready
How to do it.
How it works.
There's more.
See also
Setting up an Integrated Capture Extract process
Getting ready
How to do it.
How it works.
There's more.
See also
Setting up a Datapump process
Getting ready
How to do it.
How it works.
There's more.
See also
Setting up a Replicat process
Getting ready
How to do it.
How it works.
There's more.
See also
2. Setting up GoldenGate Replication
Introduction
Setting up a simple GoldenGate replication configuration between two single node databases
Getting ready
How to do it...
How it works...
There's more...
See also
Setting up a GoldenGate replication with multiple process groups
Getting ready
How to do it...
How it works...
There's more...
See also
Configuring an Extract process to read from an Oracle ASM instance
How to do it.
How it works.
Setting up a GoldenGate replication between Oracle RAC databases
Getting ready
How to do it.
How it works.
See also
Determining the size of trail file areas
How to do it.
How it works...
Verifying the data transfer on the target system
Getting ready
How to do it...
How it works.
There's more...
Generating encryption keys
How to do it.
How it works.
Encrypting database user passwords
Getting ready
How to do it.
How it works.
Encrypting the trail files
Getting ready
How to do it.
How it works.
Setting up a GoldenGate replication between tables with different structures using defgen
Getting ready
How to do it.
How it works.
See also
3. DDL Replication and Initial Load
Introduction
Performing an initial setup required for GoldenGate DDL replication
Getting ready
How to do it...
How it works...
There's more...
See also
Setting up a GoldenGate DDL replication and verifying the changes
Getting ready
How to do it...
How it works...
There's more...
Extra privileges that are required for the GoldenGate Admin user
Filtering and mapping
Additional DDLOPTIONS
Performing an initial load using GoldenGate
Getting ready
How to do it...
How it works...
There's more...
Extract file to the Replicat method
Trail to the Replicat method
File to the database utility method
GoldenGate direct load method
Direct bulk load to SQL loader method
See also
Performing an initial load using an extract file to the GoldenGate's replicat method
Getting ready
How to do it...
How it works...
There's more...
Loading data using trail files to the Replicat process method
Getting ready
How to do it...
How it works...
Loading data with files to the database utility method
Getting ready
How to do it...
How it works...
There's more...
See also
Loading data with the GoldenGate direct load method
Getting ready
How to do it...
How it works...
There's more...
Loading data with bulk load to the SQL loader method
Getting ready
How to do it...
How it works...
4. Mapping and Manipulating Data
Introduction
Setting up a GoldenGate replication with mapping between different columns
Getting ready
How to do it...
How it works...
There's more...
Source environment mapping
Defining global mappings
Defining mappings using prefix/suffix
See also
Adding custom fields for a replicated record using tokens
Getting ready
How to do it...
How it works...
There's more...
See also
Adding custom fields to a replicated record using SQLEXEC
Getting ready
How to do it...
How it works...
There's more...
Running a stored procedure with SQLEXEC
Running a global SQL statement/procedure
Filtering the records using the FILTER and WHERE clause
Getting ready
How to do it...
How it works...
There's more...
Using the Where clause
Filtering in the source environment
Filtering the records into parallel groups
See also
Mapping the changes to a target table and storing the transaction history in a history table
Getting ready
How to do it...
How it works...
See also
Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated
Getting ready
How to do it...
How it works...
There's more...
See also
Creating an exception handler to record the erroneous transactions in a GoldenGate configuration
Getting ready
How to do it...
How it works...
There's more...
MAPEXCEPTION method
Handle exceptions with a MACRO
See also
5. Oracle GoldenGate High Availability
Introduction
Choosing a GoldenGate high availability option
Getting ready
How to do it...
How it works...
There's more.
Oracle Cluster File System (OCFS2)
Database File System (DBFS)
ASM Cluster File System (ACFS)
See also
Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS
Getting ready
How to do it...
How it works...
Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2
Getting ready
How to do it...
How it works...
Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS
Getting ready
How to do it...
How it works...
See also
Manually switching over Oracle Clusterware-based configuration to the other node
Getting ready
How to do it...
How it works...
Automatic failover of a DBFS-based configuration
Getting ready
How to do it...
How it works...
There's more...
Manual relocation of a DBFS-based GoldenGate configuration
Creating a set of parallel load balanced, highly available GoldenGate configurations using Oracle Clusterware and DBFS
Getting ready
How to do it...
How it works...
See also
6. Monitoring, Tuning, and Troubleshooting GoldenGate
Introduction
Steps to configure a BATCHSQL mode
How to do it...
How it works...
There's more.
See also
Splitting the replication load into multiple process groups for optimal performance
How to do it...
How it works...
There's more.
The RANGE function
See also
Optimizing the network settings for a GoldenGate configuration
Getting ready
How to do it...
How it works...
Performing a healthcheck of a live GoldenGate configuration
How to do it...
How it works...
See also
Script to perform a regular scheduled healthcheck of a live GoldenGate configuration
Getting ready
How to do it...
How it works...
See also
Steps to measure throughput of a GoldenGate configuration
Getting ready
How to do it...
How it works...
There's more...
Stats command options
See also
Steps to re-instantiate a failed GoldenGate configuration
Getting ready
How to do it...
How it works...
See also
Steps to implement a Heartbeat mechanism for the GoldenGate replication
Getting ready
How to do it...
How it works...
There's more...
See also
7. Advanced Administration Tasks - I
Introduction
Upgrading Oracle GoldenGate binaries
Getting ready
How to do it...
How it works...
Table structure changes in GoldenGate environments with similar table definitions
Getting ready
How to do it.
How it works...
There's more...
Specific tables defined in GoldenGate parameter files
Individual table permissions granted to the GoldenGate Admin user
Supplemental logging for modified tables without any keys
Supplemental log groups with all columns for modified tables
See also
Table structure changes in GoldenGate environments with different table definitions
Getting ready
How to do it...
How it works...
There's more.
Individual table permissions granted to the GoldenGate Admin user
Supplemental logging for modified tables without any keys
Supplemental log groups with all columns for modified tables
Resolving GoldenGate errors using the logdump utility
Getting ready
How to do it...
How it works...
There's more...
Count
Scan for timestamp
Filter on SCN
See also
Undoing the applied changes using the reverse utility
Getting ready
How to do it...
How it works...
There's more...
Creating an Integrated Capture with a downstream database for compressed tables
Getting ready
How to do it...
How it works...
8. Advanced Administration Tasks - Part II
Introduction
Creating a GoldenGate configuration with a consistent state behind the target database
Getting ready
How to do it...
How it works...
There's more.
Why use deferred apply
DEFERAPPLYINTERVAL UNITS
See also
Replicating data from an active standby database in Archivelog mode only
Getting ready
How to do it.
How it works...
Migrating from an Oracle Streams environment to Oracle GoldenGate
Getting ready
How to do it...
How it works...
GoldenGate Administration role separation from the DBA team
Getting ready
How to do it.
How it works...
Cross RDBMS replication using GoldenGate
Getting ready
How to do it...
How it works...
Creating a multimaster GoldenGate replication configuration
Getting ready
How to do it...
How it works...
There's more.
Data collision avoidance
Data collision resolution
Timestamp-based
Defined trusted source
9. GoldenGate Veridata, Director, and Monitor
Introduction
Setting up the Oracle GoldenGate Monitor server
Getting ready
How to do it...
How it works...
There's more.
Installing the GoldenGate Monitor server using HTTPS
See also
Setting up Oracle GoldenGate Monitor Agents
Getting ready
How to do it.
How it works...
There's more.
Installing Oracle GoldenGate Director
Getting ready
How to do it...
How it works...
See also
Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances
Getting ready
How to do it...
How it works...
Steps to set up the GoldenGate monitoring using OEM 12c
Getting ready
How to do it...
How it works...
There's more...
Steps to install Oracle GoldenGate Veridata
Getting ready
How to do it...
How it works...
See also
Steps to compare data between the source and target environment using Oracle GoldenGate Veridata
Getting ready
How to do it...
How it works...
Index

Systemvoraussetzungen

Dateiformat: ePUB
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat ePUB ist sehr gut für Romane und Sachbücher geeignet – also für „fließenden” Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Dateiformat: PDF
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Als PDF speichern Als Link merken