GoldenGate Table Based Extract, PUMP, REPLICAT parameters setting

Hello, today I will share the goldengate table-based extract, pump and replicat parameters.

We must hide the user and password that it will create as a priority and run the following commands to create alias

Create Wallet 
Add CredentialStore

We must add the following parameters to the goldengate manager conf.

These parameters are used for automatic restart when replicate or extract abdended.

 

Edit Mgr : 

PurgeOldExtracts ./dirdat/*, UseCheckPoints, MinKeepDays 180 
Autostart Replicat R* 
Autostart Extract E* 
AUTORESTART Extract *, WaitMinutes 1, Retries 10

 

In the extract parameters, we determine the location and file name of the file to be created under dirdat and the tables to be mapped.

we create alias to connect to database

 

Alter CredentialStore Add User [email protected] Password GOLDENGATE19C Alias ogg_test
dblogin useridalias ogg_test

userid [email protected], password GOLDENGATE19C 

register extract 1Test database 


add extract 1Test integrated tranlog, begin now 

add exttrail ./dirdat/1e, extract 1Test, megabytes 100 


extract 1Test
SETENV (ORACLE_SERVICE='Test') 

TranlogOptions IntegratedParams (max_sga_size 1024, parallelism 2) 
UserIdAlias ogg_test
UPDATERECORDFORMAT FULL 
STATOPTIONS, RESETREPORTSTATS, REPORTFETCH 
REPORTCOUNT EVERY 1 MINUTES, RATE 
REPORT AT 00:00 
REPORTROLLOVER ON SUNDAY 
--MAPINVISIBLECOLUMNS 

-- Discard File Bilgileri 
DISCARDFILE ./dirrpt/1Test.dsc, APPEND, MEGABYTES 10 
-- Olusan Trail File Bilgileri 
EXTTRAIL ./dirdat/1t
-- Long Running Transaction Bilgileri 
WARNLONGTRANS 2H, CHECKINTERVAL 30M 
-- Table Mapping
Table Test.deneme;

Table Test.deneme1;

Table Test.deneme2;

Table Test.deneme3;

 

After setting the pump parameters, we give the value that we will send the file to replicate and we say mappin all the tables that will come from the Test user

add extract 1Test, exttrailsource ./dirdat/1t

add rmttrail ./dirdat/1r, extract , megabytes 100 

Extract 1Test
SETENV (ORACLE_SID='Test') 
UserIdAlias ogg_test 
rmthost xxx.xxx.xx.xx, mgrport 7819 
rmttrail ./dirdat/1r 
table Test.*;

 

We create alias on the replica side, we specify the replicate name, we map the future tables from source and target.

Alter CredentialStore Add User [email protected] Password GOLDENGATE19C Alias ogg_test

REPLICAT 1Test
SETENV (ORACLE_SID='Test') 
DBOPTIONS INTEGRATEDPARAMS(parallelism 2) 
--ASSUMETARGETDEFS 
DiscardFile ./dirrpt/1Test.dsc, Purge 
UserIdAlias ogg_test
--DDL Bilgileri 
DDL INCLUDE MAPPED & 
EXCLUDE OBJTYPE 'TRIGGER' 
MAPINVISIBLECOLUMNS 
--INSERTMISSINGUPDATES 
DDLOPTIONS MAPDERIVED, REPORT 
--DDL EXCLUDE ALL 
--DDLOPTIONS UPDATEMETADATA 
--HANDLECOLLISIONS 

DBOPTIONS SUPPRESSTRIGGERS 
--DDL Error'lerini ignore eder 
DDLERROR DEFAULT DISCARD 
DDLERROR 24344 DISCARD 
DDLERROR 1435 DISCARD 
DDLERROR 955 DISCARD 
--ALLOWDUPTARGETMAP 
MAP Test.*, TARGET Test.*; 


Add Replicat 1Test Integrated exttrail ./dirdat/1r

 

The most important area in replicate is when starting replicate, while getting initiolaload, we gave the flashback_scn parameter, and we add the value there when starting replicate. Thus, the lack of data is eliminated.

START 1Test atcsn 16469693058776

 69,691 views last month,  1,203 views today

About tayfun inam

Computer Engineer -PostgreSql-Oracle Database Administrator I am about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 8+years experience.I have OCA,PostgreSql senior Certificates I have worked 50+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.

Leave a Reply