دوره آموزش Oracle Golden Gate 12C

1. ادمین‌های Database
2. کلیه افرادی که به دنبال کار در حوزه اوراکل هستند.

1) Technology Overview

� Creating Oracle GoldenGate Topologies
� Reviewing Oracle GoldenGate Use Cases
� Assembling Building Blocks
� Listing Supported OS
� Listing Supported Databases
� Listing the Oracle GoldengGate Product Line
� Listing Non-Database Sources and Targets

2) Oracle GoldenGate Architecture

3) Configuration Overview and Preparing the Environment

� Reviewing Configuration Overview
� Configuring Manager Process
� Creating Source Definitions
� Preparing the Source Database
� Assigning Oracle Database Roles/Privileges Required
� Using DBMS_GOLDENGATE_AUTH Package

4) Installing Oracle GoldenGate

5) Configure Change Capture(Extract)

� Reviewing Extract Overview
� Configuring Extract Tasks
� Adding Extract Group
� Editing Extract Parameters
� Extracting Use of Archived Transaction Logs
� Adding Trails

6) Configure Change Delivery(Replicate)

� Reviewing Replicat Overview
� Configuring Replicat Tasks
� Configuring a Sample Environment
� Configuring New Integrated Replicat

7) Configure Extract Trails and Files (Data Pump)

8) Performing Initial Load

� Oracle GoldenGate Methods
� Listing Database-specific Methods
� Describing Resource Limitations
� Listing Advantages of Oracle GoldenGate Methods
� Configuring Direct Load Methods
� Handling Collisions with Initial Load

9) Editing Configuration Parameter

10) Filtering and Data Selection

� Filtering and Data Selection
� Mapping Columns Between Different Schemas
� Using Built-in �@� (at) Functions
� Using SQLEXEC to Interact Directly with a Database
� Configuring New Coordinated Replicat

11) Bidirectinal Replication

12) DDL replication

� Reviewing Data Description Language Replication Overview
� Configuring and Using Options for DDL Replication
� Configuring and Using String Substitution in DDL
Oracle GoldenGate 12c Advance

13) Goldengate DBA Views for Troubleshooting

14) Basic and Startup Problems

� Getting familiar with basic problems
� Developing the ability to deal with Extract and Replicat startup issues
� Verifying file names, file permissions, consistency between Extract and Replicat group names and their supporting files
� Verifying consistent naming convention when defining trail files and their reference in the Extract/Replicat parameter files
� Verifying that the correct software version has been installed
� Verifying that the Oracle GoldenGate manager is running, that the group name which fails to start exists and is not misspelt
� Verifying that the the parameter file exists, has the same name as the Extract/Replicat group, and is accessible by Oracle GoldenGate
� Introducing the use of CHECKPARAMS to verify that the parameter syntax is correct

15) Data Extraction Problems

� Developing the ability to deal with and troubleshoot data replication issues:
� Analyzing the various causes of a �stuck� Replicat: Does �Stats Replicat� return no statistics? Do successive �Info Replicat� commands indicate that the Replicat read checkpoint is not moving?
� Verifying that the Replicat is reading the trail to which Extract is writing
� Analyzing the reasons why a Replicat abends: Is Replicat unable to locate a trail? Is Replicat unable to open a trail file? Was �Add TranData� issued for each table?

16) Missed Transaction

17) Mapping And Synchronization Problems

� Developing the ability to deal with and troubleshoot mapping problems, such us: Fetching from the source data fails � Table and column names not matching between the source and the target
� Analyzing the causes of various mapping problems:Is Extract returning fetch-related errors? Was the row containing the data deleted?
� Has the undo retention expired?
� Is �NoUseLatestVersion� for �FetchOptions� being used?
� Do the source and target tables exist in the databases? Are they specified correctly in the Table or Map statement? Are their names fully qualified (schema.table)?
� Do table and column names contain only supported characters?
� Are WHERE clauses comparing different data types?
� Is KeyCols being used? Are both source and target KeyCols being used? Corresponding source and target columns must match.

18) SQLEXEC,File-Maintenance amd Other Problems

19) Classic Performance Tuning

� Identifying causes of slow startups
� Monitoring lag and statistics
� Tuning Manager
� Identifying network and disk bottlenecks
� Tuning �Classic� Extract
� Tuning �Classic� Replicat

20) Integrated Capture and Delivery Troubleshooting

� Familiarizing with Troubleshooting Aids and Tools for Integrated Replication
� Describing Oracle GoldenGate Healthcheck for Integrated Replicat
� Describing the Oracle Database 12c GoldenGate AWR report

21) LogDump

22) Frequently Used GGSCI Commands