One-Way Replication with integrated Extract & Replicat (No DataPump)

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

Setup the Extract Process

• Create the Extract Parameter file

EXTRACT eit01

Userid ogg, password oracle

RMTHOST localhost, MGRPORT 7809

RMTTRAIL ./dirdat/ip

TABLE SRC.*;

• Add the Extract group. Login to Oracle DB first.

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

• Register the Extract Process (only for Integrated capture). 

GGSCI > register extract eit01 database

• Add Remote Trail file, and map it to the extract process

GGSCI > ADD RMTTRAIL ./dirdat/ip, EXTRACT eit01

Setup the Replicat Process

• Create the Replicat Parameter File

REPLICAT rit01

Userid ogg, password oracle

MAP SRC.*, TARGET TRG.*;

• Add the Replicat group

GGSCI > ADD REPLICAT rit01, INTEGRATED, EXTTRAIL ./dirdat/ip, CHECKPOINTTABLE ogg.chkpt, BEGIN NOW

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

Start Extract and Replicat Process

GGSCI > start extract eit01
GGSCI > start replicat rit01