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