Mantieni tutto organizzato con le raccolte
Salva e classifica i contenuti in base alle tue preferenze.
Questa sezione descrive come configurare il database Oracle di origine in modo che Datastream possa estrarre i dati. Datastream può estrarre le modifiche ai dati dai database Oracle on-premise o ospitati sul cloud, incluso Oracle Relational Database Service (RDS).
Datastream può utilizzare i seguenti metodi per eseguire query sui file di log di ripetizione:
Lettore di log binari (Anteprima): seleziona questo metodo se devi eseguire query sui file di log di ripetizione sia online che archiviati. Il Lettore di file binari può accedere ai file di log utilizzando gli oggetti della directory del database o Automatic Storage Management (ASM). Questo metodo è multithread e supporta la CDC a bassa latenza.
API LogMiner: seleziona questo metodo se devi lavorare solo con i file di log di ripetizione archiviati. Oracle LogMiner è a thread singolo e può essere soggetto a una latenza più elevata e a un throughput inferiore. Tuttavia, questo metodo supporta la maggior parte dei tipi di dati e delle funzionalità del database Oracle.
[[["Facile da capire","easyToUnderstand","thumb-up"],["Il problema è stato risolto","solvedMyProblem","thumb-up"],["Altra","otherUp","thumb-up"]],[["Difficile da capire","hardToUnderstand","thumb-down"],["Informazioni o codice di esempio errati","incorrectInformationOrSampleCode","thumb-down"],["Mancano le informazioni o gli esempi di cui ho bisogno","missingTheInformationSamplesINeed","thumb-down"],["Problema di traduzione","translationIssue","thumb-down"],["Altra","otherDown","thumb-down"]],["Ultimo aggiornamento 2025-09-04 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."]]
