Table of Contents

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