My Oracle Support Banner

Master Note for Streams Downstream Capture - 10g and 11g [Video] (Doc ID 1264598.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.1.0.2 to 11.2.0.2


Purpose

This note provides background and troubleshooting information applicable in a Streams Downstream Capture Environment . Its main purpose as a master note is to bring together reference material in a form which allows a clear understanding of what is required in the configuration as well as to where to look when there are issues. Its focus is setup and understanding relevant parameters settings which are required.

Scope

This document is intended for anyone with an interest in understanding Streams downstream capture. Where scripts details are references these are provided for reference to DBAs and Application developers. It is likely these will require modification in view of the fact that the examples presented are for illustration purposes. In order to have a better insight into how the examples work, please ensure you have read and understood the information below.

Whilst every care has been taken to ensure that the details are correct and accurate , code should be thoroughly tested to verify it is fit for intended purpose.

Please note , the approach adopted in relation to knowledge has been to improve Oracle's product documentation . Thus, relevant content in relation to downstream capture is now found in the primary reference guides for Streams ; if possible, please refer to the latest documentation :

- Streams Concepts and Administration;
- Streams Replication Administrator's Guide

A useful reference in relation to downstream capture specific details is found in : Streams Configuration Best practices ; this was created with respect to 10.2 but is applicable to all later versions.

Details

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
Purpose
Scope
Details
 Downstream Capture
 Requirements
 Limitation
 Advantages
 Real-Time Downstream Capture
 Archived-Log Downstream Capture
 Transport Considerations in Downstream Capture
 Instantiation - Implications for Primary Database
 Create Capture
 Prepare {tables|schema|database} instantiation
 Add {tables|schema|database} rules
 Set {table|schema|database} instantiation scn
 Recommended Parameter Settings
 Real-Time Downstream Capture Parameter Values
 Primary database
 Downstream Database
 Archived-Log Downstream Capture Parameter Values
 Primary database
 Downstream Database
 TroubleShooting
 Errors
 Tracing Log Transport Issues
 Performance Issues
 Ongoing Streams Related Activities on the Primary Database
 Frequently asked question (FAQ) on Downstream capture
 1. What are the minimum steps needed to execute on the Source database for configuring downstream ?
 2. When using downstream capture, list all the steps to be accomplished on the development (downstream) database, or will an intermediate database need to be configured?
 3. Will Streams replication work successfully on two databases with the same name (on different servers)?
 4. Would it be better to use downstream capture instead of source database capture when replicating schema's from a production database to a development database ?
 5. Is it necessary to create capture, propagate and apply on downstream database?
 6. Where do you add the propagation rules for downstream capture?
 7. According to the note, 274456.1, we need to set the parameter, REMOTE_ARCHIVE_ENABLE, to TRUE.However, this parameter is obsolete on 10.2.0.1. How can we deal with this ?
 8. Is archivelog mode required for both source and target ?
 9. If we manually copy the archivelogs ,where will it be copied ?How the Capture process identifies the location of archive logs of source Database ?
 10. If archive logs are shipped manually from source to destination database.Do we need to setup all the init.ora parameters specified in Note 418755.1 Master Note for Streams Recommended Configuration ?
 11. How to unregister logfile that have been registered using: ALTER DATABASE REGISTER LOGICAL LOGFILE ?
 12.Can we configure Downstream Capture at Database Global Level ?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.