Oracle GoldenGate 12c database replication workshop

Learn database replication by creating virtual machines with Oracle GoldenGate 12c on Oracle 12c Multitenant databases.
Oracle GoldenGate 12c database replication workshop
File Size :
1.20 GB
Total length :
1h 37m



Javier Morales Carreras


Last update




Oracle GoldenGate 12c database replication workshop

What you’ll learn

Understand all the basics about Oracle databases replication with Oracle GoldenGate tool
Create a duplicated and synchronized environment for emergency or reporting
Perform a database migration with (almost) zero downtime
Learn a lot of stuff about Oracle12c architecture, Multitenant databases, new features of GoldenGate12c, …
Create a lab test environment with two OraLinux servers with Oracle to test logical replications

Oracle GoldenGate 12c database replication workshop


Basic knowledge of database architecture
Some knowledge of Oracle databases and linux Operative Systems
Some knowledge about virtual machines
Having a PC or laptop with 4GB of RAM (optimal) available to create two virtual servers (2GB each) and disk space available of 50GB for the virtual servers disks.


Are you ready to create your own database replication environment with Oracle GoldenGate 12c? and have in your PC a complete database environment with two oracle servers and Oracle GoldenGate 12c installed and set up to replicate data from one server to another? and do you want to test it all in real, with all scripts and logs, to make it all work in your self-made test environment? Then this course is for you. This is a practical workshop where you will learn how to replicate Oracle12c databases using Oracle GoldenGate12c by building your own replication environment. The course will give you the basics and the step by step practices to reproduce, in your virtual machines, a feel like production environment where you will replicate a database schema keeping it in sync with the source database. In the course you will be guided step by step to set up and verify all steps in the Oracle GoldenGate12c installation and configuration, by using VirtualBox virtual machines with a pre-built Oracle12c multitenant database ready to use. You will start up in your laptop or PC two virtual machines with OraLinux servers and you will practice all the exercises in a total real environment. So, even the workshop is based on OraLinux and Oracle12c multitenant, the replication theory would be valid for any supported environment you want to replicate: SQLServer through an Oracle server, or an Oracle Server to a DB2, etc. and including different versions like replicating data from an old Oracle11g to a Oracle12c with or without multitenant.The course is divided into three main sections: 
1.- Laboratory installation, which will include detailed instructions to install and set up: Oracle VirtualBox, two virtual machines with OraLinux, each Oracle database server for GoldenGate, The installation and configuration of Oracle GoldenGate12c and a sample schema.
2.- Basic replication, using the same database as source and target, for a single table.
3.- Advanced replication, using the two servers to propagate all transactions from the source database to the target database at schema level (all tables and sequences). You woulc use this method to perform a database version upgrade to a new database release, having two environments in sync, and doing the upgrade by just stopping the source environment and starting the target database to the users. This is often called “upgrade with almost zero downtime”, and it’s one of the most valuable upgrading procedures when it comes to upgrade critical servers. In other words, you will learn how to build a new replicated environment you may use as reporting database, or quality assurance test servers where you may test live your “go to production” procedures, or using it as a DR (disaster recovery) database copy ready to use in production in a severe lost of the main database, with all up to date transactions!. And so, you will find lots of chapters with important information about the Oracle GoldenGate funcionality and the particular considerations about Oracle database at administration level, such as setting up the supplemental login, how to manage multitenant Oracle12c database, important aspects about the logging files and transactional processing, or how to copy a schema consistent to a point in time to create an identical target based on a SCN. The course also includes quizzes, checks, scripts, dictionary of terms and concepts, and basic troubleshooting guide it may be useful in your daily work. It’s a complete guide and workshop with a practical laboratory you may use and keep for further tests and checks.


Section 1: Introducction to Oracle Golden Gate

Lecture 1 Welcome to the Practical Oracle GoldenGate12c course

Lecture 2 Overview of Oracle GoldenGate12c

Lecture 3 Logical replication vs. physical replication

Lecture 4 Description of other GoldenGate products

Section 2: Preparing your environment

Lecture 5 Oracle VirtualBox and virtual machines

Lecture 6 OraLinux Oracle12c with GoldenGate

Lecture 7 Other possible installations (optional)

Lecture 8 Download and Install Oracle VirtualBox

Lecture 9 Set up the virtual network

Lecture 10 Download the VM template and generate two virtual machines

Lecture 11 Set up host connectivity

Lecture 12 Set up the /etc/hosts file

Lecture 13 Set up database connectivity

Lecture 14 Install the Oracle GoldenGate software

Lecture 15 Set up the Oracle GoldenGate environment

Lecture 16 Database setup for Oracle GoldenGate 12c

Lecture 17 REVIEW – Check your environment

Section 3: Oracle GoldenGate infrastructure and other things you must know before continue

Lecture 18 The importance of SCN

Lecture 19 Understanding database logging

Lecture 20 Restore database at a point in time (SCN)

Lecture 21 Some notes about Oracle12c multitenant architecture

Section 4: Table replication to the same database

Lecture 22 Create the manager process

Lecture 23 Methods of data capture: classic and integrated

Lecture 24 Create the extract process – The ADD command

Lecture 25 Replicate data in the same database

Lecture 26 Monitoring the replication

Section 5: Managing the Oracle GoldenGate12c command line interface

Lecture 27 Some useful commands

Lecture 28 The GLOBALS parameter file

Lecture 29 Error checking

Section 6: Schema replication to a remote database

Lecture 30 Modify extract process on source server

Lecture 31 Consistent schema copy based on a given SCN

Lecture 32 Create the pump process based on SCN number

Lecture 33 Create the replicat process on the target server

Lecture 34 Some considerations about sequences and triggers

Section 7: EXTRA: Software, official documentation and other resources

Lecture 35 List of software used in the course.

Lecture 36 Other VM’s and additional products

Lecture 37 Official documentation of Oracle GoldenGate12c

Lecture 38 Dictionary – glossary of terms used in the course

Lecture 39 Basic troubleshooting

Database Administrators,Application developers or administrators,Anyone who wants to know the tech aspects of a logical database replication between Oracle databases with Oracle GoldenGate tool,Project leaders who want to know or participate in replication projects

Course Information:

Udemy | English | 1h 37m | 1.20 GB
Created by: Javier Morales Carreras

You Can See More Courses in the IT & Software >> Greetings from

New Courses

Scroll to Top