Sign in  |  Register
Advanced search
Publication Cover

CITATION

Deshpande, Kirtikumar. Oracle Streams 11g Data Replication. US: McGraw-Hill Osborne Media, 2010.

Oracle Streams 11g Data Replication

Authors: Kirtikumar Deshpande

Published:  December 2010

eISBN: 9780071759120 0071759123 | ISBN: 9780071496643
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Part I: Introduction to Oracle Streams
  • 1 What Is Oracle Streams
  • Information Flow in Oracle Streams
  • Architectural Overview of Oracle Streams
  • Summary
  • 2 Using Oracle Streams
  • Data Replication
  • Data Warehouse Loading
  • Data Auditing
  • Data Protection
  • Message Queuing
  • Minimizing Downtime During Database Upgrades
  • Minimizing Downtime During Maintenance Tasks
  • Summary
  • Part II: Oracle Streams Concepts and Architecture
  • 3 Streams Rules and Rule Sets
  • Rules
  • Rule Sets
  • Creating Rules and Rule Sets
  • Procedures to Manage Rules and Rule Sets
  • Summary
  • 4 Capture Process
  • Capture Process Types
  • Capture Process Checkpoints and System Change Numbers
  • Creating the Capture Process
  • Capture Process Components
  • Capture Process Parameters
  • What Changes Are Not Captured?
  • NOLOGGING Operations
  • Supplemental Logging
  • Summary
  • 5 Staging and Propagation Process
  • Queue Models
  • Queue Types
  • How Streams Clients Use Queues
  • Creating a Streams Queue
  • Propagation
  • Summary
  • 6 Apply Process
  • Overview of the Apply Process
  • Apply Process States
  • Apply Process Components
  • Apply User
  • Creating the Apply Process
  • Apply Process Parameters
  • Handling Triggers
  • Handling Column Discrepancies
  • Handling Transaction Dependencies
  • Message Processing by the Apply Process
  • What Changes Are Not Applied?
  • Summary
  • 7 Logical Change Records
  • Row LCRs
  • DDL LCRs
  • Extra Attributes in LCRs
  • Accessing LCR Contents
  • Modifying LCR Contents
  • LCRs and LOB Data Types
  • Summary
  • Part III: Oracle Streams Configuration
  • 8 Configuring Oracle Streams for Data Replication
  • Streams Configuration Methods
  • Prerequisite Tasks
  • Streams Configuration Using MAINTAIN Procedures
  • Streams Configuration Using Custom Scripts
  • Summary
  • 9 Data Transformations
  • Types of Rule-Based Transformations
  • Where to Use Rule-Based Transformations
  • Finding the Rule Name
  • Configuring Declarative Rule-Based Transformations
  • Rule-Based Transformations and DDL Replication
  • Configuring Custom Rule-Based Transformations
  • Removing Rule-Based Transformations
  • Table Subset Rule Transformations
  • Transformation Execution Order
  • Summary
  • 10 Handling Data Conflicts
  • Type of Conflicts
  • How to Avoid Conflicts
  • Resolving Conflicts
  • Using the Prebuilt Update Conflict Handler
  • Stopping Conflict Detection for Non-Key Columns
  • Custom Conflict Handlers
  • Summary
  • Part IV: Oracle Streams Management
  • 11 Managing and Monitoring Streams Replication
  • Managing Streams Processes
  • Monitoring Streams Processes
  • Monitoring Transactions
  • Split and Merge: Managing and Monitoring
  • Streams Performance Advisor
  • Summary
  • 12 Maintenance and Troubleshooting
  • Expanding the Streams Environment
  • Removing Streams Configuration
  • Troubleshooting Streams Processes
  • Streams Message Tracking
  • Streams Health Check Report
  • Data Comparison and Convergence
  • Summary
  • 13 Streams Performance Considerations
  • Streams Queue Spilling
  • Apply Spilling
  • Handling Large Transactions
  • Handling Long-Running Transactions
  • Log Mining Activity
  • Capture Process Considerations
  • Propagation Process Considerations
  • Apply Process Considerations
  • Bug Fixes
  • Summary
  • 14 Oracle Enterprise Manager Grid Control for Streams Replication
  • Streams Configuration Wizards
  • Creating Schema-Level Replication
  • Monitoring and Managing the Streams Replication Environment
  • Streams Metrics and Alerts
  • Summary
  • Part V: Appendixes
  • A: Oracle Streams Best Practices
  • Oracle Patches
  • ARCHIVELOG Mode and Archived Log Files
  • Tablespace for Streams
  • Streams Administrator User Account
  • Streams Administrator Privileges
  • Database Initialization Parameters
  • Database Links
  • Network Tuning
  • Heartbeat Table
  • DDL Replication
  • Establish Performance Goals
  • B: Oracle Streams Replication in a RAC Environment
  • Archived Logs
  • Streams Queues
  • Queue-to-Queue Propagation
  • Checking Queue Table and Streams Process Locations
  • Creating Standby Redo Log Groups for Downstream Capture
  • C: Streams Health Check Report
  • How to Run the Streams Health Check Script
  • When to Run the Streams Health Check Script
  • How to Use the Health Check Report
  • D: Data Dictionary Views for Streams Replication
  • Views for Configuration and Administrative Tasks
  • Views for Capture Process
  • Views for Apply Process
  • Views for Propagation Process
  • Views for Rules and Rule Sets
  • Views for Instantiation
  • Views for Supplemental Logging
  • Views for Handlers
  • Views for Conflict Handlers
  • Views for Transformations
  • Views for LogMiner
  • Views for Archived Log/Redo Log Files
  • View for Transactions
  • Views for Queues and Queue Tables
  • E: References
  • Index