Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 1.5 hours on-demand video
  • 5 articles
  • 11 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
IT & Software Other IT & Software Oracle Data Integrator

Oracle GoldenGate 12c database replication workshop

Learn database replication by creating virtual machines with Oracle GoldenGate 12c on Oracle 12c Multitenant databases.
Rating: 4.4 out of 54.4 (100 ratings)
492 students
Created by Javier Morales Carreras
Last updated 6/2020
English
English, Spanish
30-Day Money-Back Guarantee

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

Requirements

  • 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.

Description

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.

Who this course is for:

  • 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 content

7 sections • 39 lectures • 1h 37m total length

  • Preview01:33
  • Preview02:17
  • Preview03:02
  • Description of other GoldenGate products
    02:14
  • Quiz
    6 questions

  • Oracle VirtualBox and virtual machines
    01:40
  • OraLinux Oracle12c with GoldenGate
    01:50
  • Other possible installations (optional)
    02:01
  • Preview01:39
  • Download and install Oracle VirtualBox
    1 question
  • Set up the virtual network
    01:33
  • Set up the virtual network
    1 question
  • Preview03:19
  • Download the VM template and generate two virtual machines
    1 question
  • Set up host connectivity
    01:16
  • Set up host connectivity
    3 questions
  • Preview01:48
  • Set up the /etc/hosts file
    1 question
  • Set up database connectivity
    01:59
  • Set up database connectivity
    1 question
  • Preview04:08
  • Install the Oracle GoldenGate software
    1 question
  • Set up the Oracle GoldenGate environment
    02:56
  • Setup Oracle GoldenGate environment
    1 question
  • Database setup for Oracle GoldenGate 12c
    04:04
  • Database setup for Oracle GoldenGate12c
    1 question
  • Preview01:45

  • The importance of SCN
    02:45
  • Understanding database logging
    01:52
  • Set up the database logging
    3 questions
  • Restore database at a point in time (SCN)
    02:13
  • Some notes about Oracle12c multitenant architecture
    03:21

  • Create the manager process
    02:26
  • Create the manager process
    1 question
  • Methods of data capture: classic and integrated
    01:40
  • Create the extract process - The ADD command
    02:40
  • Create the extract process
    1 question
  • Replicate data in the same database
    03:16
  • Create the replicat process
    1 question
  • Monitoring the replication
    01:14

  • Some useful commands
    00:53
  • The GLOBALS parameter file
    01:55
  • Error checking
    02:07

  • Modify extract process on source server
    02:03
  • Modify the extract process ext1
    1 question
  • Consistent schema copy based on a given SCN
    02:33
  • Duplicate HR schema at a consistent SCN using Export and Import Data Pump utilit
    1 question
  • Create the pump process based on SCN number
    03:25
  • Create the extract process for PUMP
    1 question
  • Create the replicat process on the target server
    01:56
  • Create the replicat process in the remote database
    1 question
  • Some considerations about sequences and triggers
    01:52

  • List of software used in the course.
    00:07
  • Other VM's and additional products
    00:07
  • Official documentation of Oracle GoldenGate12c
    00:03
  • Dictionary - glossary of terms used in the course
    01:40
  • Basic troubleshooting
    03:34

Instructor

Javier Morales Carreras
OCP Oracle DBA
Javier Morales Carreras
  • 4.5 Instructor Rating
  • 139 Reviews
  • 2,814 Students
  • 2 Courses

Javier Morales is Oracle DBA certified professional since 2002. Writer of the oracle best seller "Optimización SQL en Oracle" (spanish - Amazon) about SQL performance tuning in Oracle, he has worked as DBA and developer menthor for entities like Health Government (Spain - Valencia, Norway), National Police, Presidence Ministry of Spain, Oracle Iberica (Spain and Portugal) and many others. 

Since 2009 he owns the consulting company named TechLevel and provides expert services based on Oracle with a collaborators team with more than 15 years of experience.

He had performed almos zero downtime migrations for the Valencian bloodbank and several hospitals including architecture change (windows to linux, solaris to linux) and different oracle versions.


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.