Infrastructure at your Service

Tag

GoldenGate Archives - Page 2 of 2 - Blog dbi services

Daniel Westermann

Using GoldenGate event actions to suspend replication for end of day reporting

By | Database Administration & Monitoring | 3 Comments

The last post in this series outlined on how to do an initial load of the target database using the “expdp/impdp” 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) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp In this post I’ll look into how to use event actions to suspend GoldenGate replication for…

Read More
Daniel Westermann

Performing an initial load with GoldenGate (2) – expdp/impdp

By | Database Administration & Monitoring | 14 Comments

The last post in this series outlined on how to do an initial load of the target database using the “file to replicat” 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) – file to replicat In this post I’ll show how to do the initial load by exporting a schema from the source database, importing that into the…

Read More
Daniel Westermann

Performing an initial load with GoldenGate (1) – file to replicat

By | Database Administration & Monitoring | 8 Comments

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’ll look how to do an initial load using GoldenGate by using the “File to replicat” method (several other methods are available). To start…

Read More
Daniel Westermann

Setting up a sample replication with GoldenGate

By | Database Administration & Monitoring | 9 Comments

The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release: Installing and patching Oracle GoldenGate 12c to the latest release In this post I’ll look in how to prepare the databases and how to setup GoldenGate for a first sample replication between two Oracle 12.1.0.2 databases. My test setup is as follows: Hostname Database Type oelgg1 DB1 Source oelgg2 DB2 Target   The idea is that…

Read More
Daniel Westermann

Installing and patching Oracle GoldenGate 12c to the latest release

By | Database Administration & Monitoring | 8 Comments

As more and more customers ask for expertise in Oracle GoldenGate this blog post is the first in a series and outlines how to install Oracle GoldenGate 12c and how to patch it to the latest release on Oracle Linux 7.1 x64. The installation sources (as always) can be downloaded from otn.oracle.com. For the latest patchset you’ll need access to mos. At the time of writing the latest patchset is 12.1.2.1.9 and can be downloaded…

Read More
Franck Pachot

Oracle et Dbvisit Replicate pour migrer sans arrĂŞt de service… et sans stress

By | Hardware & Storage, Oracle | No Comments

By Franck Pachot . Je viens d’assister au Webinar Zero Downtime Migration pour Oracle, prĂ©sentĂ© par Chris Lawless qui est rĂ©cemment passĂ© de Product Manager Golden Gate Ă  Product Manager Dbvisit.  Je vais dĂ©tailler ici un point très important Ă©voquĂ© par Chris Lawless. La migration par rĂ©plication n’est pas seulement envisagĂ©e pour Ă©viter un arrĂŞt de service. ArrĂŞt nĂ©cĂ©ssaire lors de la migration proprement dite (qui peut aller de quelques minutes Ă  plusieurs heures en…

Read More
Hervé Schweitzer

Adding new tables to an existing Oracle GoldenGate replication

By | Application integration & Middleware | 14 Comments

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. 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 PROD1 to REP1. CFG_ADV_COND CFG_NARRATIVE_TEMPLATE CFG_REG_REPORT_RULES CMN_LOOKUP CMN_USER_LOGIN   Stop the replication environment Connect to the source database PROD1 and…

Read More