Oracle GoldenGate

Course Overview

Module 1–GoldenGate Overview

1: Why GoldenGate

2: Listing Supported OS and DB’s

3: GoldenGate Topologies

Module 2–Oracle GoldenGate Architecture

1: Oracle GoldenGate Architecture

2 : Overview: Extract, Replicat, and Pump 

3: Oracle GoldenGate Checkpoints

4:  Trail files, Parameter file

5: Commit Sequence Numbers (CSN)

6: Initial Load vs Change Synchronization

Module 3– Installing Oracle GoldenGate

1: Listing System Requirements

2: Performing Installation

3: Configuring Environment Variables

4:  Understanding Directories

5: Using GGSCI

Module 4– Configuring Database and Manager

1: Create and Configure Goldengate user

2: Execute Scripts

3: Supplemental Logging and train data

4: Manager and Global Parameter file

5: Understanding DEFGEN utility

Module 5– Configuring Extract, Pump and Trail files

1: Extract Overview and Parameter File

2: Accessing Logs on Oracle ASM

3: Adding Extract Group

4: Adding Trails

5: Extract Trails and  Files Overview

6:  Configuring and Using Data Pumps

Module 6–  Configuring Replicat and Unidirectional Replication

1:  Add Replicat

2:  Configure Replication

3:  Replication using data dump

4: Replication without using Data Pump

5: Using DEFGEN utility for 12.1 below

Module 7– Performing Initial Load

1: Oracle GoldenGate Initial Load   

2: Advantages and Restrictions

2: Configuring File Load Methods & Direct Load Methods

3: Handling Collisions with Initial Load

Module 8 – Integrated Capture and Integrated Delivery 

1:  Using Integrated Capture and benefits

2:  Steps to Upgrade to Integrated Capture

3: Integrated Delivery  and its benefits

4: Upgrade to Integrated Delivery

5: Dictionary View for Integrated Capture and Delivery

Module 9– Filtering and Data Selection

1:  COLUMN MAPPING

2: Data Selection

3: Filter Functions

4: Using Built-in “@” (at) Functions

5: Date and Range Functions

6: SQLEXEC

Module 10–DDL Replication

1: Requirement and Restrictions

2: DDL Replication: Scope

3: Configuring and Using String Substitution in DDL

Module 11–   Troubleshooting and Monitoring

1: Process Information, Reporting, and Statistics

2: Overview of Trail File, Logdump and Trail File Recovery

3: Using BATCHSQL

Module 12   -  Compression and Encryption

                       1:  Compression

                       2:  Trail file, Message and Password Encryption

3: CMDSEC

4: USERIDALIAS

Module 13: Event Marker System

Module 14– Bidirectional Replication

1: Reviewing Bidirectional Considerations

2: Detecting and Preventing Loops

3: Avoiding and Resolving Conflicts

4: Insert, Delete and Update Conflicts

5: Using CompareCols

6:  Trusted Source

Module 15: Installing Oracle GoldenGate Microservices Architecture (12.3)

1. Various Components of the Oracle GoldenGate Microservices Architecture
    
2. List the Operating System Pre-Requisites Needed for a Microservices Architecture installation
    
3. Perform an Oracle GoldenGate Microservice Architecture Installation and Verify its Successful Completion

Module 16: Overview of other Advance Topics

1: GoldenGate Cloud Service

2: Configuring GoldenGate for Container Database, RAC and DataGuard

3:  Reverse utility