Oracle Streams 11g Data Replication

Contents......Page 16
Acknowledgments......Page 26
Introduction......Page 28
Part I: Introduction to Oracle Streams......Page 34
1 What Is Oracle Streams......Page 36
Information Flow in Oracle Streams......Page 38
Architectural Overview of Oracle Streams......Page 39
Summary......Page 50
2 Using Oracle Streams......Page 52
Data Replication......Page 53
Data Warehouse Loading......Page 59
Data Protection......Page 60
Minimizing Downtime During Database Upgrades......Page 61
Minimizing Downtime During Maintenance Tasks......Page 62
Summary......Page 63
Part II: Oracle Streams Concepts and Architecture......Page 64
3 Streams Rules and Rule Sets......Page 66
Rules......Page 67
Rule Sets......Page 69
Creating Rules and Rule Sets......Page 73
Procedures to Manage Rules and Rule Sets......Page 95
Summary......Page 96
4 Capture Process......Page 98
Capture Process Types......Page 99
Capture Process Checkpoints and System Change Numbers......Page 104
Creating the Capture Process......Page 108
Capture Process Components......Page 120
Capture Process Parameters......Page 121
What Changes Are Not Captured?......Page 125
NOLOGGING Operations......Page 130
Supplemental Logging......Page 132
Summary......Page 137
5 Staging and Propagation Process......Page 140
Queue Models......Page 141
Queue Types......Page 142
Creating a Streams Queue......Page 144
Propagation......Page 148
Summary......Page 164
6 Apply Process......Page 166
Overview of the Apply Process......Page 167
Apply Process Components......Page 168
Apply User......Page 172
Creating the Apply Process......Page 173
Apply Process Parameters......Page 181
Handling Triggers......Page 186
Handling Column Discrepancies......Page 189
Handling Transaction Dependencies......Page 191
Message Processing by the Apply Process......Page 194
What Changes Are Not Applied?......Page 206
Summary......Page 207
7 Logical Change Records......Page 210
Row LCRs......Page 211
DDL LCRs......Page 213
Extra Attributes in LCRs......Page 215
Accessing LCR Contents......Page 216
Modifying LCR Contents......Page 229
LCRs and LOB Data Types......Page 234
Summary......Page 236
Part III: Oracle Streams Configuration......Page 238
8 Configuring Oracle Streams for Data Replication......Page 240
Streams Configuration Methods......Page 241
Prerequisite Tasks......Page 242
Streams Configuration Using MAINTAIN Procedures......Page 251
Streams Configuration Using Custom Scripts......Page 270
Summary......Page 298
9 Data Transformations......Page 300
Types of Rule-Based Transformations......Page 301
Where to Use Rule-Based Transformations......Page 303
Finding the Rule Name......Page 304
Configuring Declarative Rule-Based Transformations......Page 305
Rule-Based Transformations and DDL Replication......Page 314
Configuring Custom Rule-Based Transformations......Page 315
Removing Rule-Based Transformations......Page 322
Transformation Execution Order......Page 326
Summary......Page 327
10 Handling Data Conflicts......Page 330
Type of Conflicts......Page 331
How to Avoid Conflicts......Page 333
Resolving Conflicts......Page 335
Using the Prebuilt Update Conflict Handler......Page 336
Stopping Conflict Detection for Non-Key Columns......Page 343
Custom Conflict Handlers......Page 345
Summary......Page 351
Part IV: Oracle Streams Management......Page 352
11 Managing and Monitoring Streams Replication......Page 354
Managing Streams Processes......Page 355
Monitoring Streams Processes......Page 371
Monitoring Transactions......Page 384
Split and Merge: Managing and Monitoring......Page 386
Streams Performance Advisor......Page 391
Summary......Page 394
12 Maintenance and Troubleshooting......Page 396
Expanding the Streams Environment......Page 397
Removing Streams Configuration......Page 404
Troubleshooting Streams Processes......Page 411
Streams Message Tracking......Page 429
Data Comparison and Convergence......Page 432
Summary......Page 438
13 Streams Performance Considerations......Page 440
Streams Queue Spilling......Page 441
Apply Spilling......Page 442
Handling Large Transactions......Page 443
Handling Long-Running Transactions......Page 446
Log Mining Activity......Page 447
Capture Process Considerations......Page 448
Propagation Process Considerations......Page 449
Apply Process Considerations......Page 450
Summary......Page 455
14 Oracle Enterprise Manager Grid Control for Streams Replication......Page 456
Streams Configuration Wizards......Page 457
Creating Schema-Level Replication......Page 459
Monitoring and Managing the Streams Replication Environment......Page 465
Streams Metrics and Alerts......Page 485
Summary......Page 487
Part V: Appendixes......Page 488
A: Oracle Streams Best Practices......Page 490
Tablespace for Streams......Page 491
Database Links......Page 492
Network Tuning......Page 493
Heartbeat Table......Page 496
Establish Performance Goals......Page 497
B: Oracle Streams Replication in a RAC Environment......Page 498
Streams Queues......Page 499
Queue-to-Queue Propagation......Page 500
Creating Standby Redo Log Groups for Downstream Capture......Page 501
C: Streams Health Check Report......Page 504
How to Run the Streams Health Check Script......Page 505
How to Use the Health Check Report......Page 506
D: Data Dictionary Views for Streams Replication......Page 512
Views for Configuration and Administrative Tasks......Page 513
Views for Capture Process......Page 514
Views for Apply Process......Page 515
Views for Rules and Rule Sets......Page 516
Views for Instantiation......Page 517
Views for Conflict Handlers......Page 518
View for Transactions......Page 519
Views for Queues and Queue Tables......Page 520
E: References......Page 522
A......Page 524
C......Page 526
D......Page 528
E......Page 532
I......Page 533
L......Page 534
M......Page 535
O......Page 537
P......Page 538
R......Page 539
S......Page 541
T......Page 543
U......Page 544
X......Page 545