Scribd
Upload
17 views2 pages

Oracle GoldenGate Interview Guide

The document is an interview guide for Oracle GoldenGate, covering basics such as real-time data replication, architecture components, and important concepts like checkpointing and lag. It also outlines configuration steps, troubleshooting methods, performance tuning strategies, and advanced topics such as active-active replication and data filtering. Common interview questions related to GoldenGate are included to aid in preparation.

Uploaded by

er.kalyani01
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views2 pages

Oracle GoldenGate Interview Guide

The document is an interview guide for Oracle GoldenGate, covering basics such as real-time data replication, architecture components, and important concepts like checkpointing and lag. It also outlines configuration steps, troubleshooting methods, performance tuning strategies, and advanced topics such as active-active replication and data filtering. Common interview questions related to GoldenGate are included to aid in preparation.

Uploaded by

er.kalyani01
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Oracle GoldenGate Interview Guide (Basic to

Advanced)

GoldenGate Basics
- Real-time data replication and integration tool
- Supports heterogeneous databases
- Uses transaction logs (redo/archivelogs) for replication

Architecture Components
- Manager: Controls GG processes
- Extract: Captures data changes
- Pump: Transfers trail files (optional)
- Replicat: Applies changes to target
- Trail Files: Intermediate storage

Capture & Delivery Modes


- Classic Capture vs Integrated Capture
- Integrated Replicat vs Classic Replicat
- Batch vs Real-time apply

Important Concepts
- Checkpointing: Tracks progress
- Lag: Delay between source & target
- DDL Replication
- Conflict Detection & Resolution (CDR)

Basic Configuration Steps


- Enable supplemental logging
- Create Extract & Replicat parameter files
- Add trail files
- Start processes via GGSCI

Troubleshooting & Monitoring


- GGSCI commands: INFO, STATS, VIEW REPORT
- Check lag and discard files
- Handle abends and restart processes
Performance Tuning
- Parallel Replicat
- BatchSQL for faster apply
- Tune cache size and checkpoints

Advanced Topics
- Active-Active replication
- Zero-downtime migration
- Data filtering and transformation
- Security and encryption

Common Interview Questions


- Difference between Integrated & Classic Extract?
- How do you handle lag?
- What is checkpointing?
- Explain trail files?
- How to troubleshoot abended processes?

You might also like