SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Replication Service Evolution

conner avatar
conner
13 diapositives · 244 Views · Sep 17, 2014

Join us for the Data Replication Workshop held on June 3, 2014, to explore the transition from Oracle Streams to GoldenGate 12c. We'll cover the impactful changes necessary for effective data replication, including zero-downtime upgrades, DDL replication, and the centralization of GoldenGate installation. By aligning with Oracle recommendations and industry trends, businesses can optimize their data integration with non-Oracle databases. Participate in hands-on testing and discussions on monitoring and configuration strategies for seamless migration to GoldenGate.

Replication Service Evolution - slide 1
01 / 13Replication Service Evolution
1 / 17

Télécharger la présentation

Replication Service Evolution
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Replication Service Evolution Data replication workshop 3.06.2014

  2. Outline • WWHWW

  3. What we would like to change? Data replication workshop 3.06.2014 • Streams => GoldenGate12c • Conditions data between online-offline • Conditions data between offline-T1s • … • DataGuard services stay unchanged

  4. Why to change now? Data replication workshop 3.06.2014 • LS1 is a good occasion to introduce changes • Streams are in maintenance mode • still supported • no enhancements and no new database features will be adopted • Lets follow new trends and Oracle recommendations • Expertise in GoldenGate opens new possibilities • zero-downtime migrations/upgrades • enables data integration with other non-Oracle database

  5. Are our workloads ready for GoldenGate? Data replication workshop 3.06.2014 • (Native) DDL replication (>=11.2.0.4) • Table creation, granting of user privileges • Data filtering on schema and table name level • Remote configuration and management of replication processes • Proactive and reactive monitoring • (See Lorena’s and Maciej presentation tomorrow) • DDL handler at target database • Not really needed for conditions data • Will be available at the end of this year

  6. Are we ready for GoldenGate Data replication workshop 3.06.2014 • Functional test • Performance test • Long distance tests (with T1s) • Long term stability tests • Tests with production data (ATLASCond) • Optimize networking parameters • Long term test with production data • Local and long distance

  7. How? Data replication workshop 3.06.2014 • Central GoldenGate installation • All GoldenGate software installed on a two-node cluster • Processes operate on databases remotely • All binaries & configuration stored on NAS volumes • All monitoring agents installed on the cluster • Cluster in master-slave configuration • With automatic failover

  8. Central GoldenGate installation Replica databases • GG processes • monitoring agents Source databases WAN A’ Central GG servers A A” B B’ C NAS storage with config and trail files C’ Data replication workshop 3.06.2014

  9. Central GoldenGate installation Data replication workshop 3.06.2014 • Easier deployment and management • Everything in one place => easy hardware migration • Installation of GG software on each db server is not needed • Additional integration with RAC is not need (except central service) • No need of running datapump process (from GG stack) • Single trail files (local) copy =>less storage needed • Improved security • No need of additional port opening on replica sites • Simplified deployment of GG monitoring • enables using of Oracle EM plugin to monitor entire environment • Better performanceover WAN (T0->T1s) measured

  10. How on the D-Day? Data replication workshop 3.06.2014 0) ConfigureGoldenGate processes 1) StartGoldenGate extraction processes 2) Stop Streams processes 3) StartGoldenGatereplicat process *) Keep Streams configuration switched off Impact: less than 1 hour of downtime

  11. Who does what? Data replication workshop 3.06.2014 • Experiment • Gives a green light • Support the testing (if possible) • T0 • Central installation of GG cluster • Central installation of monitoring • Deploy of initial configuration • Long term: administration of online-offline replication • Long term: co-administration of online-T1s replication • T1s • Continue long distance tests • Upgrade to 11.2.0.4 (almost done) • Re-instantiation of data (if needed) • Update firewall port configuration • Register on GG monitoring tool • Long term: co-administer of offline-T1s replication

  12. When to change? (proposal) Data replication workshop 3.06.2014 Long term tests with production data (T0->T1s) June ATONR & ATLR compatibility update max: 1stweek of July GoldenGate for online-offline (condDB) week of 21st of July GoldenGate for offline-T1s 1st week of September

  13. THANK YOU! Data replication workshop 3.06.2014