Oracle GoldenGate 11g Fundamentals for Oracle
Starting dates and places
Description
The Oracle GoldenGate 11g: Fundamentals for Oracle course focuses on Oracle-to-Oracle data replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances.
Learn To:- Configure Change Delivery
- Install Oracle GoldenGate and prepare the environment
- Leverage the GGSCI commandline interface
- Confi…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
The Oracle GoldenGate 11g: Fundamentals for Oracle course focuses on Oracle-to-Oracle data replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances.
Learn To:- Configure Change Delivery
- Install Oracle GoldenGate and prepare the environment
- Leverage the GGSCI commandline interface
- Configure Change Capture and configure Initial Load
- Extract trails and files
- Manage Oracle GoldenGate instances
Audience
- Data Warehouse Administrator
- Presales
- Support Engineer
- Technical Consultant
- Database Administrators
- Administrator
Course Topics Oracle GoldenGate 11gR1 Introduction
- Introducing Oracle GoldenGate Features and Functionality
- Describing Oracle Middleware for Business Intelligence
- Describing Oracle GoldenGate High Availability and Disaster Tolerance Solutions
- Describing Oracle GoldenGate Real-time Data Integration Solutions
- Describing Oracle GoldenGate Functionality and Components
- Listing Supported Databases and Platforms
- Describing the Oracle GoldenGate Product Line
- Describing Oracle GoldenGate Process Groups
- Explaining Change Capture and Delivery (with and without a Data Pump)
- Explaining Initial Data Load
- Contrasting Batch and Online Operation
- Explaining Oracle GoldenGate Checkpointing
- Describing Commit Sequence Number (CSN)
- Describing Oracle GoldenGate Files
- Installing Oracle GoldenGate on Linux
- Preparing the Operating System
- Running GoldenGate Commands from the GGSCI Prompt,
- Using Obey Files and OS Shell
- Get help information on GGSCI commands
- Identify the types of GGSCI commands available
- Describing the High-level Configuration Steps
- Configuring and Starting the Manager Process
- Generating a Source Definitions File
- Preparing a Source Database for Transaction Capture
- Describing the Extract Process
- Marking Tables with TRANDATA
- Configuring Extract to Access Logs on Oracle ASM
- Configuring and Starting an Extract Process
- Addind Local and Remote Trails
- Configuring and Starting an Extract Data Pump
- Describing Oracle GoldenGate Initial Load Methods
- Describing a Variety of Database-specific Methods
- Explaining the Advantages of Oracle GoldenGate Methods
- Configuring an Initial Load using Oracle GoldenGate
- Explaining the Replicat Process
- Explaining Adding, Configuring and Starting a Replicat Process
- Describing Avoid and Handle Collisions Between Changes and the Initial Load Data
- Describing and Contrast Extract Trails and Files
- Investigating Different Formats
- Viewing Extract Trails and Files with Logdump
- Reversing the Sequence of Operations in an Extract Trail or File to Back out Changes
- Editing Parameter Files
- Contrasting GLOBALS with Process Parameters
- Describing Commonly-used Parameters for GLOBALS, Manager, Extract and Replicat
- Selecting and Filtering Data for Replication
- Mapping Columns Between Different Schemas
- Using Built-in Functions
- Useing SQLEXEC to Interact Directly with a Database
- Creating and Invoking Macros
- Setting and retrieving User Tokens
- Running User Exits in GoldenGate Processes
- Replicating Oracle Sequences
- Using BATCHSQL to Speed Delivery
- Understanding Data Compress Across the Network
- Enabling Message, Trail and Password Encryption
- Using Event Records to Automatically Trigger Actions
- Understanding Bidirectional Configuration
- Detecting and Avoid Loops
- Avoiding, Detecting, and Handling Conflicts
- Handling Identity Types
- Understanding the Concept of DDL Replication
- Explaining the Requirements for Oracle DDL Replication
- Describing GoldenGate Options for DDL Replication
- Explaining DDL String Subsitution
- Controling Command Persionns
- Managing Trail Files
- Automating Process Setup
- Restarting Oracle GoldenGate
- Handling TCP/IP Errors
- Using Reporting and Statistics
- Monitoring Processes, Lags and Error Messages
- Features of GoldenGate Management Pack
Course Objectives
- Use Oracle GoldenGate utilities
- Perform data transformation using Oracle GoldenGate
- Run and manage Oracle GoldenGate instances
- Describe Oracle GoldenGate solutions
- Describe Oracle GoldenGate architecture
- Install Oracle GoldenGate software on Linux
- Configure Oracle GoldenGate for Oracle-to-Oracle replication
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.