Sunday, June 12, 2016

GoldenGate Integrated Replicat 12c

Integrated replicat can be configured from oracle database version 11.2.0.4 
when ever we enabled parameter enable_goldengate_replication=true, we can configure Integrated replicat for database 


Always trail data can be logical change record (LCR) Integrated format (or) either may be classic ( canonical ).The delivery replicat uses the canonical data on the trail and uses API from the replicat process to an Inbound server and converts the data from canonical to LCR's ( Logical Change Record ) 
When we talk about In Bound server of database, InBound server consists of following components 
Receiver: In Inbound server, receiver Reads trails in LCR format
Preparer:  Preparer process the data on the trail and check dependency's and group transactions in order 
coordinator: Coordinator coordinates transactions and maintains the order between applier and processes 
Appliers: Applies transactions to target table 

Syntax: Used to Create Integrated replicat 
ggsci> add replicat rep_name, integrated exttrail /remote_dir/aa 
ggsci> start rep_name

Note:
There is no checkpoint table is required and checkpoint file is updated to indicate Integrated mode 

--Nikhil Tatineni--
--12c GoldenGate--

links Related to RAC 





Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...