Oracle

Oracle 12c Golden Gate Online Training

           SETTING UP SERVERS & USE CASES

  •   Install Oracle Enterprise Linux servers
  •   Install Oracle 12c database software
  •   Setup Golden Gate OS dependencies
  •   Clone Linux servers
  •   Configure Oracle databases
  •   Golden Gate use cases

           INSTALL GOLDEN GATE 12C  

  •   Supported DB’s  OS combinations
  •   Software and OS requirements
  •   Installation – OUI
  •   Directories
  •   Kick start
  •   New in 12c GG   

     GOLDEN GATE 12C ARCHITECTURE
  •   GG workflow
  •   Related products
  •   GG Components
  •   Architecture basics
  •   Processes
  •   Parameters
  •   Topologies

     GOLDENGATE WIRE FRAME
  •   CDC and Delivery
  •   Role of Data pump in GG
  •   Integrated extract
  •   Data load
  •   CKPT in GG

          

         ORACLE TO ORACLE CONFIGURATION BASICS

  •   Steps to configure
  •   Preparing environment – Character set
  •   Configure user – Oracle Database
  •   Network diagnostics
  •   Preparing environment – Supplemental logging
  •   Configuring Manager
  •   Defgen 

    EXTRACT DATA
  •   Change capture
  •   Data pump options
  •   Process groups
  •   Configure Wallet
  •   Integrated Capture
  •   Extract traill
  •   Start Extract
  •   ASM in CDC

         REPLICATE DATA

  •   Change delivery basics
  •   CDD activities  Treat Collisions
  •   Integrated Apply
  •   Monitoring
  •   Reports & Diagnostics

          TRAILING

  •   Extract Trails and Files
  •   Formats
  •   Substitutes
  •   Log Dump
  •   Logging trails
  •   Reverse utility

        BEGIN YOUR REPLICATION

  •   Initial load
  •   Kick start load
  •   Pre-checks
  •   Methods
  •   File based loading
  •   Direct load

           DATA AND CONFIGURATIONS

  •    GLOBAL & Manager Parameters
  •    Extract & Replicat Parameters
  •    Data selection: WHERE, FILTER
  •    Data Mapping: Columns
  •    RANGE
  •    SQLEXEC functionalities
  •    Functions specific to Golden Gate

          OTHER CONSIDERATIONS

  •    Macros & Tokens
  •    User exits & Sequences
  •    BatchSQL in GG
  •    Data compression in GG
  •    Data encryption & Events
  •    GOLDENGATE – BIDIRECTIONAL>
  •    Pictorial view
  •    Configurations
  •    Data looping’s
  •    Resolving conflicts
  •    Effect of Oracle Sequences