Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments
Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
Performance Tuning OGG in extremely high data volume environments, Knowledge of logdump utility
Identify data synchronization issues
Remediate Data synchronization issues
Trouble shooting and performance tuning Golden Gate replications
Configure error handling for restart, logging, production support and status reporting in Golden Gate
Physical standby, Data Guard configuration, Maintenance and support for DR activities
Minimum 5 years Installing and configuring OGG heterogeneous environments
Minimum 5 years’ experience in Oracle Golden Gate replication, database server configuration, installation and troubleshooting Golden Gate extract and replicate issues
Minimum 5 years working knowledge of Oracle GoldenGate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replication
5 years demonstrate experience with Oracle 11g and 12c administrating RAC environment, knowledge of backup and restore techniques for medium to very large databases.
First hand experiences in setting up Oracle Golden Gate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions
Expertise in writing OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 12c/ Golden gate management pack