① Viewing Basic Information and Enabling Archive Logs

Version

Function Description

By enabling Change Data Capture (CDC) for the data source, you can synchronize real-time data from data sources and the physical deletion of data tables using the Data Pipeline function of FineDataLink.

Data Pipeline supports two CDC modes for Oracle, namely XStream and LogMiner. This document primarily introduces how to enable the LogMiner-based CDC for Oracle databases.

Note:

You are advised to use INSERT statements to add data. Manually inserting records using database management tools (for example, DBeaver) is not advised.

Data Pipeline supports data reading from Oracle databases of the following versions.

Log in to the database as the database admin.

For example, for Oracle installed on a Windows system, enter sqlplus / as sysdba in the command prompt to go to the database operation page.

You can also check the current database version, as shown in the following figure.

1. Log in to the database as the database admin.

2. Use the command to check the logging mode of the database:

select log_mode from v$database;

If the returned result is ARCHIVELOG, archive logging is already enabled.

If the result returned is NOARCHIVELOG, continue with the following steps:

• Log in to the server: sqlplus / as sysdba

• Shut down the database: shutdown immediate;

• Start and mount the database: startup mount;

• Enable archiving and open the database:

alter database archivelog;
alter database open;