Stay organized with collections
Save and categorize content based on your preferences.
This section describes how to configure your source Oracle database so that Datastream can pull data from it. Datastream can pull changes to data from on-premises or cloud-hosted Oracle databases, including Oracle relational database service (RDS).
Datastream can use the following methods to query redo log files:
Binary log reader (Preview): select this method if you need to query both online and archived redo log files. Binary reader can access the log files using Automatic Storage Management (ASM) or database directory objects. This method is multithreaded and supports low-latency CDC.
LogMiner API: select this method if you only need to work with archived redo log files. The Oracle LogMiner is single-threaded and can be subject to higher latency and lower throughput. However, this method supports most data types and Oracle database features.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["\u003cp\u003eDatastream extracts data changes from on-premises or cloud-hosted Oracle databases, including Oracle RDS.\u003c/p\u003e\n"],["\u003cp\u003eDatastream can utilize either a binary log reader or the LogMiner API to query redo log files, each with different capabilities and performance characteristics.\u003c/p\u003e\n"],["\u003cp\u003eThe binary log reader method is recommended for querying both online and archived redo log files, offering multithreaded processing and low-latency CDC.\u003c/p\u003e\n"],["\u003cp\u003eThe LogMiner API is suitable for working solely with archived redo log files, supporting most data types and Oracle database features, but with potentially higher latency.\u003c/p\u003e\n"],["\u003cp\u003eDatastream supports Amazon RDS for Oracle, self-managed Oracle databases, and self-hosted Oracle pluggable databases.\u003c/p\u003e\n"]]],[],null,[]]
