This content has been marked as final. Show 2 replies
Streams can do this, so can GoldenGate. Both are "checkpoint aware" in the sense that they know where to start from upon startup. Streams is free, already paid for in licensing for the RDBMS; GoldenGate is an extra cost item/application.
If using Streams, you do have some limitations in terms of performance. If you are using Enterprise Edition, you're good to go, but if using Standard Edition, Streams doesn't perform as well and it is better suited for smaller amounts of data/fewer tables.
The DBs that this would be used on are most likely considered pretty small. My main concern is reliability. I need it to be as close to "set and forget" as possible, and if the primary DB dies the secondary can be used while the primary is repaired/replaced,etc.