GoldenGate Initial load file to database utility|Oracle Goldengate initial load

source
========
hostname :192.168.1.200
db_name:PrimeDG
gg schema:gg_admin
source schema:src
table_name:supplier



Target
=======
hostname :192.168.1.201
db_name:CyclopDB
gg schema:gg_admin
source schema:src
table_name:supplier


first step for initial data load is golden gate manager should be up and running on target database and source database
connect to source
./ggsci
>info mgr

connect to target
go to golden gatehome directory
./ggsci
>info mgr

NOW CONNECT TO TARGET TO SEE IF THERE IS ANY RECORD
sqlplus / as sysdba
SQL>select count(*) from src.supplier

NOW CONNECT TO SOURCE  TO SEE IF THERE IS ANY RECORD
sqlplus / as sysdba
SQL>select count(*) from src.supplier
there are 3 record are there in schecma

NOW CONFIGURE FOR INITIAL LOAD
vi dirprm/inittext.prm
SOURCEISTABLE
setenv (ORACLE_SID=PrimeDG)
USERID gg_admin PASSWORD oracle
RMTHOST 192.168.1.201 MGRPORT 7810
FORMATASCII,SQLLOADER
RMTFILE ./dirdat/supplier.dat, MEGABYTES 2, PURGE
TABLE src.SUPPLIER;


NOW GO TO TARGET
vi dirprm/initrep.prm
GENLOADFILES sqlldr.tpl
setenv (ORACLE_SID=CyclopDB)
USERID gg_admin PASSWORD oracle
EXTFILE ./dirdat/supplier.dat
ASSUMETARGERDEFS
MAP SRC.SUPPLIER.TARGET SRC.SUPPLIER;



NOW RUN THE EXTRACT ON THE SOURCE
cd gg_home
./ggdci
history |grep extract
./extract paramfile dirprm/inittext.prm reportfile dirrpt/inittext.rpt

once job is completed view rpt file
vi dirrpt/inittext.rpt


GO TO TARGET SEE IF THIS FILE IS CREATED
cd gg_home
cd dirdat/
ls -altr
cat SUPPLIER.DAT

NOW RUN REPLICAT
history |grep replicat
./replicat paramfile dirprm/initrep,prm reportfile dirrpt/initrep.rpt
vi dirrpt/initrep.rpt

vi SUPPLIER..rpt
vi SUPPLIER.ctl

=======================================================
918050091413