One-Way Replication with Integrated Extract and Integrated Replicat (with Data Pump)

Replication Type     : Uni-Directional (Reporting)
Extract             : Integrated
Replicat             : Integrated
Datapump     : Yes
ISERIDALIAS used   : No
Trail File Encrypted    : No

Setup Integrated Extract Process Group

• Create the extract parameter file

EXTRACT epi01
userid ogg, password oracle
EXTTRAIL ./dirdat/pi
TABLE SRC.*;

• Login to the database and add the Extract process

GGSCI > dblogin userid ogg, password oracle 
GGSCI > ADD EXTRACT epi01, INTEGRATED TRANLOG, BEGIN NOW

• Register the Extract Process (only for Integrated Extract)

GGSCI > register extract epi01 database

** It will take few seconds to register the extract and start the mining server.

• Add EXTTRAIL and map it to the extract process

GGSCI > ADD EXTTRAIL ./dirdat/pi, EXTRACT epi01

Setup Data Pump Process

• Create the Data Pump parameter file

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

• Add the Datapump Process

GGSCI > ADD EXTRACT ppi01, EXTTRAILSOURCE ./dirdat/pi, BEGIN NOW

• Add the Remote Trail file and map it the data pump process

GGSCI > ADD RMTTRAIL ./dirdat/ri, EXTRACT ppi01

Setup Replicat Process

• Create the Replicat Parameter file

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

• Add Replicat Process

GGSCI > ADD REPLICAT rpi01, Integrated, EXTTRAIL ./dirdat/ri, 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 epi01
GGSCI > start extract ppi01
GGSCI > start replicat rpi01