Home >Common Problem >OGG common commands

OGG common commands

zbt
zbtOriginal
2023-11-15 10:00:281920browse

OGG commonly used commands include ADD EXTRACT, START EXTRACT, START REPLICAT, STOP EXTRACT, STOP REPLICAT, STATS, ALTER EXTRACT/REPLICAT and DELETE EXTRACT/REPLICAT. You can manage and control OGG's data extraction and copying process by entering these commands in the OGG command line interface or management interface.

OGG common commands

OGG(Oracle GoldenGate) is a software for real-time data integration and replication. It can extract, convert and load data between different databases. The following are some commonly used OGG commands:

1.: Used to add a new data extraction process to the OGG configuration file. You can create a new extraction process by specifying source and target databases, tables, and filter conditions.

2. ADD REPLICAT: used to add a new data replication process to the OGG configuration file. You can create a new replication process by specifying source and target databases, tables, and filter conditions.

3. START EXTRACT: Start the specified data extraction process and start extracting data from the source database to OGG.

4. START REPLICAT: Start the specified data replication process and start copying the data in OGG to the target database.

5. STOP EXTRACT: Stop the specified data extraction process and stop extracting data from the source database to OGG.

6. STOP REPLICAT: Stop the specified data replication process and stop copying data from OGG to the target database.

7. STATS: Used to view statistical information of the OGG process, including the number of extracted records, the number of copied records, etc.

8. INFO: Used to view detailed information of the OGG process, including configuration parameters, running status, etc.

9. ALTER EXTRACT/REPLICAT: Used to modify the configuration parameters of the created data extraction or replication process.

10. DELETE EXTRACT/REPLICAT: Delete the specified data extraction or copy process from the OGG configuration file.

These are some common commands of OGG. You can manage and control the data extraction and copying process of OGG by entering these commands in the OGG command line interface or management interface. For specific command usage methods and parameters, you can refer to OGG's official documentation or use the help command to obtain it.

The above is the detailed content of OGG common commands. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn