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
دیدگاهها
هیچ دیدگاهی برای این محصول نوشته نشده است.