Day2_Architecture_Difference_Classic_and_Integrated Extract_Certification matrix_download_GG_HUB

This is Day 2 session of 30 day challenge. For more sessions and challenges do contact the trainer over contact details mentioned in signature.

For Training and consulting requirement for Oracle Goldengate, Pls do fill out contact information form using below link:
https://lnkd.in/gC7pfn2

Also u can directly reach out to me via below methods:
1. Email @[email protected]
2. Call/whatsapp@+14168715708
3. DM@ https://www.linkedin.com/in/ashish-ag...

Here is quick summary of day 2 session and tasks assigned to it:
Day 2 Recap

A. 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. There are two types of extract processes.
1- Classic Extract process
2- Integrated Extract process

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. It creates less load on the database as well.

B.

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

C.

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

--After copying the Software , invoke the runInstaller

2. 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
D. 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
--if you restart the process new report file generates
--ggserr.log file is the log for GG , like alert log for Database
--Manager Parameter file
--mgr.prm

E. Manager Process
--Purpose is to manage all the GG resources
--differnt commands manager process :
--info all -- to gett all details
--edit params mgr -- Edit manager parameters
--view params mgr -- view teh manager parameters
--info mgr -- Manager info
--start mgr -- start the manager
--stop mgr -- stop the manger

F. There are total 3 processes involved in GG Classic Arch replication process

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

We will be configuring these process for setting up Oracle GG replication

- 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

- We are doing local capture and local apply.

G. Below are the Options to Install Goldengate:

--Install GG on ggate1 for local capture and on ggate2 for local apply

--Install GG on ggate1 which will capture the data locally from ggate 1 DB and apply to ggate2 DB remotely

--Install GG on ggate2 which will capture the data remotely from ggate 1 DB and apply to ggate2 DB locally

--Install GG on intermediate server eg ggate3 which will capture the remotely from ggate1 and apply the data remotely on ggate2

--Install GG on intermediate server eg ggate3 which will capture the remotely from ggate1 but install GG on ggate2 as well for local apply

--Install GG on ggate1 which will capture the data locally from ggate1 but install GG on intermediate server eg ggate3 which will apply data remotely to ggate2

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Post-session assignment:
1. complete lab setup for both VMs
2. create database instances on both nodes
3. Install OGG on ggate1 and ggate2