{"id":5423,"date":"2015-09-03T13:14:38","date_gmt":"2015-09-03T11:14:38","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/"},"modified":"2015-09-03T13:14:38","modified_gmt":"2015-09-03T11:14:38","slug":"performing-an-initial-load-with-goldengate-1-file-to-replicat","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/","title":{"rendered":"Performing an initial load with GoldenGate (1) &#8211; file to replicat"},"content":{"rendered":"<p>The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release.The second post explained how to create a sample replication with Oracle GoldenGate:<\/p>\n<ul>\n<li><a href=\"http:\/\/dbi-services.com\/blog\/installing-and-patching-oracle-goldengate-12c-to-the-latest-release\/\" target=\"_blank\" rel=\"noopener\">Installing and patching Oracle GoldenGate 12c to the latest release<\/a><\/li>\n<li><a href=\"http:\/\/dbi-services.com\/blog\/setting-up-a-sample-replication-with-goldengate\/\" target=\"_blank\" rel=\"noopener\">Setting up a sample replication with GoldenGate<\/a><\/li>\n<\/ul>\n<p>In this post I&#8217;ll look how to do an initial load using GoldenGate by using the &#8220;File to replicat&#8221; method (<a href=\"http:\/\/docs.oracle.com\/goldengate\/1212\/gg-winux\/GWUAD\/wu_initsync.htm#GWUAD546\" target=\"_blank\" rel=\"noopener\">several other methods are available<\/a>).<\/p>\n<p>To start from scratch I deleted all the configurations done in the <a href=\"\" target=\"_blank\" rel=\"noopener\">last post<\/a>.<\/p>\n<p>This time the goal is to initially load all the tables of the HR schema from DB1 to DB2 and start the replication afterwards. The default HR schema contains seven tables:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; select table_name from dba_tables where owner = 'HR' order by 1;\n\nTABLE_NAME\n-------------------\nCOUNTRIES\nDEPARTMENTS\nEMPLOYEES\nJOBS\nJOB_HISTORY\nLOCATIONS\nREGIONS\n\n7 rows selected.\n<\/pre>\n<p>To have only the table definitions and no data in the HR schema I&#8217;ll delete all records:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ndeclare\n  lv_statement varchar2(2000);\nbegin\n  for r in ( select c.CONSTRAINT_NAME, c.TABLE_NAME\n               from dba_constraints c\n                  , dba_tables t\n              where c.owner = 'HR'\n                and t.table_name = c.table_name\n                and t.owner = 'HR'\n                and c.constraint_type != 'P'\n           )\n  loop\n    lv_statement := 'alter table hr.'||r.TABLE_NAME||' disable constraint '||r.CONSTRAINT_NAME;\n    execute immediate lv_statement;\n  end loop;\n  for r in ( select table_name\n               from dba_tables\n              where owner = 'HR'\n           )\n  loop\n    execute immediate 'delete hr.'||r.table_name;\n  end loop;\n\/\nSQL&gt; select count(*) from hr.employees;\n\n  COUNT(*)\n----------\n\t 0\n\nSQL&gt; select count(*) from hr.jobs;\n\n  COUNT(*)\n----------\n\t 0\n<\/pre>\n<p>Note that I&#8217;ll leave the constraints disabled to avoid any issues when GoldenGate populates the tables later.<\/p>\n<p>As in the last post we need to execute the <a href=\"http:\/\/docs.oracle.com\/goldengate\/1212\/gg-winux\/GWURF\/ggsci_commands067.htm#GWURF268\" target=\"_blank\" rel=\"noopener\">ADD TRANDATA<\/a> command:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 7&gt; dblogin useridalias DB1 domain admin\nSuccessfully logged into database.\n\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 8&gt; add trandata HR.*\n\nLogging of supplemental redo data enabled for table HR.COUNTRIES.\nTRANDATA for scheduling columns has been added on table 'HR.COUNTRIES'.\nLogging of supplemental redo data enabled for table HR.DEPARTMENTS.\nTRANDATA for scheduling columns has been added on table 'HR.DEPARTMENTS'.\nLogging of supplemental redo data enabled for table HR.EMPLOYEES.\nTRANDATA for scheduling columns has been added on table 'HR.EMPLOYEES'.\nLogging of supplemental redo data enabled for table HR.JOBS.\nTRANDATA for scheduling columns has been added on table 'HR.JOBS'.\nLogging of supplemental redo data enabled for table HR.JOB_HISTORY.\nTRANDATA for scheduling columns has been added on table 'HR.JOB_HISTORY'.\nLogging of supplemental redo data enabled for table HR.LOCATIONS.\nTRANDATA for scheduling columns has been added on table 'HR.LOCATIONS'.\nLogging of supplemental redo data enabled for table HR.REGIONS.\nTRANDATA for scheduling columns has been added on table 'HR.REGIONS'.\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 9&gt; \n<\/pre>\n<p>In real life environments there will probably be ongoing transactions while the initial load of the target database happens. To be able to re-synchronize these changes we need to configure change data capture.<\/p>\n<p>On the source system, as usual, we&#8217;ll need an extract:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com) 3&gt; edit params extrcdc1\n<\/pre>\n<p>The parameters are:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nEXTRACT extrcdc1\nUSERIDALIAS DB1 domain admin\nEXTTRAIL .\/dirdat\/gg\nLOGALLSUPCOLS\nUPDATERECORDFORMAT compact\nTABLE hr.*;\nTABLEEXCLUDE HR.EMP_DETAILS_VIEW;\n<\/pre>\n<p>The remaining steps on the source database are the same as in the last post:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com) 4&gt; dblogin useridalias DB1 domain admin\n\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 5&gt; register extract extrcdc1 database\nExtract EXTRCDC1 successfully registered with database at SCN 1863433.\n\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 6&gt; add extract extrcdc1, integrated tranlog, begin now\nEXTRACT added.\n\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 7&gt; add exttrail .\/dirdat\/gg, extract extrcdc1, megabytes 5\nEXTTRAIL added.\n<\/pre>\n<p>Configure the datapump:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 10&gt; edit params dppump1\n<\/pre>\n<p>The parameters are:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nEXTRACT dppump1\nPASSTHRU\nRMTHOST oelgg2, MGRPORT 7809\nRMTTRAIL .\/dirdat\/jj\nTABLE hr.*;\nTABLEEXCLUDE HR.EMP_DETAILS_VIEW;\n<\/pre>\n<p>Start the datapump:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 12&gt; add extract dppump1, exttrailsource .\/dirdat\/gg\nEXTRACT added.\n\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 13&gt; add rmttrail .\/dirdat\/jj, extract dppump1, megabytes 5\nRMTTRAIL added.\n\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 23&gt; start extract *\n\nSending START request to MANAGER ...\nEXTRACT DPPUMP1 starting\n\nSending START request to MANAGER ...\nEXTRACT EXTRCDC1 starting\n\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 24&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nEXTRACT     RUNNING     DPPUMP1     00:00:00      00:00:02    \nEXTRACT     RUNNING     EXTRCDC1    00:00:07      00:00:07    \n\n<\/pre>\n<p>The next step if to configure the change delivery on the target system:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com as ggadmin@DB2) 26&gt; edit params rplcdd\n<\/pre>\n<p>The parameters are:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nREPLICAT replcdd\nASSUMETARGETDEFS\nDISCARDFILE .\/dirrpt\/replccd.dsc, purge\nUSERIDALIAS DB2 domain admin\nMAP hr.*, TARGET hr.*;\n<\/pre>\n<p>Configure the replicat:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com) 1&gt; dblogin useridalias DB2 domain admin\nSuccessfully logged into database.\n\nGGSCI (oelgg2.it.dbi-services.com as ggadmin@DB2) 2&gt; add replicat replcdd, integrated, exttrail .\/dirdat\/jj\nREPLICAT (Integrated) added.\n<\/pre>\n<p>We will not start the replicat right now as we wan to do the initial load before.<\/p>\n<p>Now it is time to get the current scn of the source database:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; select current_scn from v$database;\n\nCURRENT_SCN\n-----------\n    1909670\n<\/pre>\n<p>The next step is to create the extract process parameter file:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 10&gt; edit params INITLOAD\n<\/pre>\n<p>The parameters for the file are:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nEXTRACT initload\nSOURCEISTABLE\nUSERIDALIAS DB1 domain admin\nRMTHOST oelgg2, MGRPORT 7809\nRMTFILE .\/dirdat\/initld, MEGABYTES 2, PURGE\nTABLE HR.*, SQLPREDICATE 'AS OF SCN 1909670';\nTABLEEXCLUDE HR.EMP_DETAILS_VIEW;\n<\/pre>\n<p>Lets create the extract group:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com) 2&gt; add extract initload, sourceistable\nEXTRACT added.\n<\/pre>\n<p>The <a href=\"http:\/\/docs.oracle.com\/goldengate\/1212\/gg-winux\/GWURF\/gg_parameters151.htm#GWURF656\" target=\"_blank\" rel=\"noopener\">sourceistable<\/a> parameter tells GoldenGate to extract the data directly from the tables for the initial load.<\/p>\n<p>Now we can start the extract process:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 30&gt; start extract initload\n\nSending START request to MANAGER ...\nEXTRACT INITLOAD starting\n<\/pre>\n<p>This will start the extract and stop automatically once completed. You can get a report on what happened with:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 36&gt; view report initload\n<\/pre>\n<p>On the target system add the replicat:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com) 3&gt; add replicat rload1, specialrun\n<\/pre>\n<p>The parameters for rload1 are:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nREPLICAT rload1\t \t \nUSERIDALIAS DB2 domain admin\t \t \nSPECIALRUN\t \t \nEND RUNTIME\t \t\nASSUMETARGETDEFS\t \t \nEXTFILE .\/dirdat\/initld\t \t \nMAP hr.*, TARGET hr.*;\t \t \nTABLEEXCLUDE HR.EMP_DETAILS_VIEW\n<\/pre>\n<p>The &#8220;SPECIALRUN&#8221; and &#8220;END RUNTIME&#8221; tell GoldenGate that this is a one time batch task.<br \/>\nThe &#8220;TABLEEXCLUDE&#8221; parameter excludes the View &#8220;HR.EMP_DETAILS_VIEW&#8221; as we do not want to get the view populated. <\/p>\n<p>Lets see if we can load the data on the target system:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com) 3&gt; start replicat rload1\n<\/pre>\n<p>It is advisable to tail the GoldenGate log in a separate session while the load is running. If everything is fine it should look similar to this:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n...\n2015-09-03 11:14:17  INFO    OGG-06510  Oracle GoldenGate Delivery for Oracle, rload1.prm:  Using the following key columns for target table HR.JOB_HISTORY: EMPLOYEE_ID, START_DATE.\n2015-09-03 11:14:17  INFO    OGG-06506  Oracle GoldenGate Delivery for Oracle, rload1.prm:  Wildcard MAP resolved (entry hr.*): MAP \"HR\".\"LOCATIONS\", TARGET hr.\"LOCATIONS\".\n2015-09-03 11:14:17  INFO    OGG-06511  Oracle GoldenGate Delivery for Oracle, rload1.prm:  Using following columns in default map by name: LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE, COUNTRY_ID.\n2015-09-03 11:14:17  INFO    OGG-06510  Oracle GoldenGate Delivery for Oracle, rload1.prm:  Using the following key columns for target table HR.LOCATIONS: LOCATION_ID.\n2015-09-03 11:14:17  INFO    OGG-06506  Oracle GoldenGate Delivery for Oracle, rload1.prm:  Wildcard MAP resolved (entry hr.*): MAP \"HR\".\"REGIONS\", TARGET hr.\"REGIONS\".\n2015-09-03 11:14:18  INFO    OGG-06511  Oracle GoldenGate Delivery for Oracle, rload1.prm:  Using following columns in default map by name: REGION_ID, REGION_NAME.\n2015-09-03 11:14:18  INFO    OGG-06510  Oracle GoldenGate Delivery for Oracle, rload1.prm:  Using the following key columns for target table HR.REGIONS: REGION_ID.\n2015-09-03 11:14:18  INFO    OGG-00994  Oracle GoldenGate Delivery for Oracle, rload1.prm:  REPLICAT RLOAD1 stopped normally.\n<\/pre>\n<p>Lets check if the data is really there:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; select instance_name from v$instance;\n\nINSTANCE_NAME\n----------------\nDB2\n\nSQL&gt; select count(*) from hr.employees;\n\n  COUNT(*)\n----------\n       107\n<\/pre>\n<p>Looks fine. The data is now available up to SCN 1909670. Now we need to make sure that the data after this SCN will be synchronized. Before starting the synchronization lets update some data in the source database:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nSQL&gt; update hr.countries set COUNTRY_NAME = 'Zimbabwe2' where COUNTRY_NAME = 'Zimbabwe';\n\n1 row updated.\n\nSQL&gt; commit;\n\nCommit complete.\n<\/pre>\n<p>Time to start the replicat on the target database:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com as ggadmin@DB2) 18&gt; start replicat replcdd, aftercsn 1909670\n\nSending START request to MANAGER ...\nREPLICAT REPLCDD starting\n\nGGSCI (oelgg2.it.dbi-services.com) 3&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nREPLICAT    RUNNING     REPLCDD     00:00:00      00:00:06    \n<\/pre>\n<p>If everything works as expected we should see the row we updated just before:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; select instance_name from v$instance;\n\nINSTANCE_NAME\n----------------\nDB2\n\nSQL&gt; select * from hr.countries where COUNTRY_NAME like '%Zimbabwe%';\n\nCO COUNTRY_NAME \t\t\t     REGION_ID\n-- ---------------------------------------- ----------\nZW Zimbabwe2\t\t\t\t\t     4\n\n<\/pre>\n<p>Works like a charm. In the next post I&#8217;ll look into how to do the same but populating the target database with expdp\/impdp instead of the GoldenGate file to replicat method.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release.The second post explained how to create a sample replication with Oracle GoldenGate: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate In this post I&#8217;ll look how to&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[],"class_list":["post-5423","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Performing an initial load with GoldenGate (1) - file to replicat - dbi services | Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performing an initial load with GoldenGate (1) - file to replicat\" \/>\n<meta property=\"og:description\" content=\"The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release.The second post explained how to create a sample replication with Oracle GoldenGate: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate In this post I&#8217;ll look how to&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-03T11:14:38+00:00\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/performing-an-initial-load-with-goldengate-1-file-to-replicat\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/performing-an-initial-load-with-goldengate-1-file-to-replicat\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"Performing an initial load with GoldenGate (1) &#8211; file to replicat\",\"datePublished\":\"2015-09-03T11:14:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/performing-an-initial-load-with-goldengate-1-file-to-replicat\\\/\"},\"wordCount\":551,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/performing-an-initial-load-with-goldengate-1-file-to-replicat\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/performing-an-initial-load-with-goldengate-1-file-to-replicat\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/performing-an-initial-load-with-goldengate-1-file-to-replicat\\\/\",\"name\":\"Performing an initial load with GoldenGate (1) - file to replicat - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2015-09-03T11:14:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/performing-an-initial-load-with-goldengate-1-file-to-replicat\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/performing-an-initial-load-with-goldengate-1-file-to-replicat\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/performing-an-initial-load-with-goldengate-1-file-to-replicat\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performing an initial load with GoldenGate (1) &#8211; file to replicat\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"caption\":\"Open source Team\"},\"description\":\"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Performing an initial load with GoldenGate (1) - file to replicat - dbi services | Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/","og_locale":"en_US","og_type":"article","og_title":"Performing an initial load with GoldenGate (1) - file to replicat","og_description":"The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release.The second post explained how to create a sample replication with Oracle GoldenGate: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate In this post I&#8217;ll look how to&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2015-09-03T11:14:38+00:00","author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"Performing an initial load with GoldenGate (1) &#8211; file to replicat","datePublished":"2015-09-03T11:14:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/"},"wordCount":551,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/","url":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/","name":"Performing an initial load with GoldenGate (1) - file to replicat - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-09-03T11:14:38+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Performing an initial load with GoldenGate (1) &#8211; file to replicat"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","caption":"Open source Team"},"description":"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.","url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5423","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5423"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5423\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}