Oracle Streams 11g Data Replication

Master Oracle Streams 11g Replication

Enable real-time information access and data sharing across your distributed framework using the expert information in this Oracle Press guide. Oracle Streams 11g Data Replicationexplains how to set up and administer a unified enterprise data sharing infrastructure. Learn how to capture, propagate, and apply database changes, transform data, and handle data conflicts. Monitoring, optimizing, and troubleshooting techniques are also covered in this comprehensive volume.

• Understand Oracle Streams components and architecture
• Gain in-depth knowledge about capturing, propagating, and applying data manipulation language (DML) and data definition language (DDL) changes
• Learn how to access and modify the contents of Logical Change Records
• Build custom procedures for data transformations
• Configure Oracle Streams replication for the database, schemas, and tables
• Tune Oracle Streams performance for improved throughput
• Manage and monitor Oracle Streams using Oracle Enterprise Manager Grid Control
• Learn from several practical examples and scripts

Table of Contents

Part I: Introduction to Oracle Streams
1 What Is Oracle Streams
2 Using Oracle Streams

Part II: Oracle Streams Concepts and Architecture
3 Streams Rules and Rule Sets
4 Capture Process
5 Staging and Propagation Process
6 Apply Process
7 Logical Change Records

Part III: Oracle Streams Configuration
8 Configuring Oracle Streams for Data Replication
9 Data Transformations
10 Handling Data Conflicts

Part IV: Oracle Streams Management
11 Managing and Monitoring Streams Replication
12 Maintenance and Troubleshooting
13 Streams Performance Considerations
14 Oracle Enterprise Manager Grid Control for Streams Replication

Part V: Appendixes
A: Oracle Streams Best Practices
B: Oracle Streams Replication in a RAC Environment
C: Streams Health Check Report
D: Data Dictionary Views for Streams Replication
E: References