Hub and Spoke Streams Replication Setup between 3 Databases
(Doc ID 462102.1)
Last updated on AUGUST 31, 2023
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.1 to 12.1.0.2
Goal
Hub-n-Spoke replication has typically a single Hub database to which all the other Spoke databases will be replicating. The changes (DML & DDL) originated on the Hub will be replicated to all the Spoke databases. The changes made by any other databases will replicate to Hub and Hub will replicate these changes to all other Spokes except the Spoke where change is originated.
The Sample Code performs Streams Replication between three databases on a schema level. The changes (DML & DDL) from any one of these database will replicate to the other two databases.
The following is Description of Streams Replication Setup:
All the databases are running on 10gR2 (code is tested on 10.2.0.4).
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Requirements |
| Configuring |
| Instructions |
| Sample Code |
| Sample Output |
| References |