Course Duration in Hours
80
80
Chapter 1 Introduction to Oracle GoldenGate
Oracle GoldenGate supported processing methods and databases
Overview of the Oracle GoldenGate architecture
Overview of process types
Overview of groups
Overview of the Commit Sequence Number (CSN)
Chapter 2 Installing Oracle GoldenGate
Downloading Oracle GoldenGate
Setting ORACLE_HOME and ORACLE_SID
Specifying Oracle variables on UNIX and Linux systems
Specifying Oracle variables on Windows systems
Setting library paths for dynamic builds on UNIX
Preparing to install Oracle GoldenGate within a cluster
Installing as the Oracle user
Supported Oracle cluster storage
Deciding where to install Oracle GoldenGate binaries and files in the cluster
Installing Oracle GoldenGate on Linux and UNIX
Installing Oracle GoldenGate on Windows
Installing Oracle GoldenGate into a Windows Cluster
Installing the Oracle GoldenGate files
Specifying a custom Manager name
Installing Manager as a Windows service
Integrating Oracle GoldenGate into a cluster
General requirements in a cluster
Adding Oracle GoldenGate as a Windows cluster resource
Installing support for Oracle sequences
Chapter3 Configuring Manager and Network Communications
Overview of the Manager process
Assigning Manager a port for local communication
Maintaining ports for remote connections through firewalls
Choosing an internet protocol
Recommended Manager parameters
Creating the Manager parameter file
Starting Manager
Stopping Manager
Chapter4 Getting started with the Oracle GoldenGate process interfaces
Using the GGSCI commandline interface
Using UNIX batch and shell scripts
Using Oracle GoldenGate parameter files
Supported characters in object names
Specifying object names in Oracle GoldenGate input
Chapter5 Using Oracle GoldenGate for live reporting
Overview of the reporting configuration
Considerations when choosing a reporting configuration
Creating a standard reporting configuration
Creating a reporting configuration with a data pump on the source system
Creating a reporting configuration with a data pump on an intermediary system
Creating a cascading reporting configuration
Chapter6 Using Oracle GoldenGate for realtime data distribution
Overview of the datadistribution configuration
Considerations for a datadistribution configuration
Creating a data distribution configuration
Chapter7 Configuring Oracle GoldenGate for realtime data warehousing
Overview of the datawarehousing configuration
Considerations for a data warehousing configuration
Creating a data warehousing configuration
Chapter8 Configuring Oracle GoldenGate to maintain a live standby database
Overview of a live standby configuration
Considerations for a live standby configuration
Creating a live standby configuration
Moving user activity in a planned switchover
Moving user activity in an unplanned failover
Chapter9 Configuring Oracle GoldenGate for activeactive high availability
Overview of an activeactive configuration
Considerations for an activeactive configuration
Preventing data looping
Creating an activeactive configuration
Managing conflicts
Handling conflicts with the Oracle GoldenGate CDR feature
Configuring Oracle GoldenGate CDR
CDR example : All conflict types with USEMAX, OVERWRITE, DISCARD
CDR example : UPDATEROWEXISTS with USEDELTA and USEMAX
CRD example : UPDATEROWEXISTS with USEDELTA, USEMAX, and IGNORE
Chapter10 Mapping and manipulating data
Limitations of support
Parameters that control mapping and data integration
Mapping between dissimilar databases
Deciding where data mapping and conversion will take place
Globalization considerations when mapping data
Mapping columns
Selecting rows
Retrieving before values
Selecting columns
Selecting and converting SQL operations
Using transaction history
Testing and transforming data
Using tokens
Chapter11 Handling Oracle GoldenGate processing errors
Overview of Oracle GoldenGate error handling
Handling Extract errors
Handling Replicat errors during DML operations
Handling Replicat errors during DDL operations
Handling TCP/IP errors
Maintaining updated error messages
Resolving Oracle GoldenGate errors
Chapter12 Associating replicated data with metadata
Configuring Oracle GoldenGate to assume identical metadata
Configuring Oracle GoldenGate to assume dissimilar metadata
Configuring Oracle GoldenGate to use a combination of similar and dissimilar definitions
Chapter13 Configuring online change synchronization
Overview of online change synchronization
Configuring change synchronization to satisfy a specific topology
Naming conventions for groups
Creating a checkpoint table
Creating an online Extract group
Creating a trail
Creating a parameter file for online extraction
Creating an online Replicat group
Creating a parameter file for online replication
Controlling online processes
Deleting a process group
Chapter14 Running an initial data load
Overview of initial data load methods
Using parallel processing in an initial load
Prerequisites for initial load
Loading data with a database utility
Loading data from file to Replicat
Loading data from file to database utility
Loading data with an Oracle GoldenGate direct load
Loading data with a direct bulk load to SQL*Loader
Loading data with Teradata load utilities
Chapter15 Customizing Oracle GoldenGate processing
Overview of custom processing
Executing commands, stored procedures, and queries with SQLEXEC
Using Oracle GoldenGate macros to simplify and automate work
Using user exits to extend Oracle GoldenGate capabilities
Using the Oracle GoldenGate event marker system to raise database events
Chapter16 Monitoring Oracle GoldenGate processing
Overview of the Oracle GoldenGate monitoring tools
Using the information commands in GGSCI
Monitoring an Extract recovery
Monitoring lag
Monitoring processing volume
Using the error log
Using the process report
Using the discard file
Using the system logs
Reconciling time differences
Sending event messages to a NonStop system
Getting more help with monitoring and tuning
Chapter17 Performing administrative operations
Overview of administrative operations
Performing application patches
Adding process groups
Initializing the transaction logs
Shutting down the system
Changing database attributes
Changing the size of trail files
Chapter18 Undoing data changes with the Reverse utility
Overview of the Reverse utility
Reverse utility restrictions
Configuring the Reverse utility
Creating process groups and trails for reverse processing
Running the Reverse utility
Undoing the changes made by the Reverse utility
Oracle DBA
AMK Technologies, BTM Ist Stage (Bangalore),Bangalore,IN