Oracle GoldenGate 12c Fundamentals
4.7 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
144 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle GoldenGate 12c Fundamentals to your Wishlist.

Add to Wishlist

Oracle GoldenGate 12c Fundamentals

Build and manage an Oracle 12c GoldenGate configuration
4.7 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
144 students enrolled
Created by Ahmed Baraka
Last updated 4/2017
English
Learn Fest Sale
Current price: $23 Original price: $95 Discount: 75% off
17 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 10.5 hours on-demand video
  • 21 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Install Oracle GoldenGate
  • Configure uidirectional and bidirectional replication
  • Implement classic and integrated Oracle GoldenGate processes
  • Perform data filtering and manipulation
  • Implement encryption in Oracle GoldenGate
  • Monitor Oracle GoldenGate using GGSCI and SQL
  • Use LogDump utility
  • Troubleshoot an Oracle GoldenGate configuration
  • Apply Oracle GoldenGate Patches
View Curriculum
Requirements
  • Familiarity with Oracle Database and basic SQL
  • Familiarity with Linux basics
Description

Learn how to build, manage, monitor, and troubleshoot an Oracle GoldenGate configuration.

Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them.

  • Set up a unidirectional and bidirectional replication
  • Perform data filtering and manipulation
  • Implementing DDL Replication
  • Implement integrated processes
  • Implementing Coordinated Replicat
  • Monitor and troubleshoot an Oracle GoldenGate configuration,
  • Implement the security options
  • Apply Oracle GoldenGate patches

Content and Overview 

Suitable for Oracle Database Administrators, through this course of 42 lectures and more than 10 hours of video-based sessions, you’ll learn all of the Oracle GoldenGate 12c fundamentals. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.

Starting with introducing Oracle GoldenGate, this course will take you all the away from installing the software on a Linux platform, building up a unidirectional and bidirectional configurations, managing an Oracle GoldenGate configuration, up to applying the patch sets.

This is an opportunity for the students to gain practical  experience from the author who has implemented a number of Oracle GoldenGate projects in real life.

Upon completing this course, you will be able to build up an Oracle GoldenGate configuration that  works in real life scenario.

Join the author in this learning journey to gain the knowledge on this amazing technology!

Who is the target audience?
  • Database Administrators
  • System Integrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 47 Lectures Collapse All 47 Lectures 10:20:58
+
Introducing the Oracle GoldenGate 12c Fundamentals course
1 Lecture 05:19
+
Starting with Oracle GoldenGate
4 Lectures 01:00:36

By the end of this lecture, you should be able to:

  • Describe the Oracle GoldenGate features
  • Describe the scenarios on which GoldenGate can be used
  • List the Oracle GoldenGate topologies
  • List the supported databases and operating systems
  • List the Oracle GoldenGate Product Line products
  • Compare between Oracle GoldenGate and Data Guard
Preview 15:47

A quiz that tests the basic information about Oracle GoldenGate capabilities.

Quiz: About Oracle GoldenGate
4 questions

By the end of this lecture, you should be able to:

  • List and describe the processes in Oracle GoldGate
  • Explain initial load and change synchronization mechanism
  • Explain checkpoint mechanism in Oracle GoldenGate
  • Describe the CSN
  • Describe the purpose of GGSCI 
Preview 18:50

This quiz tests your understanding to the GoldenGate Architecture.

Quiz: GoldenGate Architecture
4 questions

This practice guides you on how to prepare your environment to use it in implementing the course practices. The practices in the course were designed using Oracle VirtualBox virtual machines. You will build two Linux-based machines with Oracle database installed on each.

Practice 1 Preparing the Practice Environment
15:17

In this practice will perform the following:

  • Install Oracle GoldenGate on the Oracle Linux appliances that you created in the previous practice
  • Get familiar with ggsci command prompt
Preview 10:42
+
Implementing Unidirectional Replication
11 Lectures 02:39:55

By the end of this lecture, you should be able to:

  • Configure Oracle GoldenGate Roadmap
  • Implement the procedure to Prepare an environment or Oracle GoldenGate
  • Understand the Supplemental Logging options
  • Create Manager process
  • Understand when and how to use Source Definitions Overview
Preparing Oracle GoldenGate Environment (Part 1 of 2)
16:47

This lecture is a continue to the previous lecture.

Preparing Oracle GoldenGate Environment (Part 2 of 2)
08:59

In this practice will perform several actions that aim at preparing the databases for GoldenGate. The following list is an overview of those actions:

  • Verify primary key values uniqueness
  • Verify the archiving mode is enabled
  • Set up a GoldenGate database user
  • Enable supplemental logging
  • Enable GoldenGate Replication
  • Configure and start the Manager process
  • Configure the GLOBALS parameter file
Practice 3 Preparing the Environment for GoldenGate
14:20

By the end of this lecture, you should be able to:

  • Understand what is Initial Load
  • Specify the options to implement the Initial load
  • List the Oracle GoldenGate Initial Load Methods and understand the difference between each other
Implementing Initial Load
19:57

In this practice you will perform the following Oracle GoldenGate initial load methods:

  • File to Replicat: in this method, the Extract process captures the source data into trails on the target system. The initial load Replicat task then reads the data from the intermediate files and apply it into the target database.
  • Direct Load: in this method, the Extract process reads the records from the source database and send them directly to a Replicat task on the target database system.
Practice 4 Implementing Initial Load (Part 1 of 2)
15:32

This lecture is a continue to the previous lecture.

Practice 4 Implementing Initial Load (Part 2 of 2)
05:51

By the end of this lecture, you should be able to:

  • Perform the procedure to create a classic Extract process
  • Add a local and remote trail files
  • Start and stop an Extract process group
  • Delete an Extract process group
Configuring Change Capture
16:26

By the end of this lecture, you should be able to:

  • Perform the procedure to create a classic Replicat process
  • Describe the self-describing trail files
  • Start and stop an Replicat process group
  • Delete an Replicat process group
Configuring Change Delivery
19:56

In this practice you will implement the whole change synchronization cycle. You will configure a primary Extract process, a Data Pump process and a Replicat process that will keep the databases in sync after the initial load is finished. Needless to say, this is the core functionality of Oracle GoldenGate.

Practice 5 Configuring Change Synchronization Part I
16:38

This practice has the same target as the target of the previous one, which is configuring the GoldenGate change synchronization. This practice, however, has the following differences than the previous one:

  • You do not have to stop the DML operations on the source database.
  • You will use a database utility (Data Pump) to perform the initial load process. Generally speaking, this method is faster in big databases than using the GoldenGate initial load methods.
Practice 6 Configuring Change Synchronization Part II
15:26

In this practice you will learn the proper way of shutting down an Oracle GoldenGate configuration. Then you will learn how to start it up.

Practice 7 Starting up and Shutting Down the Systems
10:03
+
Monitoring Oracle GoldenGate Configuration
4 Lectures 01:01:12

By the end of this lecture, you should be able to:

  • Display the status of the processes
  • Obtain reports on the Extract and Replicat lags
  • Implement Automatic Heartbeat Tables functionality
  • View and Understand the process reports and discard files
Monitoring Oracle GoldenGate
19:26

In this practice you will study the commands and tools that you use to monitor an Oracle GoldenGate configuration.

Practice 8 Monitoring Oracle GoldenGate
14:50

By the end of this lecture, you should be able to:

  • Use the LOGDUMP to navigate in the records in a trail file
  • Understand the output of the LOGDUMP utility
  • Control the LOGDUMP view
  • Display statistics about the records in a trial file
Using LOGDUMP Utility
13:38

As you learnt in the previous lecture, Logdump is a robust GoldenGate troubleshooting utility that allows you to look into the trail file contents. 

In this practice you will get familiar with using the utility to perform the basic tasks in it.

Practice 9 Using LOGDUMP Utility
13:18
+
Data Filtering and Manipulation
4 Lectures 54:12

By the end of this lecture, you should be able to:

  • Set up a data selection based on a table, rows, operations and columns
  • Selecting Rows with WHERE Clause
  • Selecting Rows with FILTER Clause
  • Ensure Data Availability for Filters
  • Perform Columns Mapping 
  • Retrieving Before and After Values
Data Filtering and Manipulation Part I
16:38

In this practice you will implement the data filtering and manipulation techniques in Oracle GoldenGate. Specifically, you will perform the following:

  • Select rows with a WHERE clause and make the data available
  • Select rows with FILTER clause
  • Implement column mapping using COLMAP clause
Practice 10 Implementing Data Filtering and Manipulation Part I
10:31

By the end of this lecture, you should be able to:

  • Use built-in functions to perform column tests
  • Use built-in functions to manipulate columns data
Data Filtering and Manipulation Part II
15:53

In this practice you will use Oracle GoldenGate built-in functions for data filtering and manipulation. Specifically, you will implement examples to do the following:

  • Set up a transaction history table in the target database
  • Use the Oracle GoldenGate IF function, string and date built-in functions
  • Use the SQLEXEC function
Practice 11 Implementing Data Filtering and Manipulation Part II
11:10
+
More Oracle GoldenGate Configurations
10 Lectures 01:53:57

By the end of this lecture, you should be able to:

  • Use macros
  • Use User Tokens
Using Macros and User Tokens
08:23

In this practice you will perform the following:

  • Develop a macro library and use it in the process parameter file
  • Use the user tokens in your Oracle GoldenGate configuration
Practice 12 Using Macros and User Tokens
06:35

By the end of this lecture, you should be able to:

  • Manage Oracle GoldenGate Report Files
  • Implement BatchSQL processing
  • Use compression on the outgoing blocks of records
  • Understand and use Event Marker System
More Configuration Options
18:26

In this practice you will implement an example of using Oracle GoldenGate Event Maker System. You will create an events table. When a specific record is inserted into the table, the Replicat process will stop. If you insert another specific record, the Extract process will end.

Practice 13 Using Event Marker System
05:43

By the end of this lecture, you should be able to:

  • Use the Encryption Key method and the Wallet method to encrypt the network packets, trail files, and database login credentials
Encryption in Oracle GoldenGate
19:48

In this practice you will implement the following encryption GoldenGate options:

  • Encrypting the database login credentials using the credential store.
  • Encrypting the data in the remote trail files using the Wallet method.
Practice 14 Implementing Encryption in Oracle GoldenGate
09:04

By the end of this lecture, you should be able to:

  • Understand the advantages of integrated mode
  • Understand the options to implement an integrated Extract
  • Create an integrated Extract and Replicat
  • Switch a GoldenGate process from classic mode to integrated mode
  • Monitor an integrated Extract or Replicat
Implementing Integrated Processes
14:48

In this practice you will perform the following:

  • Switch the Extract process from the classic mode to the integrated mode
  • Switch the Replicat process from the non-integrated mode to the integrated mode
  • Use monitoring tools to monitor the integrated processes
  • Generate a healthcheck report on the integrated GoldenGate configuration
Practice 15 Implementing Integrated Processes
16:53

By the end of this lecture, you should be able to:

  • Understand the advantages of implementing coordinated Replicat
  • Implement a coordinated Replicat
  • Manage a coordinated Replicat
  • Synchronize coordinated Replicat threads after unclean stop
Implementing Coordinated Replicat
07:11

In this practice you will set up a coordinated Replicat and perform a basic testing on it.

Practice 16 Implementing Coordinated Replicat
07:06
+
Implementing DDL Replication
2 Lectures 23:47

By the end of this lecture, you should be able to:

  • Understand the requirements and restrictions on implementing DDL replication in Oracle GoldenGate
  • Understand the DDL replication scopes
  • Set up a DDL replication
  • Control the behavior of a DDL replication
  • Handling errors generated by DDL replication 
Implementing DDL Replication
19:40

In this practice you will enable the DDL replication and perform testing on its functionality.

Practice 17 Implementing DDL Replication
04:07
+
Implementing Bidirectional Replication
8 Lectures 01:48:21

By the end of this lecture, you should be able to:

  • Understand how the bi-directional replication works in Oracle GoldenGate
  • Understand the challenges in implementing a bidirectional configuration 
  • Understand the Data Looping issue and how to prevent it
Bidirectional Replication Part I
10:50

This a continue to the previous lecture.

Bidirectional Replication Part I (continue)
10:33

By the end of this lecture, you should be able to:

  • Configure Conflicts Detection and Resolution (CDR) rules
Bidirectional Replication Part II
10:19

This is a continue to the previous lecture.

Bidirectional Replication Part II (continue)
12:14

In this practice you will set up an Oracle GoldenGate Bidirectional Replication between db1 and db2. The practice plan will be as follows:

  • Set the bidirectional replication without CDR
  • Test the bidirectional configuration
  • Configure a CDR
  • Test the configured CDR
Practice 18 Setting up Bidirectional Replication ( Part 1 of 2 )
14:28

This is a continue to the previous lecture.

Practice 18 Setting up Bidirectional Replication ( Part 2 of 2 )
15:46

By the end of this lecture, you should be able to:

  • Set rules to handle errors caught by Oracle GoldenGate processes
  • Use Exceptions table to save the caught exceptions
  • Set rules to handle TCP/IP Errors
Handling Errors
18:31

In this practice you will create a table in the target database where the exceptions caught by the Replicat will be saved in it. You will then perform test cases on this functionality.

You will examine the exceptions table functionality first using the EXCEPTIONSONLY option, then using the MAPEXCEPTION option.

Practice 19 Using Exceptions Table
15:40
+
Oracle GoldenGate Maintenance
2 Lectures 17:38

By the end of this lecture, you should be able to:

  • Specify the Oracle GoldenGate tools that can be used for troubleshooting
  • Generate a general health checkup report on an Oracle GoldenGate configuration
  • Recognize some troubleshooting scenarios and understand how to handle them
  • Implement the procedure to recover from a corrupted trail file
Troubleshooting Oracle GoldenGate
08:24

In this practice you will apply the Oracle GoldenGate patch set 12.2.0.1.161220.

Practice 20 Applying Oracle GoldenGate Patch Sets
09:14
+
Oracle GoldenGate Further Education
1 Lecture 16:01

By the end of this lecture, you should be able to:

  • Understand the advantages of using User Exits
  • Understand the requirement to implement User Exits
  • Describe the procedure to build up Oracle GoldenGate Topologies
  • Use Oracle GoldenGate to implement a standby database
  • Understand in high level how to configure Oracle GoldenGate HA
  • Understand the areas to cover for further Oracle GoldenGate Knowledge 
More About Oracle GoldenGate
16:01
About the Instructor
Ahmed Baraka
4.4 Average rating
106 Reviews
583 Students
2 Courses
Snr. Database Administrator

Ahmed Baraka has 19 years of extensive experience in the computer industry, with focus on Oracle database administration technologies used in complex and high available environments. Baraka's expertise is designing and maintaining database solutions for complex business needs using a wide selection of technologies, like Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager. He has worked with international firms in Australia and Abu Dhabi. His hobbies are soccer (football) and computer games.

* Please note discounts may be slightly higher than advertised amount due to rounding and currency conversion.