Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Bagian ini menjelaskan cara mengonfigurasi database Oracle sumber agar Datastream dapat mengambil data darinya. Datastream dapat mengambil perubahan pada data dari database Oracle lokal atau yang dihosting di cloud, termasuk layanan database relasional Oracle (RDS).
Datastream dapat menggunakan metode berikut untuk membuat kueri file log redo:
Pembaca log biner (Pratinjau): pilih metode ini jika Anda perlu membuat kueri file log redo online dan yang diarsipkan. Pembaca biner dapat mengakses file log menggunakan Automatic Storage Management (ASM) atau objek direktori database. Metode ini bersifat multi-thread dan mendukung CDC latensi rendah.
LogMiner API: pilih metode ini jika Anda hanya perlu menggunakan file log redo yang diarsipkan. Oracle LogMiner adalah single-thread dan dapat mengalami latensi yang lebih tinggi dan throughput yang lebih rendah. Namun, metode ini mendukung sebagian besar jenis data dan fitur database Oracle.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-12 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,["# Configure a source Oracle database\n\nThis 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).\n\nDatastream can use the following methods to query redo log files:\n\n- **Binary log reader** ([Preview](/products#product-launch-stages)): 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.\n\n- **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.\n\n For more information about these methods, see\n [Overview of Oracle as a source](/datastream/docs/sources-oracle#behavior)\n and [Work with Oracle database redo log files](/datastream/docs/work-with-oracle-database-redo-log-files).\n For information about how to configure your database type for each of these\n methods, see the respective configuration pages.\n\nSupported databases\n-------------------\n\nDatastream works with the following types of Oracle databases:\n\n- Amazon RDS for Oracle\n- Self-managed Oracle database\n- Self-hosted Oracle pluggable database\n\nWhat's next\n-----------\n\n- Learn how to configure an [Amazon RDS for Oracle](/datastream/docs/configure-amazon-rds-oracle) database to work with Datastream.\n- Learn how to configure a [self-managed Oracle database](/datastream/docs/configure-self-managed-oracle) to work with Datastream.\n- Learn how to configure a [self-hosted Oracle pluggable database](/datastream/docs/configure-pluggable-oracle) to work with Datastream."]]
