{"id":5468,"date":"2015-09-07T09:43:21","date_gmt":"2015-09-07T07:43:21","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/"},"modified":"2015-09-07T09:43:21","modified_gmt":"2015-09-07T07:43:21","slug":"using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/","title":{"rendered":"Using GoldenGate event actions to suspend replication for end of day reporting"},"content":{"rendered":"<p>The last post in this series outlined on how to do an initial load of the target database using the &#8220;expdp\/impdp&#8221; method:<\/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<\/ul>\n<p>In this post I&#8217;ll look into how to use event actions to suspend GoldenGate replication for end of day reporting. This is common scenario in many companies: Lets say the business day ends at 18:00 and starting 18:00 reporting shall start on the replicated database. As the reporting job(s) require(s) the data as it was at 18:00 GoldenGate replication shall be suspended for the time of reporting and restarted once reporting finished.<\/p>\n<p>For the replication setup I&#8217;ll use the configuration of the <a href=\"http:\/\/dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-2-expdpimpdp\/\" target=\"_blank\" rel=\"noopener\">last post<\/a>. No need to re-setup replication as it is already running.<\/p>\n<p>What we need to fulfill the above requirement is an <a href=\"https:\/\/docs.oracle.com\/goldengate\/1212\/gg-winux\/GWUAD\/wu_customcode.htm#GWUAD622\" target=\"_blank\" rel=\"noopener\">event marker<\/a> that raises an event (in this case suspend the replication). The easiest method for doing this is to create a so called event_table. So, lets do this.<\/p>\n<p>As we want the event_table to be replicated we&#8217;ll need to make sure that GoldenGate knows about our table. For achieving this we&#8217;ll stop all extract processes on the source database:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com) 1&gt; stop extract *\n\nSending STOP request to EXTRACT DPPUMP1 ...\nRequest processed.\n\nSending STOP request to EXTRACT EXTRCDC1 ...\nRequest processed.\n\nGGSCI (oelgg1.it.dbi-services.com) 3&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nEXTRACT     STOPPED     DPPUMP1     00:00:00      00:00:15    \nEXTRACT     STOPPED     EXTRCDC1    00:00:08      00:00:14    \n<\/pre>\n<p>On the target database stop the replicat process:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com) 4&gt; stop replicat *\n\nSending STOP request to REPLICAT REPLCDD ...\nRequest processed.\n\nGGSCI (oelgg2.it.dbi-services.com) 6&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nREPLICAT    STOPPED     REPLCDD     00:00:00      00:00:05    \n<\/pre>\n<p>On both, the source and target database create our new event table:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; create table hr.events ( event varchar2(50), timestamp date );\n\nTable created.\n<\/pre>\n<p>On the source database we need to add supplemental log data to the table:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com) 1&gt; dblogin useridalias DB1 domain admin\nSuccessfully logged into database.\n\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 2&gt; add trandata hr.events\n\n2015-09-04 08:49:07  WARNING OGG-06439  No unique key is defined for table EVENTS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.\n\nLogging of supplemental redo data enabled for table HR.EVENTS.\nTRANDATA for scheduling columns has been added on table 'HR.EVENTS'.\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 3&gt; \n<\/pre>\n<p>Lets restart all extract and replicat processes and check if data gets replicated for the new event table. On the source:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 4&gt; start extract *\n\nSending START request to MANAGER ...\nEXTRACT DPPUMP1 starting\n\nSending START request to MANAGER ...\nEXTRACT EXTRCDC1 starting\n\n\nGGSCI (oelgg1.it.dbi-services.com as ggadmin@DB1) 5&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nEXTRACT     RUNNING     DPPUMP1     00:20:26      00:00:09    \nEXTRACT     RUNNING     EXTRCDC1    00:00:10      00:00:01    \n<\/pre>\n<p>And on the target:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com) 3&gt; start replicat *\n\nSending START request to MANAGER ...\nREPLICAT REPLCDD starting\n\n\nGGSCI (oelgg2.it.dbi-services.com) 4&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nREPLICAT    RUNNING     REPLCDD     00:00:00      00:00:05    \n<\/pre>\n<p>Verify if the new table is replicated by inserting a row on the source:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; insert into hr.events values ( 'TEST', sysdate );\n\n1 row created.\n\nSQL&gt; commit;\n\nCommit complete.\n\nSQL&gt; select instance_name from v$instance;\n\nINSTANCE_NAME\n----------------\nDB1\n<\/pre>\n<p>Lets check if the data is there on the target:<\/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.events;\n\nEVENT\t\t\t\t\t\t   TIMESTAMP\n-------------------------------------------------- ---------\nTEST\t\t\t\t\t\t   04-SEP-15\n<\/pre>\n<p>Cool. Our event_table is ready. Now we need to define an event action on that table. On the target system we add an addititional line to the parameter file of the replicat process so that the file looks like:<\/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.*;\nMAP hr.EVENTS, TARGET hr.EVENTS, FILTER (@STREQ (EVENT, 'SUSPEND REPLICAT' )), EVENTACTIONS (IGNORE TRANS,STOP);\n<\/pre>\n<p>For this to take effect we&#8217;ll need to restart the replicat:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com) 7&gt; stop replicat REPLCDD\n\nSending STOP request to REPLICAT REPLCDD ...\nRequest processed.\n\nGGSCI (oelgg2.it.dbi-services.com) 9&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nREPLICAT    STOPPED     REPLCDD     00:00:00      00:00:01    \n\nGGSCI (oelgg2.it.dbi-services.com) 10&gt; start replicat REPLCDD\n\nSending START request to MANAGER ...\nREPLICAT REPLCDD starting\n<\/pre>\n<p>Note: Always check the GoldenGate error log when you do modifications on the parameter files.<\/p>\n<p>Lets test if this works by inserting a row into the event_table on the source system that matches our filter:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; insert into hr.events values ('SUSPEND REPLICAT', sysdate);\n\n1 row created.\n\nSQL&gt; commit;\n\nCommit complete.\n<\/pre>\n<p>This should have triggered a stop request for the replicat:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com) 27&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nREPLICAT    RUNNING     REPLCDD     00:00:00      00:00:04    \n<\/pre>\n<p>Hm, does not look like the replicat stopped. Looking at the logfile this might be a hint:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n2015-09-07 11:20:18  WARNING OGG-02081  Oracle GoldenGate Delivery for Oracle, replcdd.prm:  Detected duplicate TABLE\/MAP entry for source table HR.EVENTS and target table hr.EVENTS. Using prior TABLE\/MAP specification.\n<\/pre>\n<p>So lets specify each table in the replicat instead of using a wildcard. The new parameter file for the replicat now looks like this:<\/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.COUNTRIES, TARGET hr.COUNTRIES;\nMAP hr.DEPARTMENTS, TARGET hr.DEPARTMENTS;\nMAP hr.EMPLOYEES, TARGET hr.EMPLOYEES;\nMAP hr.JOBS, TARGET hr.JOBS;\nMAP hr.JOB_HISTORY, TARGET hr.JOB_HISTORY;\nMAP hr.LOCATIONS, TARGET hr.LOCATIONS;\nMAP hr.REGIONS, TARGET hr.REGIONS;\nMAP hr.EVENTS, TARGET hr.EVENTS, FILTER (@STREQ (EVENT, 'SUSPEND REPLICAT' )), EVENTACTIONS (IGNORE TRANS,STOP);\n<\/pre>\n<p>Once the replicat is  restarted lets do the same test again by doing the insert on the source:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; insert into hr.events values ( 'SUSPEND REPLICAT', sysdate );\n\n1 row created.\n\nSQL&gt; commit;\n\nCommit complete.\n<\/pre>\n<p>Did it work now?<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com as ggadmin@DB2) 44&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nREPLICAT    STOPPED     REPLCDD     00:00:05      00:00:44    \n<\/pre>\n<p>Looks much better and the GoldenGate log file does confirm it:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n2015-09-07 11:27:24  WARNING OGG-01283  Oracle GoldenGate Delivery for Oracle, replcdd.prm:  Stopping process due to STOP event for target table HR.EVENTS in file .\/dirdat\/jj000009, RBA 2284 \tSTOP request pending end-of-transaction (1 records so far).\n2015-09-07 11:27:29  INFO    OGG-00994  Oracle GoldenGate Delivery for Oracle, replcdd.prm:  REPLICAT REPLCDD stopped normally.\n<\/pre>\n<p>Ready for end of day reporting &#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The last post in this series outlined on how to do an initial load of the target database using the &#8220;expdp\/impdp&#8221; method: 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 [&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-5468","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>Using GoldenGate event actions to suspend replication for end of day reporting - 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\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using GoldenGate event actions to suspend replication for end of day reporting\" \/>\n<meta property=\"og:description\" content=\"The last post in this series outlined on how to do an initial load of the target database using the &#8220;expdp\/impdp&#8221; method: 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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-07T07:43:21+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=\"6 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\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Using GoldenGate event actions to suspend replication for end of day reporting\",\"datePublished\":\"2015-09-07T07:43:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\"},\"wordCount\":499,\"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\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\",\"name\":\"Using GoldenGate event actions to suspend replication for end of day reporting - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2015-09-07T07:43:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using GoldenGate event actions to suspend replication for end of day reporting\"}]},{\"@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":"Using GoldenGate event actions to suspend replication for end of day reporting - 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\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/","og_locale":"en_US","og_type":"article","og_title":"Using GoldenGate event actions to suspend replication for end of day reporting","og_description":"The last post in this series outlined on how to do an initial load of the target database using the &#8220;expdp\/impdp&#8221; method: 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 [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/","og_site_name":"dbi Blog","article_published_time":"2015-09-07T07:43:21+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Using GoldenGate event actions to suspend replication for end of day reporting","datePublished":"2015-09-07T07:43:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/"},"wordCount":499,"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\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/","url":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/","name":"Using GoldenGate event actions to suspend replication for end of day reporting - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-09-07T07:43:21+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using GoldenGate event actions to suspend replication for end of day reporting"}]},{"@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\/5468","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=5468"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5468\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5468"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}