Syllabus of 1z0-447

                                              Syllabus of 1z0-447

Oracle GoldenGate (OGG) Overview
◦ Describe OGG functional overview and common topologies
◦ Describe OGG Veridata and Management Pack functionality
◦ Describe the difference between real-time data integration replication and Data Manipulation Language (DML) replication

Architecture Overview
◦ Describe OGG components
◦ Create the two types of Capture processes for Oracle database
◦ Create the three types of Replicat processes
◦ Explain the difference between an Extract and Pump, and local and remote trails
◦ Configure OGG's process recovery mechanism

Install and Configure OGG
◦ Download and Install OGG, and differentiate between various installers (zip, OUI, tar)
◦ Synchronize source and target databases with the Initial Load
◦ Prepare database for OGG CDC and check databases with OGG schema check script
◦ Configure OGG Replication component parameter files
◦ Configure the OGG Command Interface to create OGG processes
◦ Describe how to identify and resolve issues in heterogeneous replication, and provide appropriate solutions
◦ Configure OGG utilities

Parameters
◦ Describe and compare GLOBALS versus MANAGER parameters
◦ Create solutions using component parameters for replication requirements
◦ Install OGG parameters
◦ Explain and identify parameters specific for non-Oracle databases

Mapping and Transformation Overview
◦ Implement use cases for transformation functions
◦ Implement macros

Configuration Options
◦ Describe OGG configuration options (Data Definition Language (DDL), compression and encryption options)
◦ Configure OGG event actions based on use cases
◦ Troubleshoot conflict detection and resolution
◦ Configure Integrated Capture, Replicat, and deployment options

Managing and Monitoring Oracle GoldenGate
◦ Manage OGG command and data security
◦ Implement and troubleshoot OGG Monitoring
◦ Explain the configuration and management of the  Enterprise Manager 12c plug-in
◦ Implement and troubleshoot OGG Veridata

Introduction

·       Uses of Oracle GoldenGate

·       Reviewing Oracle GoldenGate Use Cases

·       Oracle GoldenGate Use-Cases for Oracle Database

·       Technology Overview

·       Topologies

·       Supported Platforms

·       Supported Databases

·       Oracle GoldenGate Technology Suite

Oracle GoldenGate Architecture

·       The Two Oracle GoldenGate Architectures

·       Classic Architecture

·       Extracts

·       Initial Loads

·       Checkpoints

·       The Interaction Between Oracle GoldenGate and Oracle RDBMS

Installing Oracle GoldenGate

·       Listing System Requirements

·       Performing Installation

·       Configuring Environment Variables

·       Using Oracle GoldenGate Software Command Interface (GGSCI)

·       Running Oracle GoldenGate from the OS shell.

·       Use Obey files to automate tasks

Preparing the Environment and Configuring Integrated Extract

·       Configuration Overview

·       Preparing the Environment

·       Enabling Oracle GoldenGate in the Database

·       Enabling Supplemental Logging

·       Defining Roles and Permissions

·       Starting the Manager

·       Configuring Data Capture

Configuring Initial Load

·       Initial Load Overview

·       Configuring Initial Load

·       Setting Up the Initial Load by Using the “File to Replicat” Method

·       Setting Up the Initial Data Load by Using the “Direct Load” Method

Configuring Change Delivery (Replicat)

·       Replicat Overview

·       Configuring Replicat Tasks

·       Adding Checkpoints

·       Using Checkpoints

·       Initial Load: Avoiding Collisions with Initial Load

·       Initial Load: Handling Collisions with Initial Load

·       Troubleshooting: GGSCI Process Information

·       Troubleshooting: Report FIles and Log FIles

Managing Extract Trails and Files

·       Trail Format: Local and Remote

·       Trail Format: Cleanup

·       Trail Format: Record Header Area

·       Trail Format: Record Data Area

·       Alternative Trail Formats: Logical Change Records (LCRs)

·       Alternative Trail Formats: Text, SQL, and XML

·       logdump: Opening, Viewing, and Filtering

Oracle GoldenGate Parameters

·       GLOBALS

·       Manager

·       Source Manager Parameters

·       Target Manager Parameters

·       Extract

·       Extract Parameters on the Source Database

·       Replicat

·       Options Common to Both Replicat and Extract

Data Selection and Filtering

·       Mapping and Manipulation

·       Definition Files

·       Data Selection

·       Where

·       Filter

·       Mapping

·       SQLEXEC

Additional Transformation and Configuration Options

·       Create and Invoke Macros

·       Set and Retrieve Useer Tokens

·       Run User Exits in GoldenGate Processes

·       Compress Data Across the Network

·       Encrypt Messages, Trails, and Passwords

·       Automatically Trigger Actions Based on Event Records

Installing Oracle GoldenGate Microservices Architecture

·       Identify and Describe the Various Components of the Oracle GoldenGate Microservices Architecture

·       List the Operating System Pre-Requisites Needed for a Microservices Architecture installation

·       Perform an Oracle GoldenGate Microservice Architecture Installation and Verify its Successful Completion

Oracle GoldenGate Microservices Architecture - Administration Server

·       Using the Administration Server Embedded Web Application to Create Extract and Replicat Groups

·       Accessing Extract/Replicat Process Parameters, Statistics, Checkpoints and Reports Using the Administration Server Embedded Web Application

Oracle GoldenGate Microservices Architecture – Distribution Server

·       Using the Distribution Server Embedded Web Application to Create, Start and Stop Paths

·       Accessing the Data Path Parameters, Statistics, SCN / RBA Positions in Trail Files, and Data Filters Using the Distribution Server Embedded Web Application

Oracle GoldenGate Microservices Architecture - Receiver Server and Performance Metrics Server

·       The Role and Functionality of an MA Receiver Server

·       The Role and Functionality of an MA Performance Metrics Server

MA Admin Client

·       Using the Admin Client to Connect to an MA Deployment

·       Performing Common Administrative Tasks by Using the Admin Client

Database Sharding Support, Metadata Encapsulation, Replication Lag Management, Invisible Column Support

·       Database Sharding Concepts and GoldenGate MA Support for It

·       Metadata Encapsulation Features and Advantages

·       Implementing a Lag Management Policy

·       Handling Replication of Invisible Columns