Oracle GoldenGate 12c Fundamentals

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

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 

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.

Installing Oracle GoldenGate

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

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

This lecture is a continue to the previous lecture.

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

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

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.

This lecture is a continue to the previous lecture.

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

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

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.

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.

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.

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

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

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

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.

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

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

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

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

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

• Use macros
• Use User Tokens

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

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

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.

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

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.

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

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

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

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

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 

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

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

This a continue to the previous lecture.

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

• Configure Conflicts Detection and Resolution (CDR) rules

This is a continue to the previous lecture.

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

This is a continue to the previous lecture.

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

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.

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

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

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