{"id":2735,"date":"2012-08-29T00:50:00","date_gmt":"2012-08-28T22:50:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/"},"modified":"2012-08-29T00:50:00","modified_gmt":"2012-08-28T22:50:00","slug":"adding-new-tables-to-an-existing-oracle-goldengate-replication","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/","title":{"rendered":"Adding new tables to an existing Oracle GoldenGate replication"},"content":{"rendered":"<p>Once a replication environment is set up, it&#8217;s rarely forever. Adding tables to\u00a0an Oracle GoldenGate replication group with minimal impact to the current replication is quite\u00a0a difficult operation. This posting should help you with this task.<\/p>\n<p>In the example below, tables from schema G001 will be added to an existing replication setup from the database PROD1 to REP1.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">CFG_ADV_COND\nCFG_NARRATIVE_TEMPLATE\nCFG_REG_REPORT_RULES\nCMN_LOOKUP\nCMN_USER_LOGIN<\/pre>\n<p>&nbsp;<\/p>\n<h3>Stop the replication environment<\/h3>\n<ul>\n<li>Connect to the source database PROD1 and stop all extract groups for the replication to the database REP1<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@server1:~\/ [PROD1] PROD1\noracle@server1:~\/ [PROD1] cdgh\noracle@server1:\/u99\/app\/goldengate\/gss\/11.1.1.1.0\/ [PROD1] ggsci\n\nGGSCI (server1) 1&gt; info all\n\nProgram Status Group Lag Time Since Chkpt\nMANAGER RUNNING\nEXTRACT RUNNING DPG001 00:00:00 00:00:06\nEXTRACT RUNNING G001 00:00:00 00:00:05\n\nGGSCI (server1) 2&gt; stop extract *\nProgram Status Group Lag Time Since Chkpt\n\nMANAGER RUNNING\nEXTRACT STOPPED DPG001 00:00:00 00:00:01\nEXTRACT STOPPED G001 00:00:00 00:00:13<\/pre>\n<ul>\n<li>Connect to the target database REP1 and stop the replicat group coming from the database PROD1<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">GGSCI (server2) 1&gt; info all\n\nProgram Status Group Lag Time Since Chkpt\nMANAGER RUNNING\nREPLICAT RUNNING PROD1 00:00:00 00:00:04\n\nGGSCI (server2) 2&gt; stop REPLICAT PROD1\nGGSCI (server2) 3&gt; info all\n\nProgram Status Group Lag Time Since Chkpt\nMANAGER RUNNING\nREPLICAT STOPPED PROD1 00:00:00 00:00:04<\/pre>\n<p>&nbsp;<\/p>\n<h3>Update the extract environment with the new tables<\/h3>\n<ul>\n<li>Now we can update the extract group G001 on the source database with the new tables to be replicated. Edit the G001 parameter file and add the new tables (vi editor)<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">GGSCI (server1) 30&gt; edit params G001\n. . . \ntable G001SCHEMA.CFG_ADV_COND;\ntable G001SCHEMA.CFG_NARRATIVE_TEMPLATE;\ntable G001SCHEMA.CFG_REG_REPORT_RULES;\ntable G001SCHEMA.CMN_LOOKUP;\ntable G001SCHEMA.CMN_USER_LOGIN;<\/pre>\n<ul>\n<li>Add supplemental login on source database PROD1 for the new added tables<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">GGSCI (server1) 7&gt; DBLOGIN userid goldengate, password ******\nSuccessfully logged into database.\n\nGGSCI (server1) 8&gt; add trandata G001SCHEMA.CFG_ADV_COND\nGGSCI (server1) 9&gt; add trandata G001SCHEMA.CFG_NARRATIVE_TEMPLATE\nGGSCI (server1) 10&gt; add trandata G001SCHEMA.CFG_REG_REPORT_RULES\nGGSCI (server1) 11&gt; add trandata G001SCHEMA.CMN_LOOKUP\nGGSCI (server1) 13&gt; add trandata G001SCHEMA.CMN_USER_LOGIN<\/pre>\n<ul>\n<li>Configure the source database to extract the additional five tables and we can restart the corresponding extract groups<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">GGSCI (server1) 30&gt; start extract *\nGGSCI (server1) 31&gt; info all\nProgram Status Group Lag Time Since Chkpt\nMANAGER RUNNING\nEXTRACT RUNNING DPG001 00:23:02 00:00:03\nEXTRACT RUNNING G001 00:00:00 00:00:06<\/pre>\n<p>&nbsp;<\/p>\n<h3>Initial Load from the new tables<\/h3>\n<p>As the addtional tables from the source database PROD1 are extracted, the initial load (expdp\/impdp) from the data can be started on the target database REP1.<br \/>\nAttention, we have to start the export for a specific transaction point (SCN) , in order to begin the replication target database from the same SCN.<\/p>\n<p>Thus we have to going to read the current_scn from the source database for the synchronization (explained later).<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select current_scn from v$database;\n\nCURRENT_SCN\n-----------\n 1657153626<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Create an expdp parfile with the above selected SCN and the additional tables to replicate<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@server1:~\/app\/oracle\/admin\/PROD1\/create\/goldengate\/add_tables [PROD1] cat expdp_additional_tables.par\n\nflashback_scn=1657153626\nSCHEMAS=G001SCHEMA\nDUMPFILE=export_tables_G001SCHEMA.dmp\nLOGFILE=export_tables_G001SCHEMA.log\nINCLUDE=TABLE:\"IN('CFG_ADV_COND','CFG_NARRATIVE_TEMPLATE','CFG_REG_REPORT_RULES','CMN_LOOKUP','CMN_USER_LOGIN')\"\nDIRECTORY=DATAPUMPDIR<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Start the export from the above tables as user system<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@server1:~\/app\/oracle\/admin\/PROD1\/create\/goldengate\/ [PROD1] expdp parfile=expdp_additional_tables.par\n\nUsername: system\nPassword:\n\nConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\nFLASHBACK automatically enabled to preserve database integrity.\nStarting \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\": system\/******** parfile=expdp_additional_tables.par\nEstimate in progress using BLOCKS method...\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\nTotal estimation using BLOCKS method: 21.25 MB\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\nProcessing object type SCHEMA_EXPORT\/TABLE\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX\nProcessing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\nProcessing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/REF_CONSTRAINT\nProcessing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\n. . exported \"G001SCHEMA\".\"CMN_USER_LOGIN\" 8.735 MB 286163 rows\n. . exported \"G001SCHEMA\".\"CFG_ADV_COND\" 1.523 MB 1617 rows\n. . exported \"G001SCHEMA\".\"CFG_REG_REPORT_RULES\" 100.5 KB 714 rows\n. . exported \"G001SCHEMA\".\"CFG_NARRATIVE_TEMPLATE\" 9.789 KB 85 rows\n. . exported \"G001SCHEMA\".\"CMN_LOOKUP\" 6.585 KB 4 rows\nMaster table \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully loaded\/unloaded\n******************************************************************************\nDump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:\n \/u00\/app\/oracle\/admin\/PROD1\/dmp\/export_ARGUS_tables_G001SCHEMA.dmp\nJob \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully completed at 11:01:22<\/pre>\n<ul>\n<li>Copy the dumpfile from server1 to server2<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@server1:~\/app\/oracle\/admin\/PROD1\/create\/goldengate\/ [PROD1] \nscp \/u00\/app\/oracle\/admin\/PROD1\/dmp\/export_tables_G001SCHEMA.dmp oracle@server2:~\/app\/oracle\/admin\/REP1\/dmp\/\nexport_tables_G001SCHEMA.dmp 100% 11MB 10.7MB\/s 00:00<\/pre>\n<ul>\n<li>Create an impdp parfile in order to load the tables from the above created dumpfile<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">Take care: the correct REMAP and EXCLUDE parameter must be configured based on your environment requirement\n\noracle@server2:~\/app\/oracle\/admin\/REP1\/create\/goldengate\/add_tables\/ [REP1] cat impdp_PROD1_tables.par\n\nDUMPFILE=export_tables_G001SCHEMA.dmp\nLOGFILE=import_tables_G001SCHEMA.log\nREMAP_SCHEMA=G001SCHEMA:G001_PROD1\nREMAP_TABLESPACE=DATA_01:PROD1_DATA\nREMAP_TABLESPACE=DATA_02:PROD1_DATA\nREMAP_TABLESPACE=INDEX_01:PROD1_DATA\nREMAP_TABLESPACE=INDEX_02:PROD1_DATA\nDIRECTORY=DATAPUMPDIR\nEXCLUDE=GRANT\nEXCLUDE=CONSTRAINT\nEXCLUDE=REF_CONSTRAINT<\/pre>\n<ul>\n<li>Start the import with impdp as user system using the above parameter file<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@server2:~\/app\/oracle\/admin\/REP1\/create\/goldengate\/add_tables\/ [REP1] impdp parfile=impdp_PROD1_tables.par\n\nUsername: system\nPassword:\n\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\nWith the Partitioning, Oracle Label Security, OLAP, Data Mining,\nOracle Database Vault and Real Application Testing options\nMaster table \"SYSTEM\".\"SYS_IMPORT_FULL_01\" successfully loaded\/unloaded\nStarting \"SYSTEM\".\"SYS_IMPORT_FULL_01\": system\/******** parfile=impdp_PROD1_tables.par\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\n. . imported \"G001_PROD1\".\"CMN_USER_LOGIN\" 8.735 MB 286163 rows\n. . imported \"G001_PROD1\".\"CFG_ADV_COND\" 1.523 MB 1617 rows\n. . imported \"G001_PROD1\".\"CFG_REG_REPORT_RULES\" 100.5 KB 714 rows\n. . imported \"G001_PROD1\".\"CFG_NARRATIVE_TEMPLATE\" 9.789 KB 85 rows\n. . imported \"G001_PROD1\".\"CMN_LOOKUP\" 6.585 KB 4 rows\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\nProcessing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\nJob \"SYSTEM\".\"SYS_IMPORT_FULL_01\" successfully completed at 11:49:06<\/pre>\n<p>&nbsp;<\/p>\n<h3>Add temporary the new tables to replication group<\/h3>\n<p>Now the new tables to replicate can be temporary add to the replication group PROD1 with the above selected SCN number, as starting point for the replication.<\/p>\n<p>Attention: Within the GoldenGate configuration file we speak about CSN and not SCN, but both contains the same information (System Change Number).<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@server2:~\/app\/goldengate\/ggs\/11.1.1.1.0\/[REP1] ggsci\n\nGGSCI (server2)&gt; edit params PROD1\n\nREPLICAT PROD1\nASSUMETARGETDEFS\nUSERID goldengate, PASSWORD *****\nDISCARDFILE \/u00\/app\/goldengate\/ggs\/11.1.1.1.0\/discard\/PROD1_discard.txt, append, megabytes 10\nMAP G001schema.CFG_ADV_COND ,TARGET G001_PROD1.CFG_ADV_COND ,FILTER ( @GETENV (\"TRANSACTION\", \"CSN\") &gt; 1657153626);\nMAP G001schema.CFG_NARRATIVE_TEMPLATE ,TARGET G001_PROD1.CFG_NARRATIVE_TEMPLATE ,FILTER ( @GETENV (\"TRANSACTION\", \"CSN\") &gt; 1657153626);\nMAP G001schema.CFG_REG_REPORT_RULES ,TARGET G001_PROD1.CFG_REG_REPORT_RULES ,FILTER ( @GETENV (\"TRANSACTION\", \"CSN\") &gt; 1657153626);\nMAP G001schema.CMN_LOOKUP ,TARGET G001_PROD1.CMN_LOOKUP ,FILTER ( @GETENV (\"TRANSACTION\", \"CSN\") &gt; 1657153626);\nMAP G001schema.CMN_USER_LOGIN ,TARGET G001_PROD1.CMN_USER_LOGIN ,FILTER ( @GETENV (\"TRANSACTION\", \"CSN\") &gt; 1657153626);\nMAP G001schema.*, TARGET G001_PROD1.*<\/pre>\n<ul>\n<li>Start the replication group PROD1 with the new added tables<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">GGSCI (server2) 2&gt; start replicat PROD1\n\nSending START request to MANAGER ...\nREPLICAT PROD1 starting<samp><code><\/code><\/samp><\/pre>\n<ul>\n<li>Check the configuration until the both databases are synchronised<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">GGSCI (server2) 1&gt; info all\nProgram Status Group Lag Time Since Chkpt\nMANAGER RUNNING\nREPLICAT RUNNING PROD1 00:00:00 00:00:00<\/pre>\n<p>&nbsp;<\/p>\n<h3>Remove the temporary added new tables from the replication group file<\/h3>\n<p>As both databases are again synchronized including the new tables, the temporary added filter can be removed from the replication group file.<\/p>\n<ul>\n<li>Stop the replication group PROD1<\/li>\n<\/ul>\n<p><samp><code>GGSCI (server2) 4&gt; stop replicat PROD1<\/code><\/samp><\/p>\n<ul>\n<li>Set back the original extraction configuration file for the froup PROD, without the filters for the new files<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@server2:~\/app\/goldengate\/ggs\/11.1.1.1.0\/[REP1] ggsci\n\nGGSCI (server2) 2&gt; edit params PROD1\n\nREPLICAT PROD1\nASSUMETARGETDEFS\nUSERID goldengate, PASSWORD *****\nDISCARDFILE \/u00\/app\/goldengate\/ggs\/11.1.1.1.0\/discard\/PROD1_discard.txt, append, megabytes 10\nMAP G001schema.*, TARGET G001_PROD1.*<\/pre>\n<ul>\n<li>Restart the replication<\/li>\n<\/ul>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">GGSCI (server2) 3&gt; start REPLICAT PROD1\nGGSCI (server2) 4&gt; info all\n\nProgram Status Group Lag Time Since Chkpt\nMANAGER RUNNING\nREPLICAT RUNNING PROD1 00:00:00 00:00:00<\/pre>\n<p>&nbsp;<\/p>\n<h3>Conclusion<\/h3>\n<p>The integration of additional tables into a existing GoldenGate replication environment is not very complex, but the steps order must be exactly and carefully followed. Have fun with Oracle Goldengate!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Once a replication environment is set up, it&#8217;s rarely forever. Adding tables to\u00a0an Oracle GoldenGate replication group with minimal impact to the current replication is quite\u00a0a difficult operation. This posting should help you with this task. In the example below, tables from schema G001 will be added to an existing replication setup from the database [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[327,328,17,301],"type_dbi":[],"class_list":["post-2735","post","type-post","status-publish","format-standard","hentry","category-application-integration-middleware","tag-add-tables","tag-goldengate","tag-oracle-11g","tag-replication"],"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>Adding new tables to an existing Oracle GoldenGate replication - dbi Blog<\/title>\n<meta name=\"description\" content=\"Once a replication environment is set up, it&#039;s rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation.\" \/>\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\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adding new tables to an existing Oracle GoldenGate replication\" \/>\n<meta property=\"og:description\" content=\"Once a replication environment is set up, it&#039;s rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-28T22:50:00+00:00\" \/>\n<meta name=\"author\" content=\"Herv\u00e9 Schweitzer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Herv\u00e9 Schweitzer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 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\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/\"},\"author\":{\"name\":\"Herv\u00e9 Schweitzer\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7\"},\"headline\":\"Adding new tables to an existing Oracle GoldenGate replication\",\"datePublished\":\"2012-08-28T22:50:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/\"},\"wordCount\":488,\"commentCount\":0,\"keywords\":[\"add tables\",\"GoldenGate\",\"Oracle 11g\",\"Replication\"],\"articleSection\":[\"Application integration &amp; Middleware\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/\",\"name\":\"Adding new tables to an existing Oracle GoldenGate replication - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2012-08-28T22:50:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7\"},\"description\":\"Once a replication environment is set up, it's rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adding new tables to an existing Oracle GoldenGate replication\"}]},{\"@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\/7fb08fbefcb9b2c146ef4533cfee00c7\",\"name\":\"Herv\u00e9 Schweitzer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"caption\":\"Herv\u00e9 Schweitzer\"},\"description\":\"Herv\u00e9 Schweitzer has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters (RAC), Oracle GoldenGate, and Oracle Failsafe. Herv\u00e9 Schweitzer is \\\"Oracle Certified Master 11g (OCM 11g)\\\". Prior to joining dbi services, Herv\u00e9 Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Herv\u00e9 Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/herve-schweitzer\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Adding new tables to an existing Oracle GoldenGate replication - dbi Blog","description":"Once a replication environment is set up, it's rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation.","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\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/","og_locale":"en_US","og_type":"article","og_title":"Adding new tables to an existing Oracle GoldenGate replication","og_description":"Once a replication environment is set up, it's rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation.","og_url":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/","og_site_name":"dbi Blog","article_published_time":"2012-08-28T22:50:00+00:00","author":"Herv\u00e9 Schweitzer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Herv\u00e9 Schweitzer","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/"},"author":{"name":"Herv\u00e9 Schweitzer","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7"},"headline":"Adding new tables to an existing Oracle GoldenGate replication","datePublished":"2012-08-28T22:50:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/"},"wordCount":488,"commentCount":0,"keywords":["add tables","GoldenGate","Oracle 11g","Replication"],"articleSection":["Application integration &amp; Middleware"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/","url":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/","name":"Adding new tables to an existing Oracle GoldenGate replication - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2012-08-28T22:50:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7"},"description":"Once a replication environment is set up, it's rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/adding-new-tables-to-an-existing-oracle-goldengate-replication\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Adding new tables to an existing Oracle GoldenGate replication"}]},{"@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\/7fb08fbefcb9b2c146ef4533cfee00c7","name":"Herv\u00e9 Schweitzer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","caption":"Herv\u00e9 Schweitzer"},"description":"Herv\u00e9 Schweitzer has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters (RAC), Oracle GoldenGate, and Oracle Failsafe. Herv\u00e9 Schweitzer is \"Oracle Certified Master 11g (OCM 11g)\". Prior to joining dbi services, Herv\u00e9 Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Herv\u00e9 Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/herve-schweitzer\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2735","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2735"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2735\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2735"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}