{"id":5471,"date":"2015-09-08T04:40:33","date_gmt":"2015-09-08T02:40:33","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/"},"modified":"2015-09-08T04:40:33","modified_gmt":"2015-09-08T02:40:33","slug":"if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","title":{"rendered":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?"},"content":{"rendered":"<p>This is the next post on this GoldenGate series:<\/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<li><a href=\"http:\/\/dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/\" target=\"_blank\" rel=\"noopener\">Performing an initial load with GoldenGate (1) \u2013 file to replicat<\/a><\/li>\n<li><a href=\"http:\/\/dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-2-expdpimpdp\/\" target=\"_blank\" rel=\"noopener\">Performing an initial load with GoldenGate (2) \u2013 expdp\/impdp<\/a><\/li>\n<li><a href=\"http:\/\/dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\" target=\"_blank\" rel=\"noopener\">Using GoldenGate event actions to suspend replication for end of day reporting<\/a><\/li>\n<\/ul>\n<p>One question that pops up when stopping the replication by using an <a href=\"https:\/\/docs.oracle.com\/goldengate\/1212\/gg-winux\/GWUAD\/wu_customcode.htm#GWUAD622\" target=\"_blank\" rel=\"noopener\">event marker<\/a> is: What happens to the transactions that are running when the event occurs? Can we be sure that all transactions that are running when the event occurs are replicated to the target once they are committed? Or does the replication stop immediately?<\/p>\n<p>For the test setup I created a new table in the HR schema and added it to the GoldenGate replication the same way as the event table in the <a href=\"http:\/\/dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\" target=\"_blank\" rel=\"noopener\">last post<\/a>. The definition of the table is:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; desc hr.dummy_insert\n Name\t\t\t\t\t   Null?    Type\n ----------------------------------------- -------- ----------------------------\n A\t\t\t\t\t\t    NUMBER(38)\n B\t\t\t\t\t\t    VARCHAR2(50)\n C\t\t\t\t\t\t    DATE\n<\/pre>\n<p>The script to populate the test table is:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ndeclare\n  ln_count pls_integer := 1000000;\nbegin\n  for i in 1..ln_count\n  loop\n    insert into hr.dummy_insert (a,b,c)\n           values ( i, lpad(i,50,'A'), sysdate );\n  end loop;\nend;\n\/\ncommit;\n<\/pre>\n<p>On my test environment this will run long enough to insert the event into the event table in a separate session while the inserts are running. So in the first session I&#8217;ll start the data load and in the second session immediately afterwards I&#8217;ll send the event to stop the replicat on the target.<\/p>\n<p>Session 1 (on the source):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; @do_inserts.sql\n<\/pre>\n<p>Session 2 (on the source, 1 one or two seconds later);<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; insert into hr.events values ( 'SUSPEND REPLICATION', sysdate );\n\n1 row created.\n\nSQL&gt; commit;\n\nCommit complete.\n<\/pre>\n<p>What is the status of the replicat on the target?<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com as ggadmin@DB2) 68&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nREPLICAT    STOPPED     REPLCDD     00:00:05      00:01:15    \n<\/pre>\n<p>This is as expected. How many rows do we have in the target table?<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; select count(*) from hr.dummy_insert;\n\n  COUNT(*)\n----------\n\t 0\n\nSQL&gt; \n<\/pre>\n<p>Hm. Not good. This means when we stop the replicat on the target and there are ongoing transactions on the source they will not be written to the database. They are written to the trail files though (check the Goldengate log file):<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n2015-09-07 13:36:35  INFO    OGG-01670  Oracle GoldenGate Collector for Oracle:  Closing .\/dirdat\/jj000127.\n2015-09-07 13:36:35  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening .\/dirdat\/jj000128 (byte -1, current EOF 0).\n2015-09-07 13:36:35  INFO    OGG-01735  Oracle GoldenGate Collector for Oracle:  Synchronizing .\/dirdat\/jj000128 to disk.\n2015-09-07 13:36:35  INFO    OGG-01971  Oracle GoldenGate Collector for Oracle:  The previous message, 'INFO OGG-01735', repeated 1 times.\n2015-09-07 13:36:35  INFO    OGG-01670  Oracle GoldenGate Collector for Oracle:  Closing .\/dirdat\/jj000128.\n2015-09-07 13:36:35  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening .\/dirdat\/jj000129 (byte -1, current EOF 0).\n<\/pre>\n<p>Once you restart the replicat the transaction will be replayed:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com as ggadmin@DB2) 78&gt; start replicat REPLCDD\n\nSending START request to MANAGER ...\nREPLICAT REPLCDD starting\n<\/pre>\n<p>After some time the rows will be there on the target:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; select count(*) from hr.dummy_insert;\n\n  COUNT(*)\n----------\n   1000000\n\nSQL&gt; \n<\/pre>\n<p>But this is not sufficient if the end of day reporting depends on all transactions that are started (but not completed) when the event to stop replication is send. Currently I do not have a solution for this. According to Oracle support the only solution to automatically achieve this is to use <a href=\"http:\/\/www.oracle.com\/us\/products\/middleware\/data-integration\/goldengate\/veridata\/overview\/index.html\" target=\"_blank\" rel=\"noopener\">GoldenGate Veridata<\/a> which must be separately licensed. If anybody had the same issue and solved it somehow I&#8217;d be happy to hear about it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) \u2013 file to replicat Performing an initial load with GoldenGate (2) \u2013 expdp\/impdp Using GoldenGate event actions to suspend replication for end [&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-5471","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>If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? - 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\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?\" \/>\n<meta property=\"og:description\" content=\"This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) \u2013 file to replicat Performing an initial load with GoldenGate (2) \u2013 expdp\/impdp Using GoldenGate event actions to suspend replication for end [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-08T02:40:33+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=\"3 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\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?\",\"datePublished\":\"2015-09-08T02:40:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/\"},\"wordCount\":410,\"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\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/\",\"name\":\"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2015-09-08T02:40:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?\"}]},{\"@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":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? - 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\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","og_locale":"en_US","og_type":"article","og_title":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?","og_description":"This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) \u2013 file to replicat Performing an initial load with GoldenGate (2) \u2013 expdp\/impdp Using GoldenGate event actions to suspend replication for end [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","og_site_name":"dbi Blog","article_published_time":"2015-09-08T02:40:33+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?","datePublished":"2015-09-08T02:40:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/"},"wordCount":410,"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\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","url":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","name":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-09-08T02:40:33+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?"}]},{"@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\/5471","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=5471"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5471\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5471"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}