Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Oracle Streams
Chapter 3 - Streams Replication

Issues with Down Streams Capture

However, the use of Down Streams capture is not without its shortcomings. There is unavoidable delay in capturing the database changes since the Down Streams Capture process needs to wait for the log switching of the redo log file and the subsequent copying of the archive log file from the source database to the Down Streams database.

The Down Steams capture configuration requires an intermediate host and the database system, which is an additional expense. A new Oracle database instance has to be dedicated to host the Down Streams capture.

Configuration of Down Streams Capture

Operational Requirements

The source database needs to be at least the Oracle 10g release.  At the same time, the downstream capture database should be of the same version as that of the source database.

The operating system on the source site and downstream capture site must be the same, but the operating system release does not need to be the same. For example, a 32-bit operating system is in use on the source database host, the same 32-bit operating system must be maintained at the downstream database host. Other hardware elements, such as the number of CPUs, memory size, and storage configuration, can be different between the source and downstream sites.

The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.