{"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;]<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[328,96],"type_dbi":[],"class_list":["post-5423","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-goldengate","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Performing an initial load with GoldenGate (1) - file to replicat - dbi 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;]\" \/>\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 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-03T11:14:38+00:00\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\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\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"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,\"keywords\":[\"GoldenGate\",\"Oracle\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"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 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2015-09-03T11:14:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"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 Blog\",\"description\":\"\",\"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\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Performing an initial load with GoldenGate (1) - file to replicat - dbi 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;]","og_url":"https:\/\/www.dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/","og_site_name":"dbi Blog","article_published_time":"2015-09-03T11:14:38+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","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":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"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,"keywords":["GoldenGate","Oracle"],"articleSection":["Database Administration &amp; Monitoring"],"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 Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-09-03T11:14:38+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"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 Blog","description":"","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":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_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\/29"}],"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"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}