Golden  Gate  

  • What will you learn
  • Audience
  • Course Topic
  • Course Objective
Introduction

  Objectives

  • Oracle Golden Gate 11g
  • Key Capabilities and Technology Differentiators
  • Value Propositions for Oracle Golden Gate
  • Oracle Golden Gate Topologies
  • Oracle Middleware for Business Intelligence
  • Oracle Data Integrator EE and Oracle Golden Gate
  • Oracle Golden Gate for Real-Time Data Warehousing
  • Oracle Golden Gate Solutions for Oracle Database
  • Oracle Golden Gate for Oracle Database: Eliminate Down Time for Migration and Application Upgrade
  • Oracle Golden Gate for Oracle Database: Eliminate Down Time During Oracle
  • Database Upgrades
  • Oracle Golden Gate for Oracle Database: Eliminate Unplanned Down Time with Active Data Guard
  • Oracle Golden Gate for Oracle Database
  • Improve Production System Performance and Lower Costs
  • Oracle Golden Gate for Oracle Database: Offload Redo Logs
  • Oracle Golden Gate for Operational Reporting
  • Oracle GG for Oracle Database: Increase ROI on Existing Servers and Synchronize Global Data

 

Technology Overview

 

	Objectives 

•	Roadmap  
•	Oracle Golden Gate: Modular Building Blocks  
•	Roadmap  
•	Supported Databases  
•	Supported Operating Systems  
•	Roadmap  
•	Oracle GoldenGate Product Line  
•	Oracle Golden Gate Veridata  
•	Oracle Golden Gate Director: Overview  
•	Oracle Golden Gate Director  
•	Oracle Golden Gate Monitor: Overview  
•	Oracle Golden Gate Monitor  
•	Enterprise Manager Cloud Control 12c  
•	Adapter Integration Options for Oracle Golden Gate  
•	Oracle Golden Gate for Flat File  
•	Oracle Golden Gate Application Adapter for Java  
•	JMS Messaging Capture

 

Oracle Golden Gate Architecture

 

	Objectives 

•	Roadmap  
•	Uses of Oracle GoldenGate  
•	Oracle GoldenGate Components  
•	Oracle GoldenGate Logical Architecture  
•	Oracle GoldenGate Process Groups 
•	Process-Group Naming Convention 
•	GGSCI  
•	Parameter Files  Roadmap  
•	Change Data Capture (Extract) and Delivery 
•	Change Data Capture (Extract) and Delivery Using a Data Pump  
•	Extract Flavors  
•	Distributed Topologies for Integrated Extract: Same Machine  
•	Distributed Topologies for Integrated Extract: Different Machine, Real-Time Non-Real-Time 
•	Supported Features Based on Source DB Version  
•	Roadmap  
•	Online Versus Batch Operation  
•	Running an Initial Load  
•	Checkpoints: Capture  
•	Checkpoints: Pump 
•	Checkpoints: Delivery 
•	Commit Sequence Number (CSN)

 

Installing Oracle Golden Gate

 

	Objectives  

•	Roadmap  
•	System Requirements,Operating System Requirements  
•	Downloading Oracle Golden Gate  
•	Installation on UNIX, Linux, or z/OS  
•	Installation on Windows  
•	Oracle Golden Gate Directories  
•	Oracle Golden Gate Documentation  
•	GGSCI Command Interface  
•	GGSCI Commands  
•	GGSCI Examples  
•	Obey Files  
•	New Oracle Golden Gate 11gR1 GGSCI Miscellaneous Commands  
•	Running Oracle Golden Gate from the OS Shell

 

Configuration Overview and Preparing the Environment

 

	Objectives  

•	Configuring Oracle Golden Gate  
•	Character Set: National Language Support (NLS)  
•	Mixed-Case Object Names: ‘Single’ and “Double” Quotes  
•	Configuring Oracle Golden Gate  
•	Preparing the Environment: Oracle Database  
•	Using Command Security  
•	Sample CMDSEC Statements  
•	Handling TCP/IP Errors  
•	tcperrs File  
•	Roadmap  
•	TranData Command  
•	Preparing the Environment: Oracle Database  
•	Preparing the Environment: Manager Overview  
•	Preparing the Environment: Configuring Manager  
•	Preparing the Environment: Sample Manager Parameter File  
•	Preparing the Environment: Overview of Source Definition 
•	Preparing the Environment: Running defgen

 

Configuring Change Capture

 

	Objectives  

•	Step 2: Change Capture  
•	Extract Overview  
•	Data Pump Overview  
•	Data Pumps: One-to-Many Trails  
•	Data Pumps: One-to-Many Target Systems  
•	Setting Up Change Capture (Extract)  
•	Add Extract Command  
•	Add Extract: Examples  
•	Editing Extract Parameters  
•	Passive Alias Extract  
•	Overview of Trails  
•	Adding a Local or Remote Trail  
•	Starting the Extract  
•	Primary Extract Configuration for Oracle  
•	Data Pump Configuration for Oracle  
•	Automatic Storage Management (ASM)  
•	Ensuring ASM Connectivity  
•	ASM and DBLogReader  
•	Practice 6 Overview: Configuring Change Capture

 

Configuring Change Delivery

 

	Objectives  

•	Step 4: Change Delivery (Replicate)  Replicate Overview  
•	Change Delivery Tasks  
•	Check point Table  
•	Sample Configuration  
•	Avoiding Collisions with Initial Load  
•	Handling Collisions with Initial Load  
•	Obtaining Process Information Through GGSCI  
•	Process Report Files  
•	Sample Extract Process Report  
•	Discard Files  
•	Using the ggserr.log Error Log  
•	Using the System Logs

 

Extract Trail and Files

 

	Objectives  

•	Overview of Extract Trails and Files  
•	Extract Trails and Files Distribution  
•	Extract Trails and Files Contents  
•	Extract Trails and Files Cleanup  
•	Trail Format  
•	Record Header Area  Record Data Area  
•	Setting the Compatibility Level  
•	Alternative Trail Formats  
•	Format ASCII  
•	Format ASCII Sample Output  
•	Format SQL  
•	Format SQL Sample Output  
•	Format XML  
•	Format XML Sample Output  
•	Log dump Utility  
•	Opening a Trail  
•	Setting Up a View  
•	Viewing the Trail File Header  
•	Viewing Trail Records  
•	Counting Records in the Trail  
•	Filtering by a File Name  
•	Locating a Hex Data Value  
•	Saving Records to a New Trail  
•	Keeping a Log of Your Session  
•	Overview of the reverse Utility  
•	Overall Process of the reverse Utility  
•	reverse: Overall Process 
•	Sample Parameter Files

 

Configuring the Initial Load

 

	Objectives  

•	Step 3: Initial Load  
•	Initial Load: Advantages of Oracle Golden Gate Methods  
•	Initial Load: Resource Limitations  
•	Prerequisites for Initial Load  
•	Initial Load: Oracle Golden Gate Methods  
•	Initial Load: File to Replicate  
•	Initial Load: File to Database Utility  
•	Initial Load: Direct Load  
•	Initial Load: Direct Bulk Load (to Oracle)  
•	Practice 9 Overview: Configuring the Initial Load

 

Oracle Golden Gate Parameters

 

	Objectives  

•	Roadmap  
•	Oracle Golden Gate Parameter Files  
•	Using Parameter Files  
•	GLOBALS versus Process Parameters  
•	GLOBALS Parameters  
•	Roadmap  
•	Manager Parameters: Overview  
•	Sample Manager Parameter File  
•	Manager Parameter Categories  
•	Managing Trail Files  
•	Extract Parameter Overview  
•	Extract Parameter Defaults  
•	Sample Extract Parameter File  
•	Extract Parameter Categories  
•	Extract Example: Table Parameter  
•	Extract Example: Tran Log Options Parameter  
•	Replicat Parameter: Overview  
•	Replicat Parameter Defaults  
•	Sample Replicat Parameter File  
•	Replicat Parameter Categories  
•	Replicat Example: Map Parameter  
•	DBOptions

 

Data Selection and Filtering

 

	Objectives  

•	Data Mapping and Manipulation: Overview  
•	Types of Definition Files  
•	Data Selection: Overview  
•	Data Selection: Where Clause  
•	Data Selection: Where Clause Examples  
•	Data Selection: Filter Clause  
•	Data Selection: Filter Clause Examples  
•	Data Selection: Range Function  
•	Data Selection: Range Function Examples  
•	Column Mapping: Overview  
•	Column Mapping: Example  
•	Column Mapping: Building History  
•	Data Transformation Using Functions  
•	Functions: Performing Tests on Column Values  
•	@IF Function  
•	Functions: Working with Dates  
•	@Date Function  
•	Functions: Working with Strings and Numbers  
•	@StrCat Function  
•	@StrExt Function  
•	Other Functions  
•	SQLEXEC: Overview  
•	SQLEXEC: Basic Functionality  
•	SQLEXEC: DBMS and Data Type Support  
•	SQLEXEC: Usage with a LOOKUP Stored Procedure  
•	SQLEXEC: Usage with a SQL Query  
•	SQLEXEC: Usage in a Table or Map Statement  
•	SQLEXEC: Usage as a Stand-Alone Statement

 

Additional Transformation Topics

 

        Objectives  

•	Macros: Overview  
•	Creating Macros  
•	Invoking a Macro  
•	Reusing Parameter Sets  
•	Creating Macro Libraries  
•	Tracing Macro Expansion  
•	User Tokens: Overview  
•	Environmental Values Available to @GETENV  
•	Unauthorized reproduction or distribution prohibited  
•	User Tokens Display  
•	Using User Tokens  
•	Viewing User Tokens in Log dump  
•	User Exits: Overview  
•	Uses for User Exits  
•	User Exits: High-Level Processing Logic  
•	Implementing User Exits  
•	User Exit Parameters  
•	Sample User Exits  
•	Calling User Exits  
•	Oracle Sequences: Overview  
•	Practice 12 Overview: Data Transformation

 

Configuration Options

 

	Objectives  

•	Roadmap  
•	BatchSQL: Overview  
•	BatchSQL Syntax  
•	BatchSQL Results  
•	Compression Options  
•	Example of Compression  
•	Compression and Ex adata  
•	Encryption: Overview  
•	Message Encryption  
•	Options: Message Encryption  
•	Trail or Extract File Encryption  
•	Password Encryption: Method  
•	Event Marker System  
•	Uses for Event Actions  
•	Event Actions Flowchart  
•	Event Actions Order  
•	Unauthorized reproduction or distribution prohibited 
•	Event Actions: Heartbeat  
•	Event Actions: Automated Switchover  
•	Event Actions: Automated Synchronization

 

Bidirectional Replication

 

	Objectives  

•	Roadmap  
•	Bidirectional Flowchart  
•	Capabilities of a Bidirectional Configuration  
•	Bidirectional Configuration Considerations 
•	Preventing Data Looping  
•	Loop Detection Techniques  
•	Conflict Avoidance and Detection and Resolution  
•	Conflict Detection by CompareCols  
•	GetUpdateBefores, GetBeforeCols, CompareCols, and ResolveConflict  
•	Conflict Detection by Filter  
•	Conflict Resolution  
•	Conflict Resolution: Example  
•	Conflict Resolution by Applying Net Differences  
•	Resolve Conflict Built-in Methods  
•	Conflict Resolution Custom Methods  
•	Oracle Sequence Numbers  
•	Truncate Table Operations  
•	Overview: Configuring Bidirectional Replication

 

DDL Replication

 

	Objectives  

•	Overview of DDL Replication  
•	DDL Replication Requirements and Restrictions  
•	Characteristics for DDL Replication  
•	DDL Scopes  
•	Using Unqualified Object Names  
•	DDL Parameter  
•	DDL String Substitution  
•	DDL Error Handling  
•	DDLOptions for Oracle  
•	Mapping Schemas  
•	Supporting DDL in an Active-Active Bidirectional Configuration  
•	Activating Oracle DDL Capture
  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • BCA,MCA
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support

Oracle GoldenGate Integrated Capture/integrated Delivery

  • What is Oracle GoldenGate Integrated Capture?
  • Why it is Needed and What Additional Replication Features it Makes Possible
  • How to Prepare a Database for Integrated Capture – Creation of Users, Assignments of Roles and Privileges, etc
  • Oracle GoldenGate Integrated Capture Deployment Modes
  • Integrated Replicat/Apply Architecture
  • Integrated Replicat: How it works
  • Integrated Delivery in Detail

Oracle Goldengate With Oracle Real Application Clusters Configuration

  • Oracle RAC, Oracle GoldenGate and Business Continuity
  • Oracle GoldenGate Used in Combination with Oracle RAC
  • Oracle GoldenGate and the Oracle Database File System (DBFS)
  • Oracle DBFS and Oracle Clusterware
  • Configuring Oracle GoldenGate using the DBFS file systems

Oracle GoldenGate Event Marker System

  • Starting, Suspending, Stopping Processes, Performing a Transformation, Reporting Statistics, and Capturing Lag History Using the Event Marker System
  • Invoking Stored Procedures When Specific Events Occur Using SQLEXEC
  • Activating Tracing Following the Exceeding of a Data Threshold
  • Running OS Shell Commands at the Occurrence of Specific Data-Driven Events
  • Extracting Details Analysis of the TABLE, MAP, FILTER, WHERE and SQLEXEC Statements
  • Implementing Event Marker Actions on the Extraction Side and on the Delivery Side of Replication

Data Mapping, Data Selection/Filtering and Data Transformation

  • TABLE (for Extract) and MAP (for Replicat) Options Which Allow for Data Selection
  • COLMAP and COLMATCH Options
  • Exploring Simple Filtering (Achieved Through the WHERE Clause) and Complex Filtering (Using the FILTER Clause)
  • Data Transformation Functions: Enabling Concatenation, Substitution, Case Changing, Numeric Conversion and Date Conversion
  • SQLEXEC Parameter to Invoke Stored Procedures or to Perform Native SQL Queries

Familiarize the student with Data Conflict Avoidance Techniques

  • Set up and manage advanced deployment models, such as 3-node multi master replication configurations
  • Integrate Oracle GoldenGate with Oracle cluster configurations
  • Explain Oracle GoldenGate Advanced Configuration options
  • Describe and take advantage of the Integrated Capture feature to extract complex data types and compressed data
  • Introduce the new Integrate Replicat feature for improved data delivery
  • Configure and implement the Oracle GoldenGate Event Marker system, to enable data transformation based on event records in the transaction logs or in the trail files
  • Master Oracle GoldenGate facilities to detect and resolve data conflicts in active-to-active replication implementations
  • Perform zero-downtime database migration