WARNING: This web is not used anymore. Please use PDBService.StreamsReplicationConfiguration instead!
 

Streams Replication Configuration

Overview of how to create a single-source replication environment using Streams.

Prerequisites

Streams administrator user and database links

  • Create the Streams administrator named strmadmin and grant this user the necessary privileges.
    • These privileges enable the user to manage queues, execute subprograms in packages related to Streams, create rule sets, create rules, and monitor the Streams environment by querying data dictionary views and queue tables.
    • It is recommended to create a separate tablespace fro the streams administrator schema.
    • Example: create_strmadmin_10g.sql
  • Create the database link from the database where changes are captured to the database where changes are propagated.
    • Example:
      CREATE DATABASE LINK test3d.cern.ch CONNECT TO strmadmin IDENTIFIED BY strmadminpw USING 'test3d.cern.ch'; 

Supplemental logging

  • Confirm supplemental logging at the source site.
    • 10gR2: supplemental logging is automatically configured for tables on which primary, unique or foreign keys are defined when the database object is prepared for Streams capture.
    • To specify supplemental logging for all primary key, unique key, bitmap index, and foreign key columns in a source database, issue the following SQL statement:
      ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE, FOREIGN KEY) COLUMNS;

Capture, propagation and apply processes

Capture process configuration

  • The capture process scans the database redo log to capture DML and DDL changes made to database objects.
  • To list unsupported database objects, query the DBA_STREAMS_UNSUPPORTED data dictionary view at the source database.
  • It can run on the source database ( local capture process) or on a remote database (downstream capture process).
  • Example: CAPTURE_Streams_SOURCE.sql

Propagation process configuration

  • A propagation propagates messages from a Streams source queue to a Streams destination queue.
  • 10gR2: set the queue_to_queue propagation parameter to TRUE.
  • Example: PROPAGATION_Streams_SOURCE.sql

Apply process configuration

  • A Streams apply process dequeues logical change records (LCRs) from a specific queue and applies each one.
  • Example: APPLY_Streams_DESTINATION.sql

Streams monitoring

Documentation

  • Oracle® Streams Concepts and Administration 10g Release 2 (10.2)
  • Oracle® Streams Replication Administrator's Guide 10g Release 2 (10.2)
Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatsql APPLY_Streams_DESTINATION.sql r1 manage 2.3 K 2007-06-14 - 15:41 EvaDafonte  
Unknown file formatsql CAPTURE_Streams_SOURCE.sql r1 manage 2.0 K 2007-06-14 - 15:18 EvaDafonte  
Unknown file formatsql PROPAGATION_Streams_SOURCE.sql r1 manage 1.4 K 2007-06-14 - 15:35 EvaDafonte  
Unknown file formatsql create_strmadmin_10g.sql r1 manage 0.8 K 2007-06-14 - 14:51 EvaDafonte  
Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2008-10-21 - EvaDafonte
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright &© 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback