Skip to main content

Oracle Golden Gate

* Oracle GoldenGate is used to replicate and integrate transactional data with great speed among a variety of enterprise systems.

* Oracle GoldenGate provides the flexibility to move data between like-to-like and heterogeneous systems,
  including different versions of Oracle Database, different hardware platforms, and between Oracle and non-Oracle databases
  including Microsoft SQL Server, IBM DB2 for open systems and z/OS, Sybase, and more.

* URL = http://gavinsoorma.com/2010/02/goldengate-concepts-and-architecture/
    http://gavinsoorma.com/category/goldengate/


Installation Videos:
====================

goldengate installation =====> https://www.youtube.com/watch?v=lb3UKpgCA1U

Oracle GoldenGate Deep Dive Hands on Lab - Part 1 =====> https://www.youtube.com/watch?v=5Yp6bvGeP2s
Oracle GoldenGate Deep Dive Hands on Lab - Part 2 =====> https://www.youtube.com/watch?v=bOnGgnjXdNo
Oracle GoldenGate Deep Dive Hands on Lab - Part 3 =====> https://www.youtube.com/watch?v=86QK9NXEKks

GavinSoorma Blog for GoldenGate:
================================

http://gavinsoorma.com/2010/02/goldengate-concepts-and-architecture/
http://gavinsoorma.com/2010/02/goldengate-installation-oracle-11g-on-red-hat-linux/
http://gavinsoorma.com/2010/02/goldengate-tutorial-3-configuring-the-manager-process/
http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-4-performing-initial-data-load/
http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-5-configuring-online-change-synchronization/
http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-6-configuring-data-pump-process/
http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-7-configuring-ddl-synchronization/
http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-8-filtering-and-mapping-data/
http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-9-monitoring-goldengate/
http://gavinsoorma.com/2010/03/oracle-goldengate-tutorial-10-performing-a-zero-downtime-cross-platform-migration-and-11g-database-upgrade/

Comments

Popular posts from this blog

CLSRSC-430: Failed to start rolling patch mode

############################################################ GRID PSU Failed on Node2: =========================== [root@server1 tmp]# /oracrs/oracle/product/12102/OPatch/opatchauto apply /path1/patches/23273629 -oh /oracrs/oracle/product/12102 -ocmrf /tmp/ocm.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version        : 12.1.0.2.0 Running from       : /oracrs/oracle/product/12102 opatchauto log file: /oracrs/oracle/product/12102/cfgtoollogs/opatchauto/23273629/opatch_gi_2016-11-25_06-13-44_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /path1/patches/23273629 Grid Infrastructure Patch(es): 21436941 23054246 23054327 23054341 DB Patch(es): 23054246 23054327 The following patch(es) are duplicate patches with patches installed in the Oracle Home.  [ 20299023] You hav...

SQL Plan Management [ SPM ]

============================================= SQL> SHOW parameter baselines NAME                                 TYPE        VALUE ------------------------------------ ----------- ------- optimizer_capture_sql_plan_baselines boolean     FALSE optimizer_use_sql_plan_baselines     boolean     TRUE SQL> ============================================= Connect as SPM user and create a table as follows. -------------------------------------------------- SQL> CREATE TABLE EMPLOYEE (code number,dept char(100),address char(1000)); Table created. SQL> ============================================= Populate some rows in the table =================================== declare c1 number; begin for c1 IN 1..10000 ...