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