Day1 Introduction, Overview, Different types of Architecture, Certification Matrix

This is Day 1 of 7 week learning OGG Challenge. below are the things we discussed:
In Day1 of Oracle GOldengate Classic Architecture training we discussed about below:

A. Introduction to goldengate architecture :
In 2009 Oracle acquired goldengate and since then it is called as oracle golden gate and till 2017 there is only one goldengate architecture . In 2017 another goldengate architecture was introduced.

There are two types of Golden Gate architecture:
1- Classic Architecture
2- Microservices Architecture

Classic Architecture : It is command prompt based Architecture and is available for oracle as well as non oracle platforms.

In classical Architecture there are different type of processes which are Extract processes and Replicat processes. Goldengate is a change data capture tool. Whatever changes are happening in the database
those changes are stored in redo logs of database. Goldengate source are redo logs or archive logs of a database. Goldengate processes capture the data from source database and applied it to target
database.

Microservices Architecture : It was introduced in 2017 and you manage it through GUI and it is available on cloud integration as well. Until today microservices is available for Oracle Databases only.

B. Oracle Goldengate Veridata : Oracle Golden Gate has another tool called Veridata. It is a separate licensed tool and is used to verify data. It doesn’t need any downtime while verifying the data.

C. Why Goldengate?

Goldengate is near real time replication and it supports heterogeneous environment and heterogeneous platforms across different databases. It is high performance with low impact tool can and move large data volumes very efficiently.

D. There are two types of extract processes.
1- Classic Extract process
2- Integrated Extract process

EF. Classic extract is there since beginning . Capture process is external to database and it reads the data in sequential manner and capture only committed transaction. In integrated capture log minor build happens and logminer sends changes in the form of LCR to the Extract process. Performance of integrated capture is very high and much faster than classic capture.

Types of Replicat
1- Nonintegrated or Classic Replicat
2- Integrated Replicat
3- Co ordinated Replicat
4- Parallel Replicat
a. Parallel integerated Replicat
b. Parallel nonintegrated Replicat


F. Oracle Goldengate Architecture - How data flows in Goldengate?
All the processes in Goldengate work independently from each other however they depend on each other for reading the data. We call capture process as extract process as well.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
G.

1. The Goldengate training VM Has 12.2 Database and 19C Binaries are present in /home/oracle/softwares
2. For Goldengate binaries download, Before download and install Install , make a note of below
Source : DB Type , Version , Platform
Target : DB Type , Version , Platform

H.

1. Before you proceed with download and installation , always Check the certification matrix

--Follow the instructions to download the GG from OTN
Check for system requirement and supported platform for oracle goldengate version we are installing use link :
https://www.oracle.com/middleware/technologies/fusion-certification.html

-2. Before proceeding with installation u need to define location where to install. You may install GG in:
a. Seperate mount point:
b. Existing mount point

c. To consider how much space u need for installation, Understand the requirement. Do Research and design


3. Below are the options available to Install GG 19c:

--GUI Installation
--Silent Installation –

./runInstaller -silent -responseFile /home/oracle/Downloads/ggate/fbo_ggs_Linux_x64_shiphome/Disk1
/response/oggcore.rsp
--Silent installation , You can use the response file
--You need to have Different GG install for Different versions of the Database

GGSCI is the command to invoke the GG
--Go to GG home
--execute "./ggsci"
--To see all process in GG
--Info all
J. Manager process is default for gg install

--Only one manager process for each GG install
--All parameter file folder
--$GG_HOME/dirprm
--Create directories in GG
--create subdirs
--"dirpcs" is the folder for all the process with running in GG
--"dirrpt" stores all the reports files
--Manager Parameter file
--mgr.parms

K. Manager Process
--Purpose is to manage all the GG resources
--differnt commands manager process :
--edit params mgr -- Edit manager parameters
--view params mgr -- view teh manager parameters
--start mgr -- start the manager
L. There are total 3 processes involved in GG replication process (Classic Architecture)

- Capture or Extract process
- Pump process
- Delivery or Replicat process

- Oracle GG installed in source and target.
- Source GG installation location - /u01/app/oracle/product/ogg_src
- Target GG installation location - /u01/app/oracle/product/ogg_trg