Website : www.careeronlinetrainings.com
#3-6-365,307,5th Floor, Liberty Plaza, opp:Stanza,Himayat Nagar, Hyderabad-500029
Phone No : 040- 6464 5154
Email : info@careeronlinetrainings.com
Introduction to Oracle Golden Gate
- Oracle Golden Gate Replication Solutions for Live Reporting, Real Time Data Warehousing, Live Standby Database, and High Availability.
- Supported databases and platforms
- Advantages of Oracle Golden Gate
Installing Oracle Golden Gate
- Downloading the software from Oracle website.
- Installing Oracle Golden Gate
- Explaining Subdirectories
- Preparing Oracle 11g database for data replication
Oracle Golden Gate Technology and Architecture
- Understanding Golden Gate Components: Processes and Files
- Process Data Flow
- GoldenGate Architecture
- Design Considerations
Configuring & Preparing the Environment
- Configuring the Manager process
- Describing the Manager Parameters
- Starting the Manager process
- Configuring GLOBALS file
Data Definitions File
- Overview of Data Definitions File
- When to use Data Definitions Files
- Types of Data Definitions File
- Configuring Data Definitions File
Configuring Change Capture Delivery – With and Without Data Pump
- Preparing a source database for transaction capture
- Describing the high-level configuration steps
- Explaining change capture and delivery with a data pump
- Explaining change capture and delivery without a data pump
- Comparing batch and online operation
- Explaining Oracle Golden Gate Checkpoints
- Describing the Extract process
- Configuring and starting an Extract process
- Adding local and remote trails
- Configuring and starting a data pump
- Explaining the Replicate process
- Configuring a Replicate process
- Starting a Replicate process
- Describing GGSCI commands
- Describing Extract trails and files
Configuring Change Capture Delivery – DDL Replication and Initial Data Load
- Overview of DDL synchronization
- Preparing a source database for transaction capture
- Describing the high-level configuration steps
- Configuring Extract and Replicat for DDL replication
- Configuring Initial Data Load using Oracle
- GoldenGate Extract and Replicat
Oracle Golden Gate Commands
- Running Golden Gate commands from the GGSCI prompt
- Running Golden Gate commands from the obey files
- Running Golden Gate commands from the OS shell
- Identifying the types of GGSCI commands available
Managing Oracle Golden Gate
- Managing trail files
- Automating process startup
- Using reporting and statistics
GoldenGate Security Features
- Using message, trail and password encryption
- Controlling command permissions – CMDSEC file
Advanced Configuration: Mapping and manipulating data
- Overview of data mapping and manipulation
- Deciding where data mapping and conversion will take place
- Data Selection and Filtering
- Data Transformation
- Using built-in functions
- Using SQLEXEC to interact directly with a database
Troubleshooting Oracle Golden Gate
- Troubleshooting process startup failures
- Troubleshooting slow startup
- Troubleshooting Extract problems
- Troubleshooting missed transactions
- Using the discard file
- Using SHOWSYNTAX to view Replicat SQL statements
- Using the Logdump utility
GoldenGate Performance Tuning
- Using BATCHSQL to speed delivery
- Using RANGE Function
- Using parallel Replicat groups on a target system
