Oracle Goldengate의 initial data load

1. configure the initial load extract parameter file (source)

     GGSCI> edit param eload01

      sourceistable

      userid oggmgr, password oracle
      rmthost oggtest.localdomain, mgrport 5009
      rmtfile ./dirdat/TCUSTMER.dat, purge
      table scott.tcustmer;
      rmtfile ./dirdat/TCUSTORD.dat, purge
      table scott.tcustord;

2. Execute the initial load capture process (source)

     # extract paramfile dirprm/eload01.prm reportfile dirrpt/ELOD01.rpt

     # ggsci

     GGSCI> view report ELOD01

3. configure the initial load delivery parameter file (target)

     # ls -al ./dirdat/TCUST*.dat

     # ggsci

     GGSCI> edit param loadtcustmer

      specialrun
      end runtime
      userid oggmgr, password oracle
      assumetargetdefs
      extfile ./dirdat/TCUSTMER.dat
      map scott.tcustmer, target scott.tcustmer;

      GGSCI> edit param loadtcustord

      specialrun
      end runtime
      userid oggmgr, password oracle
      assumetargetdefs
      extfile ./dirdat/TCUSTORD.dat
      map scott.tcustord, target scott.tcustord;

4. execute the initial load delivery process

     # replicat paramfile dirprm/loadtcustmer.prm reportfile dirrpt/LOADTCUSTMER.rpt

     # replicat paramfile dirprm/loadtcustord.prm reportfile dirrpt/LOADTCUSTORD.rpt

     # ggsci

     GGSCI> view report LOADTCUSTMER

     GGSCI> view report LOADTCUSTORD