Oracle 9i. Replication

Urbano R.

Oracle 9i Replication describes the features and functionality of the Oracle Replication. Specifically, OracIe 9i Replication contains conceptual information about Oracle Replication, as well as information about planning your replication environment and troubleshooting replication problems. Oracle 9i Replication also contains an introduction to the Replication Management tool in Oracle Enterprise Manager.

---

Table of contents :
Send Us Your Comments……Page 9
Preface……Page 11
What’s New in Replication?……Page 19
1 Introduction to Replication……Page 37
Replication Overview……Page 38
Applications That Use Replication……Page 39
Replication Objects……Page 40
Replication Sites……Page 41
Multimaster Replication……Page 42
Materialized View Replication……Page 44
Multimaster and Materialized View Hybrid Configurations……Page 50
Administration Tools for a Replication Environment……Page 51
Replication Management Tool in Oracle Enterprise Manager……Page 52
Distributed Schema Management……Page 53
Replication Conflicts……Page 54
Procedural Replication……Page 55
2 Master Replication Concepts and Architecture……Page 57
What is Master Replication?……Page 58
Why Use Multimaster Replication?……Page 60
Multimaster Replication Process……Page 63
Conflict Resolution Concepts……Page 66
Replication of User-Defined Types……Page 68
Master Site Mechanisms……Page 74
Administrative Mechanisms……Page 87
Organizational Mechanisms……Page 93
Propagation Mechanism……Page 96
Performance Mechanisms……Page 103
Replication Protection Mechanisms……Page 109
Conflict Resolution Mechanisms……Page 113
3 Materialized View Concepts and Architecture……Page 115
What is a Materialized View?……Page 116
Why Use Materialized Views?……Page 117
Read-Only, Updatable, and Writeable Materialized Views……Page 119
Available Materialized Views……Page 121
Required Privileges for Materialized View Operations……Page 128
Data Subsetting with Materialized Views……Page 132
Determining the Fast Refresh Capabilities of a Materialized View……Page 144
Multitier Materialized Views……Page 145
Materialized Views with User-Defined Types……Page 151
Materialized View Registration at a Master Site or Master Materialized View Site……Page 163
Materialized View Architecture……Page 165
Master Site and Master Materialized View Site Mechanisms……Page 167
Materialized View Site Mechanisms……Page 171
Organizational Mechanisms……Page 175
Refresh Process……Page 180
4 DeploymentTemplates Concepts and Architecture……Page 187
Mass Deployment Challenge……Page 188
Oracle Deployment Templates Concepts……Page 189
Deployment Template Elements……Page 190
Deployment Template Packaging and Instantiation……Page 195
Template Definitions Stored in System Tables……Page 200
Packaging and Instantiation Process……Page 202
After Instantiation……Page 205
Column Subsetting with Deployment Templates……Page 207
Row Subsetting……Page 209
Data Sets……Page 213
Local Control of Materialized View Creation……Page 215
5 Conflict Resolution Concepts and Architecture……Page 217
Conflict Resolution Concepts……Page 218
Understanding Your Data and Application Requirements……Page 219
Types of Replication Conflicts……Page 220
Conflict Detection……Page 222
Conflict Resolution……Page 223
Techniques for Avoiding Conflicts……Page 234
Support Mechanisms……Page 238
Common Update Conflict Resolution Methods……Page 240
Additional Update Conflicts Resolution Methods……Page 244
Uniqueness Conflicts Resolution Methods……Page 254
Performance Mechanisms and Conflict Resolution……Page 256
6 Planning Your Replication Environment……Page 265
Datatype Considerations……Page 266
Initialization Parameters……Page 268
Master Sites and Materialized View Sites……Page 272
Advantages of Materialized View Sites……Page 273
Preparing for Materialized Views……Page 274
Creating a Materialized View Log……Page 280
Creating a Materialized View Environment……Page 282
Avoiding Problems When Adding a New Materialized View Site……Page 284
Guidelines for Scheduled Links……Page 285
Scheduling Periodic Pushes……Page 286
Scheduling Continuous Pushes……Page 287
Guidelines for Scheduled Purges of a Deferred Transaction Queue……Page 288
Scheduling Periodic Purges……Page 289
Scheduling Continuous Purges……Page 290
Serial and Parallel Propagation……Page 291
Preparing Materialized View Sites for Instantiation of Deployment Templates……Page 292
Security……Page 295
Designing for Survivability……Page 296
Oracle Real Application Clusters versus Replication……Page 297
Designing a Replication Environment for Survivability……Page 298
Implementing a Survivable System……Page 299
7 Replication Management Tool Introduction……Page 301
Usage Scenarios for the Replication Management Tool……Page 302
Logging in to the Replication Management Tool……Page 303
The Replication Management Tool Interface……Page 304
Navigator Pane……Page 305
Right Pane……Page 309
The Replication Management Tool Wizards……Page 315
Setup Wizard……Page 316
Materialized View Group Wizard……Page 319
Deployment Template Wizard……Page 320
Template Script Generation Wizard……Page 322
Copy Template Wizard……Page 323
Flowchart for Creating a Replication Environment……Page 325
A Troubleshooting Replication Problems……Page 327
Diagnosing Problems with Master Sites……Page 328
DDL Changes Not Propagated to Master Site……Page 329
Bulk Updates and Constraint Violations……Page 330
Problems with Replicated Procedures or Triggers……Page 331
Problems With ON DELETE CASCADE and Integrity Constraints……Page 332
Incorrect Replication Catalog Views……Page 333
Problems Creating Replicated Objects at Materialized View Site……Page 334
Refresh Problems……Page 335
Advanced Troubleshooting of Refresh Problems……Page 337
B Replication Support for Column Length Semantics and Unicode……Page 339
Column Length Semantics for Replication Sites and Table Columns……Page 340
Column Length Semantics Support for Tables Generated by Oracle Replication……Page 341
Column Length Semantics Support for Precreated Tables……Page 342
Materialized Views with Prebuilt Container Tables……Page 343
Column Length Semantics Support for Updatable Materialized Views……Page 344
DDL Propagation and Column Length Semantics……Page 345
Replication Support for Unicode……Page 346
Replication of NCLOB Datatype Columns……Page 347
Index……Page 349