Oracle GoldenGate enables exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across an enterprise. Its modular architecture provides flexibility, filtering, transformation and custom processing features of Oracle GoldenGate. Oracle GoldenGate supports numerous business requirements, such as, initial load and database migration, data integration, decision support and data warehousing. Customers can achieve continuous availability for critical systems and real-time data integration, required for swift access to current and accurate data.
Preview
By the end of this training you will learn to:
- Install Oracle GoldenGate on Linux and Windows platforms
- Issue GGSCI commands
- Configure, start, stop, and monitor Change Capture and Delivery processes
- Manage Extract trails and files using Data Pump and logdump
- Create parameter files to transform data
- Manage multiple Oracle GoldenGate instances
Course Contents
Creating Oracle GoldenGate Topologies Reviewing Oracle GoldenGate Use Cases
Explaining Change Capture and Delivery (with and without a Data Pump) Performing Installation
Configuring Manager Process
Accessing Logs on Oracle ASM Configuring Replicat Tasks
Describing Trail Formats
Listing Database-specific Methods Contrasting GLOBALS versus Process Parameters
Mapping Columns Between Different Schemas
Configuring and Using User Tokens Configuring and Using Compression
Detecting Loops
Configuring and Using Options for DDL ReplicationDay 1
Technology Overview
Assembling Building Blocks
Listing Supported OS
Listing Supported Databases
Listing the Oracle GoldengGate Product Line
Describing GUI Management Options
Listing Non-Database Sources and Targets
Oracle GoldenGate ArchitectureDescribing Oracle GoldenGate Process Groups
Explaining Initial Data Load
Contrasting Batch and Online Operation
Explaining Oracle GoldenGate Checkpointing
Describing Commit Sequence Numbers (CSN)
Describing Oracle GoldenGate Files and Directories
Installing Oracle GoldenGate
Day 2
Listing System Requirements
Configuring Environment Variables
Using GGSCI
Running Oracle GoldenGate from the OS shell.
Configuration Overview and Preparing the EnvironmentReviewing Configuration Overview
Creating Source Definitions
Preparing the Source Database
Assigning Oracle Database Roles/Privileges Required
Using DBMS_GOLDENGATE_AUTH Package
Configuring Change Capture (Extract)Reviewing Extract Overview
Accessing Logs Remotely
Configuring Extract Tasks
Adding Extract Group
Editing Extract Parameters
Extracting Use of Archived Transaction Logs
Adding Trails
Configuring Change Delivery (Replicat)
Day 3
Reviewing Replicat Overview
Configuring a Sample Environment
Configuring New Integrated Replicat
Configuring Extract Trails and Files (Data Pump)Reviewing Extract Trails and Files Overview
Using Logdump for Viewing Trails
Reversing the Trail Sequence
Configuring and Using Data Pumps
Performing Initial LoadOracle GoldenGate Methods
Describing Resource Limitations
Listing Advantages of Oracle GoldenGate Methods
Configuring File Load Methods
Configuring Direct Load Methods
Handling Collisions with Initial Load
Editing Configuration Parameters
Day 4
Editing Parameter Files
Configuring GLOBALS Parameters
Configuring Manager Parameters
Configuring Extract Parameters
Configuring Replicat Parameters
Filtering and Data SelectionFiltering and Data Selection
Using Built-in "@" (at) Functions
Using SQLEXEC to Interact Directly with a Database
Configuring New Coordinated Replicat
Additional Transformation ConceptsConfiguring and Using Macros
Configuring and Using User Exits
Configuring and Using Oracle Sequences
Configuration Options
Day 5
Configuring and Using BATCHSQL
Configuring and Using Encryption
Configuring and Using Event Actions
Configuring New Wallet Security
Bidirectional ReplicationReviewing Bidirectional Considerations
Avoiding Conflicts
Configuring and Using Conflict Detection and Resolution
Describing Identity Types Issues
DDL ReplicationReviewing Data Description Language Replication Overview
Configuring and Using String Substitution in DDL