UNIRAC.IN

Oracle Golden Gate - Online / Offline

Pricing/Discounts

We offer world class Oracle Golden Gate training at an affordable price of 18000. With 18000, you get 60 hours of quality instruction by our most experienced instructor.
However, for Corporate enrollment (2 or more students), we are currently offering a 10% discount
Online Trainings Offer at 265$(18000RS).

Join Now

1. Introduction to 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

2. Oracle GoldenGate Architecture

• Understanding Golden Gate Components: Processes and Files
• Process Data Flow
• GoldenGate Architecture
• Design Considerations

3. Installing Oracle GoldenGate

• Downloading the software from Oracle website.
• Installing Oracle Golden Gate
• Explaining Subdirectories
• Preparing Oracle 11g database for data replication

4. Command Interface (GGSCI)

• 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

5. Configuration Overview and Preparing the Environment

• Configuring the Manager process
• Describing the Manager Parameters
• Starting the Manager process
• Configuring GLOBALS file

6. Configuring Change Capture

7. Configuring Change Delivery

• Overview of DDL synchronization
• Preparing a source database for transaction capture
• Describing the high-level configuration steps
• Configuring Extract and Replicate for DDL replication
• Configuring Initial Data Load using Oracle GoldenGate Extract and Replicate

8. Extract Trail and Files

9. Configuring the Initial Load

10. Oracle GoldenGate Parameters

11.Data Selection and Filtering

12. DDL Replication

13. 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 Replicate SQL statements
• Using the Logdump utility

13) GoldenGate Performance Tuning

• Using BATCHSQL to speed delivery
• Using RANGE Function
• Using parallel Replicate groups on a target system