Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\img_text\tdpii504.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <title>Description of the illustration tdpii504.eps</title> </head> <body> <p>This illustration shows an Oracle Streams hub-and-spoke replication environment that includes the following Oracle databases:</p> <ul> <li> <p><code>hub.example.com</code></p> </li> <li> <p><code>spoke1.example.com</code></p> </li> <li> <p><code>spoke2.example.com</code></p> </li> </ul> <p>At each database, the local redo log records changes to the <code>hr</code> schema.</p> <p>The <code>hub.example.com</code> database has the following Oracle Streams components configured:</p> <ul> <li> <p>Three queues.</p> </li> <li> <p>A capture process named <code>capture_hns</code> that captures DML changes to the tables in the <code>hr</code> schema from the local redo log. The capture process enqueues these changes into a local queue.</p> </li> <li> <p>A propagation named <code>propagation_spoke1</code> that sends changes from a local queue to a queue at <code>spoke1.example.com</code>.</p> </li> <li> <p>A propagation named <code>propagation_spoke2</code> that sends changes from a local queue to a queue at <code>spoke2.example.com</code>.</p> </li> <li> <p>An apply process named <code>apply_spoke1</code> that dequeues changes that originated at <code>spoke1.example.com</code> from a queue and applies them to the tables in the <code>hr</code> schema.</p> </li> <li> <p>An apply process named <code>apply_spoke2</code> that dequeues changes that originated at <code>spoke2.example.com</code> from a queue and applies them to the tables in the <code>hr</code> schema.</p> </li> </ul> <p>The <code>spoke1.example.com</code> database has the following Oracle Streams components configured:</p> <ul> <li> <p>Two queues.</p> </li> <li> <p>A capture process named <code>capture_hns</code> that captures DML changes to the tables in the <code>hr</code> schema from the local redo log. The capture process enqueues these changes into a local queue.</p> </li> <li> <p>A propagation named <code>propagation_spoke1</code> that sends changes from a local queue to a queue at <code>hub.example.com</code>.</p> </li> <li> <p>An apply process named <code>apply_spoke1</code> that dequeues changes that originated at <code>hub.example.com</code> and <code>spoke2.example.com</code> from a queue and applies them to the tables in the <code>hr</code> schema.</p> </li> </ul> <p>The <code>spoke2.example.com</code> database has the following Oracle Streams components configured:</p> <ul> <li> <p>Two queues.</p> </li> <li> <p>A capture process named <code>capture_hns</code> that captures DML changes to the tables in the <code>hr</code> schema from the local redo log. The capture process enqueues these changes into a local queue.</p> </li> <li> <p>A propagation named <code>propagation_spoke2</code> that sends changes from a local queue to a queue at <code>hub.example.com</code>.</p> </li> <li> <p>An apply process named <code>apply_spoke2</code> that dequeues changes that originated at <code>hub.example.com</code> and <code>spoke1.example.com</code> from a queue and applies them to the tables in the <code>hr</code> schema.</p> </li> </ul> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de