Audience:
- Business Intelligence Developer
- Database Administrators
- Sales Consultants
- Support Engineer
- Technical Consultant
Required Prerequisites:
- Oracle Database 10g: Administration Workshop I Release 2
Course Objectives:
- Quickly and easily configure an Oracle Streams environment
- Monitor the capture, propagation, and apply of events
- Alter the Streams environment to add new sites or objects
- Configure conflict handling for data replication
- Transform the data being replicated between two sites
- Enqueue and dequeue messages using Oracle Streams
- Perform basic troubleshooting of a Streams environment
Course Topics:
Introduction and Overview
- Oracle Streams: Basic Elements
- Capture and Event Staging
- Staging Area Propagation
- Rules Engine
- Oracle Streams with Single-Source and Multiple-Source Database
- Oracle Streams Usage: Scenarios
- Using Oracle Streams for Upgrades and Migrations
- Interfaces to Oracle Streams
Database Configuration
- Configuring Database Parameters
- Configuring Archive Logging
- Supplemental Logging
- Database Configuration with Enterprise Manager
- Configuring Communication Between Databases
- Configuring Multiple Streams Sites
- Additional Preparation for File Propagation
Basic Objects of Oracle Streams
- Object Types
- Streams Events
- Logical Change Records (LCRs)
- Creating and Managing a Streams Administrator User
- Staging Area Architecture
- SYS.AnyData 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 System-Created Rules
- Negative Rule Sets
- Rule Evaluation with Negative Rule Sets
- Monitoring Rules
Enterprise Manager Interface to Oracle Streams
- Oracle Streams Manageability Features
- Configuring Oracle Streams
- Streams Setup Page
- Streams Tablespace Replication Wizard
- Capture Management
- Apply Management
- Propagation Management
- Managing Message Transformations
Simplified Streams Configuration
- Simplified Configuration Procedures
- Replicating a Single Tablespace (MAINTAIN_SIMPLE_TTS) and a Set of Tablespaces (MAINTAIN_TTS)
- Instantiating Database Objects
- Replicating Tables, Schemas, and Entire Database
- Improved Diagnostics for Streams
- Removing a Streams Queue
- Removing All Streams Components
Capture Process Concepts
- Capture
- Implicit Event Capture
- Capture Process Components
- Identifying Changes to Capture
- Logical Change Records (LCRs)
- Data Types, DDL and DML Types Captured
- Commands and DDLs Not Captured
- Streams Tags and Downstream Capture
Configuring a Capture Process
- Creating the Capture Process
- Downstream Capture
- Capture Process Parameters
- Starting and Managing the Capture Process
- Monitoring Log File Availability
- Capture Process Statistics
- Troubleshooting Capture
Instantiation
- Performing Instantiation
- Preparing for Instantiation
- Setting the Instantiation SCN
- Import Instantiation and Creation
- Instantiation Using Data Pump
- Setting the Instantiation SCN Manually
- Instantiating a Database Using RMAN
- Verifying Instantiations at an Apply Site
Propagation Concepts and Configuration
- Directed Networks
- Queue and Forwarding
- Apply Forwarding
- Queue-to-Queue Propagation
- Propagation Job, Rules, and Scheduling
- Creating, Managing, and Monitoring Propagation
- Troubleshooting Propogation Configuration
Apply Concepts and Configuration
- Processing Streams Events
- Applying DDL Events
- Error Queue
- Required Apply User Privileges
- Apply Process Components and Rules
- Enqueue Destination and Execution Directives During Apply
- Virtual Dependency Definition
- Apply Process and 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 and a Precommit Handler
- Restrictions for Apply Handler Procedures
- Managing Apply Handlers
- Customizing Apply Handler Actions
- Viewing Apply Handler Information
Administering a Streams Environment
- Managing the Capture Process
- Managing Propagations
- Managing Apply Processes
- Starting and 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 and Objects
Data Conflicts
- What Is a Replication Conflict?
- Error Queue
- Types of Data Conflicts
- Primary and Substitute Key Columns
- Detecting Conflicts
- Data Consistency and Convergence
- Conflict Avoidance and Resolution Foundation
- Site Ownership
Conflict resolution
- Prebuilt Conflict Handlers
- Resolution Columns
- Column Lists
- Configuring Supplemental Logging
- Resolving Conflicts with Prebuilt and Custom Update Conflict Handlers
- Common Data Conflict Errors
- Print Values from a SYS.AnyData Type
- Managing Errors
Message Queuing Concepts
- Enqueuing Events
- Subscriptions and Recipient List
- Creating a Messaging Client
- Streams Messages with Object Types
- Dequeuing Messages in Streams
- Message Handlers
- Configuring Message Notification and Monitoring Streams Messaging
- Queue Management Page
Enqueuing and 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 and Messages
- Applying User-Created LCR Events
- Configuring Rule-Based Apply of Messages
- Purging the Staging Queue
Best Practices and Operational Considerations
- Best Practices for Configuring Streams
- Archive Logging
- Capture Process SCN Values and Checkpoints
- Modifying FIRST_SCN and START_SCN
- Source Queue Growth
- NOLOGGING Operations
- Clock Synchronization
- Integrating Triggers with Streams
Troubleshooting Oracle Streams
- Troubleshooting Capture
- Troubleshooting Propagation
- Troubleshooting Apply
- Common Apply Errors
- Troubleshooting Secure Queue Access