Site icon IT Tutorial

Goldengate – Initial Load

Goldengate Replication – Oracle To Oracle

On existing installed goldengate replication structure;
Re-refresh of table with dblink.

#Source
FGPRO3

#Target
goldenfg01

#Target 
#Abended process and can not resolved problem
info BCK03A01 
REPLICAT ABENDED BCK03A01 01:53:37 02:05:17

#Target
GGSCI (goldenfg01) 41> VIEW PARAM BCK03A01
MAP POST_BILL.XX_STATUS, TARGET FGPRO3_POST_BILL.XX_STATUS; Size 246 MB

#Target
#Dblink to source is discovered
select * from dba_db_links where host like '%FG%' AND OWNER='FG_MAINTAIN';

#Target
#Current scn is find out with dblink
select CURRENT_SCN from v$database@FGPRO3;
--16104375781003

#Target
#Source table is backuped and truncate source table
create table FGPRO3_POST_BILL.XX_STATUS_ydk as select /*+parallel(32)*/ * from FGPRO3_POST_BILL.XX_STATUS;
truncate table FGPRO3_POST_BILL.XX_STATUS;

#Target
#Initial load is completed with selected scn from source database
insert into FGPRO3_POST_BILL.XX_STATUS
select /*+parallel(32)*/ * from POST_BILL.XX_STATUS@FGPRO3 as of scn 16104375781003;
commit;

#Target
#Replicat trail path is discovered.
GGSCI (goldenfg01) > view param BCK03A01
--ADD REPLICAT BCK03A01 EXTTRAIL /ggatea02/FGPRO3_122c/k3 CHECKPOINTTABLE GGS_ADMIN.GGSCHKPT

#Target
#Trails is listed on replicat trail path .
GGSCI (goldenfg01) > shell ls -lrt /ggatea02/FGPRO3_122c/k3*
-rw-r----- 1 ggate oinstall 599999849 May 2 16:38 /ggatea02/FGPRO3_122c/k3000017479
-rw-r----- 1 ggate oinstall 599999680 May 2 17:12 /ggatea02/FGPRO3_122c/k3000017480

#Target
#Replicat sequence and rba are set for first sequence
GGSCI (goldenfg01) > alter BCK03A01 extseqno 17479 extrba 0 
GGSCI (goldenfg01) > start replicat BCK03A01 aftercsn 16104375781003

#Target
#Replicat status is observed.
info all
stats BCK03A01
send BCK03A01 status
Exit mobile version