Downstream Capture — avoid white water at the source
In Chapter 1, we briefly mention Downstream Capture(DSC) and how it can be used to offload the Capture and Propagation processes off a Production/Source Server. In this section, we will take a deeper dive into DSC and cover:
What is DSC?
When to use DSC?
How to set up DSC?
By covering the above with the example provided, you should have the information needed to understand and properly use DSC.
DSC is a configuration of Streams that has the Capture and Propagation Process on a different server from where the data is processed. Recall the first image that was seen in Chapter 1 of DSC.
The Source Production database is where all the transactions are run against. The Worker database receives redo logs from the Source Production database and then the normal Streams process (Capture, Propagate) happens on the Worker database (flowing from left to right in the image) and then the Apply process is at the Target Database. Notice that we wrote that...