India: +91 406677 1418

WhatsApp no. : +919100386313

USA: +1 909 233 6006

Telegram : +15168586242

Oracle Streams

Oracle Streams Course Content

Introduction & Overview
  • Oracle Streams: Basic Elements
  • Capture & Event Staging
  • Staging Area Propagation
  • Rules Engine
  • Oracle Streams with Single-Source & Multiple-Source Database
  • Oracle Streams Usage: Scenarios
  • Using Oracle Streams for Upgrades and Migrations
  • Oracle Streams Interfaces
Database Configuration
  • Configuring the Database Parameters
  • Configuring the Archive Logging
  • Supplemental Logging
  • Database Configuration with Enterprise Manager
  • Configuring the Communication b/w Databases
  • Configuring the Multiple Streams Sites
  • Additional Preparation for File Propagation
Basic Objects of Oracle Streams
  • Types of Object
  • Streams Events
  • Logical Change Records
  • Creating & Managing a Streams Administrator User
  • Staging Area Architecture
  • SYS. Any Data Queues
  • Creating a Staging Queue
  • View Interface to Queue Buffers
System-Created Rules
  • Using Rules in Oracle Streams
  • Generating System Created Rules
  • Using Subset Rules with Oracle Streams
  • Row Subsetting
  • Customizing the System-Created Rules
  • Negative Rule Sets
  • Rule Evaluation with Negative Rule Sets
  • Monitoring Rules
Enterprise the Manager Interface to Oracle Streams
  • Oracle Streams Manageability Features
  • Configuring the Oracle Streams
  • Streams Setup Page
  • Streams Table space Replication Wizard
  • Capture Management
  • Apply Management
  • Propagation Management
  • Managing the Message Transformations
Simplified Streams Configuration
  • Simplified Configuration Procedures
  • Replicating a Single Tablespace (MAINTAIN_SIMPLE_TTS) & a Set of Tablespaces (MAINTAIN_TTS)
  • Instantiating Database Objects
  • Replicating Tables, Schemas & Entire Database
  • Improved Diagnostics for Streams
  • Removing a Streams Queue
  • Removing All Streams Components
Concepts for Capture Process
  • Capture
  • Implicit Event Capture
  • Capture Process Components
  • Identifying the Changes to Capture
  • Logical Change Records
  • Data Types, DDL & DML Types Captured
  • Commands & DDLs Not Captured
  • Streams Tags & Downstream Capture
Capture Process Configuring
  • Creating the Capture Process
  • Downstream Capture
  • Capture Process Parameters
  • Starting & Managing Capture Process
  • Monitoring Log File Availability
  • Capture Process Statistics
  • Troubleshooting Capture
Instantiation
  • Performing Instantiation
  • Preparing for Instantiation
  • Setting the Instantiation SCN
  • Import Instantiation & Creation
  • Instantiation Using Data Pump
  • Setting the Instantiation SCN Manually
  • Instantiating a Database Using RMAN
  • Verifying Instantiations at an Apply Site
Propagation Concepts & Configuration
  • Directed Networks
  • Queue and Forwarding
  • Apply Forwarding
  • Queue-to-Queue Propagation
  • Propagation Job, Rules & Scheduling
  • Creating, Managing, & Monitoring Propagation
  • Troubleshooting Propagation Configuration
Apply Concepts & Configuration
  • Processing Streams Events
  • Applying DDL Events
  • Error Queue
  • Required Apply User Privileges
  • Applying Process Components & Rules
  • Enqueue Destination & Execution Directives During Apply
  • Virtual Dependency Definition
  • Apply Process & Parameters
Transformations
  • Rule-Based Transformations
  • Declarative LCR Transformations
  • Customized Rule-Based Transformations
  • Modifying an LCR
  • Using LCR Extra Attributes
  • Creating a Rule-Based Transformation
  • One-to-many Transformations
  • Viewing and Managing Rule-Based Transformations
Apply Handlers
  • Creating an Apply Handler Procedure
  • Implementing a DML Handler
  • Creating an Error Handler
  • Implementing a DDL & a Precommit Handler
  • Restrictions for Apply Handler Procedures
  • Managing the Apply Handlers
  • Customizing Apply Handler Actions
  • Viewing Apply Handler Information
Administering a Streams Environment
  • Managing the Capture Process
  • Managing the Propagations
  • Managing the Apply Processes
  • Starting & Stopping Streams Processes
  • Managing Streams Process Rule Sets
  • Troubleshooting Apply Failures
Reconfiguring the Streams Environment
  • Types of Streams Environments
  • Extending a Single Source System
  • Extending a Multiple Source System
  • Using Streams for Upgrades or Migrations
  • Removing Sites & Objects
Data Conflicts
  • What Is a Replication Conflict?
  • Error Queue
  • Types of Data Conflicts
  • Primary & Substitute Key Columns
  • Detecting Conflicts
  • Data Consistency & Convergence
  • Conflict Avoidance & Resolution Foundation
  • Site Ownership
Conflict resolution
  • Prebuilt Conflict Handlers
  • Resolution Columns
  • Column Lists
  • Configuring Supplemental Logging
  • Resolving Conflicts with Prebuilt & Custom Update Conflict Handlers
  • Common Data Conflict Errors
  • Print Values from a SYS.AnyData Type
  • Managing Errors
Concepts for Message Queuing
  • Enqueuing Events
  • Subscriptions and Recipient List
  • Creating a Messaging Client
  • Streams Messages with Object Types
  • Dequeuing Messages in Streams
  • Message Handlers
  • Configuring Message Notification & Monitoring Streams Messaging
  • Queue Management Page
Enqueuing & Dequeing Events
  • Enqueuing a Message in Streams
  • Creating User Messages with LCRs
  • Enqueuing a User Created LCR
  • Configuring Propagation of Non LCR Events
  • Dequeuing LCRs & Messages
  • Applying User Created LCR Events
  • Configuring Rule Based Apply of Messages
  • Purging the Staging Queue
Best Practices & Operational Considerations
  • Best Practices for Configuring Streams
  • Archive Logging
  • Capture Process SCN Values & Checkpoints
  • Modifying FIRST_SCN & START_SCN
  • Source Queue Growth
  • NOLOGGING Operations
  • Clock Synchronization
  • Integrating Triggers with Streams
Troubleshooting Oracle Streams
  • Capture Troubleshooting
  • Propagation Troubleshooting
  • Troubleshooting Apply
  • Common Apply Errors
  • Troubleshooting Secure Queue Access