Ask Me

Golden gate Initial Load Setup

  ####################################################################################

Method 1 – File to Replicat Keeping Note both source and target having similar structure of objects .

   1. *.Create parameter file for extracting tables.

      *. Run the extract which will create dumps in remote location directly

   2. Create paramter file for replicate separately for each table.

####################################################################################

[oracle@ora12c1 dirprm]$ cat initload.prm

SOURCEISTABLE

USERIDALIAS oggsrc

RMTHOST ora12c1.localdomain MGRPORT 7909

RMTFILE ./dirdat/ECONOMIC_ENTITY.DAT, PURGE

TABLE ogg1.east.ECONOMIC_ENTITY;

RMTFILE ./dirdat/GDP_BY_YEAR.DAT, PURGE

TABLE ogg1.east.GDP_BY_YEAR;

[oracle@ora12c1 dirprm]$

[oracle@ora12c1 ogg_src]$ ./extract paramfile dirprm/initload.prm reportfile dirrpt/initload.rpt

[oracle@ora12c1 dirdat]$ ls -lrt

total 332

-rw-r-----. 1 oracle dba    116 Aug  7 13:59 reast.dsc

-rw-r-----. 1 oracle dba 223518 Aug  7 16:25 PP000000000

-rw-r-----. 1 oracle dba  24191 Aug  7 16:40 ECONOMIC_ENTITY.DAT

-rw-r-----. 1 oracle dba  85105 Aug  7 16:40 GDP_BY_YEAR.DAT

[oracle@ora12c1 dirdat]$


*********Replicat END

[oracle@ora12c1 ogg_trg]$ cat dirprm/loadinit.prm

SPECIALRUN

END RUNTIME

USERIDALIAS oggtrg

ASSUMETARGETDEFS

EXTFILE ./dirdat/ECONOMIC_ENTITY.DAT

MAP OGG1.east.ECONOMIC_ENTITY, target OGG2.west.ECONOMIC_ENTITY;

[oracle@ora12c1 ogg_trg]$

[oracle@ora12c1 dirprm]$ cat loadinit1.prm

SPECIALRUN

END RUNTIME

USERIDALIAS oggtrg

ASSUMETARGETDEFS

EXTFILE ./dirdat/GDP_BY_YEAR.DAT

MAP OGG1.east.GDP_BY_YEAR, target OGG2.west.GDP_BY_YEAR;

[oracle@ora12c1 dirprm]$


[oracle@ora12c1 ogg_trg]$  ./replicat paramfile dirprm/loadinit.prm reportfile dirrpt/loadinint.rpt

[oracle@ora12c1 ogg_trg]$  ./replicat paramfile dirprm/loadinit1.prm reportfile dirrpt/loadinint1.rpt


**********************************
Check the tables row count .


####################################################################################

Method 2 :Direct LoadKeeping Note both source and target having similar structure of objects .

  1. *.Create parameter file for extracting tables and add

      *. Run the extract which will create dumps in remote location directly

   2. Create paramter file for replicate separately and run replicat .

####################################################################################

GGSCI (ora12c1.localdomain) 2> view param indrload.prm

SOURCEISTABLE

USERIDALIAS oggsrc

RMTHOST ora12c1.localdomain, MGRPORT 7909

RMTFILE ./dirdat/ECONOMIC_ENTITY.DAT, PURGE

TABLE ogg1.east.ECONOMIC_ENTITY;

RMTFILE ./dirdat/GDP_BY_YEAR.DAT, PURGE

TABLE ogg1.east.GDP_BY_YEAR;

GGSCI (ora12c1.localdomain) 13> add extract indrload , SOURCEISTABLE

ERROR: EXTRACT INDRLOAD already exists.


GGSCI (ora12c1.localdomain) 3>

GGSCI (ora12c1.localdomain) 5> view param loaddr

replicat loaddr

ASSUMETARGETDEFS

USERIDALIAS oggtrg

DISCARDFILE ./dirdat/loaddr.dsc, purge

MAP OGG1.east.*, target OGG2.west.*;

GGSCI (ora12c1.localdomain) 6> add replicat loaddr, SPECIALRUN

REPLICAT added.

GGSCI (ora12c1.localdomain) 7>start loaddr

Popular Posts