Unidirectional (One-Way) - Oracle-to-Oracle Data replication using Oracle Goldengate

Unidirectional (One-Way) - Oracle-to-Oracle Data replication 
using Oracle Goldengate

• Replication Type          : Uni-Directional (Reporting)
• Extract                  : Classic
• Replicat                  : Non-integrated (Classic)
• Datapump          : Yes
• ISERIDALIAS used  : No
• Trail File Encrypted  : No

** Please make sure that the Database and schema/Table level logging (such as Force logging, DB supplemental logging, Enabling Trandata) is set appropriately.

 

• Configure Extract Process

·       Extract parameter file

EXTRACT ept02
Userid ogg, password oracle
EXTTRAIL ./dirdat/ep
TABLE SRC.*;

 

·       Add Extract

GGSCI > ADD EXTRACT ept02, TRANLOG, BEGIN NOW

ADD Trail File and map it to the extract process

GGSCI > ADD EXTTRAIL ./dirdat/ep, EXTRACT ept02

 

• Configure DataPump Process

·       Create the parameter file for data pump

EXTRACT pxt02
Userid ogg, password oracle
RMTHOST localhost, MGRPORT 7809
RMTTRAIL ./dirdat/rp
TABLE SRC.*;

 

·       Add the data pump process

GGSCI > ADD extract pxt02, EXTTRAILSOURCE ./dirdat/ep, BEGIN NOW 

·       Add the Remote trail file and map it to the pump process

GGSCI > ADD RMTTRAIL ./dirdat/rp, EXTRACT pxt02

 

• Configure Replicat Process

·       Create the parameter file for Replicat

REPLICAT rpp02
Userid ogg, password oracle
MAP SRC.*, TARGET TRG.*;

 

·       Add the Replicat process

GGSCI > ADD REPLICAT rpp02, EXTTRAIL ./dirdat/rp, CHECKPOINTTABLE ogg.chkpt, BEGIN now

** EXTTRAIL should be the trail file location on the target server.

·       Start Extract, Data Pump and Replicat Process

GGSCI > start extract ext02

GGSCI > start extract pxt02

GGSCI > start replicat rct02