Overview
Oracle Golden gate for Big data is a separate software than the standard Oracle Golden Gate, so you need to download it from the edelivery or the oracle site.
Installation
Unzip
[oracle@edvmr1p0 ~]$ mkdir /u01/app/oggtrg [oracle@edvmr1p0 ~]$ cd /u01/app/oggtrg [oracle@edvmr1p0 oggtrg]$ pwd /u01/app/oggtrg [oracle@edvmr1p0 oggtrg]$ unzip /stage/V839824-01.zip <- Unzip the binaries Archive: /stage/V839824-01.zip inflating: ggs_Adapters_Linux_x64.tar inflating: OGG_BigData_12.3.0.1.0_Release_Notes.pdf inflating: OGG_BigData_12.3.0.1_README.txt [oracle@edvmr1p0 oggtrg]$ tar xvf ggs_Adapters_Linux_x64.tar <- Unzip the handlers AdapterExamples/ .....................................
Configure Source
The source is standard Oracle Golen Gate 12c and it just extract from a schema: oggsrc and send data to the replicat in a normal / standard way:
Configuration
GGSCI (edvmr1p0) 10> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING DPUMP 00:00:00 00:00:06 EXTRACT RUNNING PRIEX 00:00:10 00:00:06 GGSCI (edvmr1p0) 11> view param mgr PORT 7809 DynamicPortList 20000-20099 ACCESSRULE, PROG SERVER, ALLOW PurgeOldExtracts ./dirdat/*, UseCheckPoints, MinKeepHours 2 Autostart Extract * AUTORESTART Extract *, WaitMinutes 1, Retries 3 GGSCI (edvmr1p0) 12> view param DPUMP Extract dpump SETENV (ORACLE_SID='orcl') SETENV (ORACLE_HOME='/u01/app/oracle/product/12.1.0.2/db_1') UserIdAlias oggadmin rmthost remotehost, mgrport 7909 rmttrail ./dirdat/dp Table oggsrc.*; GGSCI (edvmr1p0) 13> view param PRIEX Extract priex SETENV (ORACLE_SID='orcl') SETENV (ORACLE_HOME='/u01/app/oracle/product/12.1.0.2/db_1') UserIdAlias oggadmin TranlogOptions IntegratedParams (max_sga_size 256) Exttrail ./dirdat/in LOGALLSUPCOLS UPDATERECORDFORMAT COMPACT GETUPDATEBEFORES Table oggsrc.*;
Commands to be executed
start mgr dblogin useridalias oggadmin register extract priex database add extract priex, integrated tranlog, begin now add exttrail ./dirdat/in, extract priex, megabytes 10 add extract dpump, exttrailsource ./dirdat/in add rmttrail ./dirdat/dp, extract dpump, megabytes 10 start priex start dpump