-----------------------------------
GOLDEN GATE 12C Fundamentals Course
-----------------------------------
History:
Integrated software suite developed by Cullinet ca. 1980
Replication and data-integration software developed by
GoldenGate Software; since 2009 marketed and controlled by Oracle Corporation
####################
Introduction Session
####################
Golden gate helps in Sharing data inserts/DML/DDL with target site
so its a data integration from source to target site
--------------------------------
Golden gate is used to acheive :
--------------------------------
1. High availability
Meaning data is always available , that is accessible all the time for application
2. Zero downtime for migrating/ OS upgrades
3. Live/ real time reporting with GG ..
4. ODS (Operational data support) / ETL (extract, transform, load)modifications
###########################
key featues of Golden Gate
###########################
Near real time data integration
Heterogeneous in nature --> Oracle to non oracle ,linux to windows
Transactional in nature
Design to meet enormous amount of transactions
---------------------
How replication works
---------------------
We have source and target database
1. Initial syncup needs to do done for soure and target database (Optional depends
on business need)
2. Identify the commited changes and send them to target from source
3. Replicate the changes on target
#########################
Golden gate v/s Datagurad
#########################
Use Datagurad for oracle to oracle databases same version
Use GG when :
Non oracle platforms
active-active configuation
cross OS and diff oracle versions requirements
------------------------
Limitations of Dataguard
------------------------
Dataguard we can't have bidirectional replication
only one is active unless logical standby database
Dataguard does not support object level or schema level replication
Used mainly for oracle to oracle ( Can support heterogenous*)
-----------------------
Benifits of Golden gate
-----------------------
Golden gate supports heterogenious replication
Supports many RDBMS for replication
Minimal overhead on source database
As it does redo base change capture thats why it does not have any overhead on
source database
Golden gate supports bidirectional replication
Golden gate is realtime as it directly pics up the changes from redo log
We can use GG for upgrading database from 11g to 12c etc
It supports 0 downtime upgrade
It offers live reporting data availalbe on target , moves data
We can replicate data from multiple db to ODS for business inteligence
#######################
Golden Gate topologies
#######################
-------------------------------
1.Unidirectional active passive
-------------------------------
Changes from source database are replicated on target database
Used for Query offloading
Target database can be used as reporting
-----------------------------
2.Biderectioanl active active
-----------------------------
Both are target and source for each other
Serves like standby DB and gives HA environment
Here both sites are active and doing DML Changes
here both are source and target for each other
Users are logggin in to both the databases and has the ability to to make the
changes
----------------------------------------------------
3.One to many , sharing data with more than one site
----------------------------------------------------
It distributes the changes with more than one site
here I have choice to distribute the region specific data to particular target
----------------
4. Many to One :
----------------
consolidatation / multiple source and one target / for data ware house
Here multiple databases will share the changes with only one target database
-------------------------------------------
5.Cascading configuration using golden gate
-------------------------------------------
Used for data marts purpose
Here we can used intermedate database to distribute the chages to multiple sites
Here the benefit is to used to network of inetermidate database to send the changes
to others
So here we can avoid sending data directly from main PROD source
----------------------------
6.Multi master configuration
----------------------------
here we have 3 or more source and target so called as multimaster configuration
########################
Golden Gate components :
########################
-----------------
Capture/Extract :
-----------------
It will capture changes from the tansaction logs/journal/redo logs
Primary EXTRACT reads and writes to and from the trail file
secondary extract/pump reads trail file and send it to remote trail file
Extract reads and extract writes
Extract read-
Transaction logs
Trail file
extract file ( Sql,XML,ASCII)
data from db tables
jms/flat files
extract writes to-
trail file
extract file
jms/flat file
Extract can write locally or remotely
------------------
server collector:
------------------
Receives data and writes it to remote trail file / local to target
It will receive chagnes either directly from paimary extract or secondary extract
called as data pump
---------------------
replicat or delivery:
---------------------
Reads the trail file and applies the changes on target database
##################
Golden gate offers
##################
zero downtime upgrade/migrations
unplanned outage situations
Reporting solution for weekly/monthly/quarterly reports
#############################
Offloading/downstream capture
#############################
Change capture can be offloaded to intermidate database by copying the redo logs
there
called as integrated capture or downstream configuration
11.x and later
source ---> downstream db ---> target db
11.x 11.2 any version
