Streams Replication Configuration

Prerequisites

• Streams configuration Checklist
• Listener Configuration (RAC database)
• Streams Optimizations

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

• It is recommended to separate the queues for the capture and the apply processes.
• Please review: https://twiki.cern.ch/twiki/bin/view/PSSGroup/StreamsRecommendations

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).
  • Downstream database configuration
• 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

• Streams monitoring

Documentation

• Oracle® Streams Concepts and Administration 10g Release 2 (10.2)
• Oracle® Streams Replication Administrator's Guide 10g Release 2 (10.2)