Oracle Streams Replication Online Training

Oracle Streams Replication Online Training

Oracle Streams Replication Online Training
Oracle Streams Replication Online Training


Oracle Streams Replication Online Training Course Content:

Oracle Streams: Overview

  • What Is Oracle Streams?
  • Streams: Overview
  • Oracle Streams Database Configuration

Configuring Communication Between Databases

  • Identifying Streams Processes
  • Example Streams configurations
  • Configuring Simple Streams Replication
  • Overview of Replication Configuration Steps
  • Ways to set up Oracle Streams
  • MAINTAIN_* Procedures: Overview
  • Configuration Decisions, Prerequisite Steps & Instantiation Options
  • Configuring Replication using Enterprise Manager
  • Replicating a Single Tablespace, a Set of Tablespaces, an Entire Database, Schemas & Tables
  • Viewing the Configuration Progress & Troubleshooting the Configuration Procedures
  • Removing Oracle Streams Components

Customizing Streams with Rules

  • Using Rules in Oracle Streams
  • Generating System-Created Rules
  • Using Subset Rules with Oracle Streams
  • Creating Subset Rules & Row Subsetting
  • Customizing System-Created Rules & Negative Rule Sets
  • Rule Evaluation with Rule Sets
  • Creating Negative Rules
  • Monitoring System-Created Rules & Negative Rule Sets

Capture Process: Concepts and Manual Configuration

  • Capture & Redo-Based Capture
  • Capture Process: Components
  • Identifying Changes to Capture & Data Types Captured
  • Streams Support for Transparent Data Encryption
  • Wallet Management
  • Types of changes captured & not captured
  • Limiting Captured Messages & Streams Tags
  • Capture Process Architecture & Creating and managing the Capture Process


  • What Is Instantiation?
  • Performing Instantiation
  • Preparing for Instantiation
  • Instantiation SCN
  • Setting the Instantiation SCN
  • Instantiation Using Data Pump
  • Viewing Information About Instantiation & Verifying Instantiations at an Apply Site
  • Removing Instantiation Information

Propagation Concepts and Manual Configuration

  • What is Propagation?
  • Directed Networks, Queue Forwarding & Apply Forwarding
  • How Does Propagation Work?
  • Queue-to-Queue Propagation
  • Guaranteed Message Delivery
  • Queue-to-Queue Propagation and Real Application Clusters
  • Manually Creating a Propagation
  • Managing & Monitoring Propagation

Apply Concepts and Manual Configuration

  • What is Apply?
  • Processing Streams Messages
  • Applying DDL Messages
  • Applying Messages & Error Queue
  • Apply Process and Column Discrepancies
  • Creating, Modifying & Managing the Apply Process
  • Querying the Data Dictionary
  • Managing & Checking the Apply Process


  • Rule-Based Transformations and Capture, Propagation & Apply
  • Declarative LCR Transformations
  • Custom Rule-Based Transformations
  • Modifying an LCR
  • Using LCR Extra Attributes
  • Creating a Custom Rule-Based Transformation
  • Viewing Rule-Based Transformations
  • Managing Custom Rule-Based Transformations

Apply Handlers

  • Message Processing
  • Apply Handlers for LCR Messages
  • Creating an Apply Handler Procedure
  • Implementing a DML Handler
  • Statement DML Handler Type
  • Recording Table Changes
  • Viewing Change Table Handler Information
  • Implementing LOB Assembly

Configuring Downstream Capture

  • Prerequisites for Downstream Capture
  • Configuring Log Transport Services at the Source Database
  • Configuring Downstream Initialization at the Destination Database
  • Configuring Standby Logs at the Destination Database
  • Creating a Downstream Capture Process with a Database Link & Without a Database Link and with the MAINTAIN Procedure
  • Real-Time Downstream Capture
  • Monitoring Downstream Capture Processes
  • Monitoring Log File Availability

Configuring Synchronous Capture

  • Synchronous Capture
  • Captured Data Types & Captured Changes
  • Configuring Synchronous Capture
  • Configuring Oracle Streams for Synchronous Capture
  • Configuring Synchronous Capture
  • Managing and Monitoring Synchronous Capture

Extending the Streams Environment

  • Automatic Extension of OracleStreams: Adding New Shared Objects
  • Adding a Table to a Single or Multiple Source System
  • Adding Objects to a Multiple-Source System
  • Adding a New Destination to a Single-Source System
  • Final Configuration for a Populated Database & an Import Database
  • Using Streams API for Rolling Database Upgrades or Migrations
  • Preinstantiation Steps for Rolling Upgrade
  • Creating a New Streams Site by Using RMAN

Configuring and Using XStream

  • Heterogeneous Data Sharing using Oracle Streams
  • XStream Architecture
  • XStream Out and XStream In
  • Position Order in an LCR Stream
  • Configuring an Outbound Server
  • Configuring an Inbound Server
  • XStream in Action – An Example
  • Monitoring XStream

Splitting and Merging of Streams Destination

  • When to Think about Split and Merge
  • Splitting and Merging of Streams
  • Automatic Split and Merge Functionality
  • New Data Dictionary Views
  • Manual Splitting and Merging of Streams

Avoiding Data Conflicts

  • What Is a Replication Conflict?
  • Error Queue
  • Types of Data Conflicts
  • Specifying Substitute Key Columns
  • Data Consistency and Convergence
  • Conflict Avoidance and Resolution Foundation
  • Avoiding Conflicts by Assigning Data Ownership
  • Suppressing Conflict Detection & Cascading Delete Operations

Conflict Resolution

  • Prebuilt Conflict Handlers
  • Resolution Columns
  • Configuring Supplemental Logging
  • Resolving Conflicts with Prebuilt Update Conflict Handlers & Custom Conflict Handlers
  • Viewing Apply Errors & Error Transaction Information
  • Printing Values from a SYS.AnyData Type
  • Using Procedures to Execute LCRs
  • Viewing Conflict Resolution Information

Comparing and Converging Data

  • Comparing Table Data
  • Creating & Performing Comparisons
  • Viewing the Differences in Data
  • Identifying the Rows That Differ
  • Converging Database Objects
  • Converging a Shared Database Object with a Session Tag Set
  • Rechecking the Results for a Comparison
  • Viewing & Purging Comparison Results

Best Practices and Operations Considerations

  • Best Practices for Streams Database Configuration
  • Sharing & Purging LogMiner Data Dictionaries
  • Altering FIRST_SCN for a Capture Process
  • Removing Unnecessary Archived Log Files
  • Best Practices for Streams Database Operation & Captured Messages
  • Source Queue Growth
  • Clock Synchronization
  • Best Practices for Performing Backups of Your Streams Environment

Monitoring Oracle Streams

  • Monitoring Tools
  • Using Oracle Enterprise Manager to Manage & Monitor Oracle Streams
  • Monitor Capture Statistics, Propagation Statistics & Apply Statistics
  • Message Tracking & Automated Alerts
  • Responding to Automated Alerts in Enterprise Manager
  • Checking the Trace Files and Alert Log
  • Streams Performance Advisor
  • Viewing Performance Statistics for Oracle Streams Components

Troubleshooting Oracle Streams

  • How to Troubleshoot
  • Troubleshooting Capture
  • Troubleshooting Propagation
  • Troubleshooting Apply

Drop your query

What my Client's Say?


  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim