바로가기 메뉴
본문 바로가기
주메뉴 바로가기

Oracle

교육개요
교육 커리큘럼과 강사는 사정에 의해 변경될 수 있습니다.
교육명,를 포함한 교육과정 표
교육명 초급 Oracle GoldenGate 12c: Fundamentals for Oracle 1차
교육기간 2018-12-10 ~ 2018-12-13
교육시간 09:30~17:00(1일 6시간, 총 24시간)
교육장 영우글로벌러닝  지도보기
강사 김도근 강사
정원 20명
교육비 1,444,000원(VAT 별도)


교육소개
This Oracle GoldenGate training provides presentations and hands-on practices of the commands, parameters, functions, features and architectures of Oracle GoldenGate for Oracle-to-Oracle. Both traditional command-line environments and newly introduced, browser-based interfaces are examined and covered in depth.
교육목표
○ Configure, start, stop, and monitor Change Capture (Extract), Change Delivery (Replicat), and Initial Load using the Classic architecture
○ Configure, start, stop, and monitor Change Capture (Extract), and Change Delivery (Replicat) using the Microservices architecture
○ Filter, map, transform and encrypt in-transit data
○ Design replication solutions using Oracle GoldenGate products and environments
○ Install Oracle GoldenGate and prepare the source and target database for replication (assumes an Oracle-to-Oracle environment)
○ Learn and make use of GGSCI commands
○ Use the browser-based interface to configure and manage replication occurring within a Microservices architecture
○ Manage Extract trails and files using utilities such as logdump
교육대상
Database Administrators / Database Designers / System Integrator / Data Warehouse Analyst / Technical Consultant
/ Data Warehouse Developer / Configuration Consultant / Data Warehouse Administrator
교육내용

□ Course Topics

 

○ Introduction
Oracle GoldenGate Use-Cases for Oracle Database
Supported Databases
Reviewing Oracle GoldenGate Use Cases
Uses of Oracle GoldenGate
Topologies
Oracle GoldenGate Technology Suite
Supported Platforms
Technology Overview


○ Oracle GoldenGate Architecture
Checkpoints
Extracts
The Two Oracle GoldenGate Architectures
Classic Architecture
The Interaction Between Oracle GoldenGate and Oracle RDBMS
Initial Loads


○ Installing Oracle GoldenGate
Performing Installation
Configuring Environment Variables
Use Obey files to automate tasks
Using Oracle GoldenGate Software Command Interface (GGSCI)
Listing System Requirements
Running Oracle GoldenGate from the OS shell.


○ Preparing the Environment and Configuring Integrated Extract
Enabling Oracle GoldenGate in the Database
Starting the Manager
Enabling Supplemental Logging
Configuring Data Capture
Preparing the Environment
Defining Roles and Permissions
Configuration Overview


○ Configuring Initial Load
Setting Up the Initial Load by Using the “File to Replicat” Method
Initial Load Overview
Configuring Initial Load
Setting Up the Initial Data Load by Using the “Direct Load” Method


○ Configuring Change Delivery (Replicat)
Configuring Replicat Tasks
Troubleshooting: Report FIles and Log FIles
Initial Load: Handling Collisions with Initial Load
Replicat Overview
Using Checkpoints
Troubleshooting: GGSCI Process Information
Initial Load: Avoiding Collisions with Initial Load
Adding Checkpoints


○ Managing Extract Trails and Files
Trail Format: Local and Remote
Trail Format: Cleanup
Alternative Trail Formats: Logical Change Records (LCRs)
logdump: Opening, Viewing, and Filtering
Alternative Trail Formats: Text, SQL, and XML
Trail Format: Record Header Area
Trail Format: Record Data Area


○ Oracle GoldenGate Parameters
GLOBALS
Manager
Source Manager Parameters
Target Manager Parameters
Extract
Replicat
Extract Parameters on the Source Database
Options Common to Both Replicat and Extract


○ Data Selection and Filtering
Definition Files
Where
Filter
Data Selection
SQLEXEC
Mapping and Manipulation
Mapping


○ Additional Transformation and Configuration Options
Compress Data Across the Network
Set and Retrieve Useer Tokens
Automatically Trigger Actions Based on Event Records
Run User Exits in GoldenGate Processes
Encrypt Messages, Trails, and Passwords
Create and Invoke Macros


○ Installing 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
Identify and Describe the Various Components of the Oracle GoldenGate Microservices Architecture


○ 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
Accessing the Data Path Parameters, Statistics, SCN / RBA Positions in Trail Files, and Data Filters Using the Distribution Server Embedded Web Application
Using the Distribution Server Embedded Web Application to Create, Start and Stop Paths


○ Oracle GoldenGate Microservices Architecture - Receiver Server and Performance Metrics Server
The Role and Functionality of an MA Performance Metrics Server
The Role and Functionality of an MA Receiver Server


○ MA Admin Client
Performing Common Administrative Tasks by Using the Admin Client
Using the Admin Client to Connect to an MA Deployment


Database Sharding Support, Metadata Encapsulation, Replication Lag Management, Invisible Column Support
Implementing a Lag Management Policy
Handling Replication of Invisible Columns
Metadata Encapsulation Features and Advantages
Database Sharding Concepts and GoldenGate MA Support for It

 

 

 

학원의 설립ㆍ운영 및 과외교습에 관한 법률 시행령에 따라 다음과 같이 수강료를 환불해드립니다.

  1. 반환기한 : 반환사유가 발생한 경우 반환기준에 따라 반환사유 발생일로부터 5일 이내에 교습비등을 환불해 드리겠습니다.
  2. 반환기준
    • 1) 교습을 할 수 없거나 교습장소를 제공할 수 없게 된 날을 기준으로 이미 납부한 교습비등을 일할 계산한 금액을 환불해 드리겠습니다.
    • 2) 교습기간이 1개월 이내인 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 총 교습시간 1/3 경과 전 : 이미 납부한 교습비등의 2/3에 해당하는 금액
      - 총 교습시간 1/2 경과 전 : 이미 납부한 교습비등의 1/2에 해당하는 금액
      - 총 교습시간 1/2 경과 후 : 반환하지 않음
    • 3) 교습기간이 1개월을 초과하는 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 교습시작 후 : 반환사유가 발생한 해당월의 반환 대상 교습비등(교습기간 1개월 이내 기준 산출금액)과 나머지 월의 교습비등 전액을 합산한 금액