Каталог курсов

Курсы Oracle

Oracle GoldenGate 12c: Troubleshooting and Tuning

 
Код курса  Код: OGGTT    Заявка  Предварительная запись    Продолжительность  Кол-во часов: 32 , Кол-во дней: 4


Prerequisites
Suggested Prerequisite
  • Oracle GoldenGate 12c: Fundamentals for Oracle Ed 1
  • Familiarity with the Oracle Database
Audience
  • Administrator
  • Database Administrator
  • Implementer
  • System Integrator
  • Systems Administrator
Objectives
  • Monitor and tune performance
  • Gather evidence to help troubleshoot problems
  • Use troubleshooting tools
  • Familiarize with the latest tools to troubleshoot Integrated Extract/Replicat
  • Describe solutions for the most common problems
Topics
Gathering Evidence
  • Acquiring confidence using the standard Oracle GoldenGate tools normally used to interact with the software:
  • GGSCI
  • Error Logs, Process Reports, Discard File, System Logs
  • Competently using the tools mentioned above to gather evidence about alleged issues occurring to an Oracle GoldenGate environment
Oracle GoldenGate Troubleshooting Tools
  • Accessing knowledge Documents - Mailing lists, Oracle GoldenGate forums, etc.
  • Consulting the Documentation
  • Getting familiar with the ShowSyntax parameter
  • Getting familiar with the logdump utility
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
Data Extraction Problems
  • Developing the ability to deal with and troubleshoot data extraction issues:Extract is slow - Extract abends - Data pump abends
  • Analyzing various causes of a slow Extract startup
  • Tracing may be enabled, activity logging may be enabled, many columns listed in tables being replicated
  • Introducing the use of the CacheMgr parameter to control the virtual memory and temporary disk space that are available for caching uncommitted transaction data
  • In-depth analysis of abending Extracts: is Extract unable to open the transaction logs? - Checking to see if the disk is full -Is an archive log missing?
  • In-depth analysis of abending data pumps: Does the data pump abend with error number 509 ("Incompatible record")?Have the source tables been changed? Is the Extract abending due to data manipulation?
  • Was the primary Extract or the data pump stopped, re-added, or restarted without resetting the data pump’s read position in the local trail?
Data Replication 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?
Missed Transactions
"Classic" Performance Tuning"
Mapping and Synchronization Problems
"Integrated" Performance Tuning
SQLEXEC, File-Maintenance, and Other Problems
"Integrated" Capture and Delivery Troubleshooting


Ссылка курса обучения
Назад в раздел



Для предварительной записи на курсы или Oracle_logo
уточнения информации позвоните по телефонам:

+38 (044) 492-29-29, 594-98-98
e-mail: training@muk.com.ua

Или заполните заявку на нашем сайте.


Свежие новости

08.12.2020 Анонс воркшопа Autonomous Data Warehouse Cloud Workshop на базе Учебного центра МУК
Открыт набор на воркшоп , который состоится 15 декабря 2020 года

06.12.2020 Тренинг по сертификации H3CNE, 14-17 декабря 2020.

23.11.2020 Новый виток развития: Учебный центр МУК - Amazon Web Services Training Partner
Учебный центр МУК - Amazon Web Services Training Partner!

06.11.2020 Достичь совершенства: Oracle открывает ССоЕ на базе Учебного центра МУК
Группа компаний МУК и компания Oracle подписали контракт о запуске нового и стратегически важного проекта Oracle Cloud Center of Excellence (ССоЕ) на базе Учебного центра МУК