دوره Oracle Golden Gate 12C

هدف از برگزاری دورهOracle Performance Tuning یادگیری راهکارهای اوراکل جهت بهبود سرعت و وضعیت DB می باشد

مروری بر دوره

شما در این دوره چگونگی برطرف کردن Wait های مربوط به قسمت های مختلف اوراکل در حافظه و دیسک ، پیکربندیOracle Cloud Controller  ، بررسی  مشکلات با استفاده از گزارشات AWR ، بررسی انواع Wait ها در Category  های مختاف و همچنین  مباحث Tuning  در قسمت های مختلف Share Pool را خواهید آموخت . همچنین در این دوره با Feature های جدید 12C نیز آشنا خواهید شد.

کمپین آغاز سال تحصیلی جدید

آنچه خواهید آموخت

مباحث اصلی که در این نسخه از دوره به آن اضافه شده است عبارت است از:

  1. مبحث Server Pool در RAC
  2. New Feature in 12c
  3. آشنایی با مباحث مهم خارج از سرفصل دوره

سرفصل ها

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

مخاطبان دوره

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

پیش نیازها

  1. آشنایی با سیستم عامل لینوکس
  2. آشنایی با اوراکل  (Oracle Workshop I)

Ad #2

تقویم دوره

در حال حاضر تقویمی برای این دوره تعریف نشده است.

در حال حاضر تقویمی برای این دوره تعریف نشده است.