{"id":13150,"date":"2019-12-01T21:19:17","date_gmt":"2019-12-01T21:19:17","guid":{"rendered":"https:\/\/ittutorial.org\/?p=13150"},"modified":"2019-12-05T21:20:26","modified_gmt":"2019-12-05T21:20:26","slug":"goldengate-initial-load","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/goldengate-initial-load\/","title":{"rendered":"Goldengate &#8211; Initial Load"},"content":{"rendered":"<p>Goldengate Replication &#8211; Oracle To Oracle<\/p>\n<p>On existing installed goldengate replication structure;<br \/>\nRe-refresh of table with dblink.<\/p>\n<pre>#Source\r\nFGPRO3\r\n\r\n#Target\r\ngoldenfg01\r\n\r\n#Target \r\n#Abended process and can not resolved problem\r\ninfo BCK03A01 \r\nREPLICAT ABENDED BCK03A01 01:53:37 02:05:17\r\n\r\n#Target\r\nGGSCI (goldenfg01) 41&gt; VIEW PARAM BCK03A01\r\nMAP POST_BILL.XX_STATUS, TARGET FGPRO3_POST_BILL.XX_STATUS; Size 246 MB\r\n\r\n#Target\r\n#Dblink to source is discovered\r\nselect * from dba_db_links where host like '%FG%' AND OWNER='FG_MAINTAIN';\r\n\r\n#Target\r\n#Current scn is find out with dblink\r\nselect CURRENT_SCN from v$database@FGPRO3;\r\n--16104375781003\r\n\r\n#Target\r\n#Source table is backuped and truncate source table\r\ncreate table FGPRO3_POST_BILL.XX_STATUS_ydk as select \/*+parallel(32)*\/ * from FGPRO3_POST_BILL.XX_STATUS;\r\ntruncate table FGPRO3_POST_BILL.XX_STATUS;\r\n\r\n#Target\r\n#Initial load is completed with selected scn from source database\r\ninsert into FGPRO3_POST_BILL.XX_STATUS\r\nselect \/*+parallel(32)*\/ * from POST_BILL.XX_STATUS@FGPRO3 as of scn 16104375781003;\r\ncommit;\r\n\r\n#Target\r\n#Replicat trail path is discovered.\r\nGGSCI (goldenfg01) &gt; view param BCK03A01\r\n--ADD REPLICAT BCK03A01 EXTTRAIL \/ggatea02\/FGPRO3_122c\/k3 CHECKPOINTTABLE GGS_ADMIN.GGSCHKPT\r\n\r\n#Target\r\n#Trails is listed on replicat trail path .\r\nGGSCI (goldenfg01) &gt; shell ls -lrt \/ggatea02\/FGPRO3_122c\/k3*\r\n-rw-r----- 1 ggate oinstall 599999849 May 2 16:38 \/ggatea02\/FGPRO3_122c\/k3000017479\r\n-rw-r----- 1 ggate oinstall 599999680 May 2 17:12 \/ggatea02\/FGPRO3_122c\/k3000017480\r\n\r\n#Target\r\n#Replicat sequence and rba are set for first sequence\r\nGGSCI (goldenfg01) &gt; alter BCK03A01 extseqno 17479 extrba 0 \r\nGGSCI (goldenfg01) &gt; start replicat BCK03A01 aftercsn 16104375781003\r\n\r\n#Target\r\n#Replicat status is observed.\r\ninfo all\r\nstats BCK03A01\r\nsend BCK03A01 status<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Goldengate Replication &#8211; 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&gt; VIEW PARAM BCK03A01 MAP POST_BILL.XX_STATUS, TARGET FGPRO3_POST_BILL.XX_STATUS; Size 246 MB #Target #Dblink to source is &hellip;<\/p>\n","protected":false},"author":10449,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2465,1994],"tags":[3935,7063,1120],"class_list":["post-13150","post","type-post","status-publish","format-standard","","category-goldengate","category-oracle","tag-goldengate","tag-initial-load","tag-oracle"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/13150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/10449"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=13150"}],"version-history":[{"count":3,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/13150\/revisions"}],"predecessor-version":[{"id":13229,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/13150\/revisions\/13229"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=13150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=13150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=13150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}