Equnix Business Solutions | an Open Source and Open Mind Company Webinar | Equnix Business Solutions

Real time replication from Oracle to PostgreSQL

Wednesday, December 9th 2020
2.30 PM-5.00 PM (GMT+7)
Speakers will present at 3.00 PM

Real time replication from Oracle to PostgreSQL

smaple image

It is simply just another version of Golden Gate for PostgreSQL, it is called Ark-CDC from ArkData Solutions. By using this tool, you can have a real backup replication from Oracle Database while enabling the migration system into PostgreSQL based Applications.

It guarantees the data will stay intact and preserve the data integrity as before, well proven in mission critical systems. Ora2PG Replication is the real-time heterogeneous DB replication solution for fast and safely replicating data between two different OS and DB environments.

With direct log access, it directly accesses transaction log files and extracts changed data without loading performances of the source server. Replicating heterogeneous DB is possible by sending data to target DBMS in any platform environment.

If you are wondering with the answers of questions below:

  1. 1

    How could ArkCDC ensure data integrity on replication DB/OS?

  2. 2

    How could ArkData do real-time replication while enabling the migration system into PostgreSQL based Applications?

  3. 3

    What is the difference between ArkCDC compared to Oracle Golden Gate?

Join us to hear from experts

Agenda:

In this session, our Experts will explain in-depth knowledge about how ArkCDC can be a solution for the real-time heterogeneous DB replication solution for fast and safely replicating data between two different OS and DB environments.

  1. Registration

  2. Opening Webinar

  3. ArkData Presentation

  4. Live Demo!

  5. QnA & Polling

  6. Quiz & Giveaway

Another Webinar

Webinar Material

Video title

Frequently Asked Questions

Got a question? We've got answers. If you have some other questions, see our support center.

When using an API such as Logminer provided by Oracle or directly accessing the table in TEL, there will be overhead on Oracle DBMS server. However, Ark for CDC directly accesses redo log other than using functions in Oracle server, so there is no overload.
It is installed and executed in source and target as an agent. No separate server is required.
There are two Ark products for database replication, what is the use of Ark for Oracle if you have Ark for CDC?
Ark for CDC can replicate even when the platform and DBMS of source and target is different by using logical replication methods. Whereas, Ark for Oracle performs replication in physical replication within the same platform & same Oracle versions.
The database replicated by Ark for Oracle has to stay the same status as the source database. The row ID has to be the same. It can be used for media recovery.
Ark for CDC uses agents. And the agent needs to be installed in each source and target system and each needs license.
The sync error will be recorded on the log in the process of replicating the data to the target database and the replication will be stopped. If needed, there are functions like skipping the error or controlling for replacement.
Row locking or similar lock issues are not a problem, because Ark for CDC only captures committed transactions only.
Ark for CDC writes and manages the status of databases of extracting data and sending data separately by checkpoint method.
This way, even if there is a database with different replication status, the status can be managed.
No. Since each status of the module is managed separately, so even in the case of a crash, the process will be continued based on the processing status.
As for now the Ark for CDC supports Oracle and MS-SQL server for source DB and almost every RDMS for target DB.
Although ArkData currently does not support Teradata for Source database, we will consider it for a long-term plan.
The DDL is possible in case of Oracle to Oracle replication. As for Oracle to non-oracle replication, only the DML is replicated.
Ark for CDC supports most of DDL in case of Oracle to Oracle replication. However, some like schema control, tablespace change are not supported. The DDL in Oracle to PostgreSQL is not possible.
Even if the internet is disconnected with the target DB, the extracted data is saved separately. If the connection is possible again, the replication will resume.
We don't support identity columns, but in the case of sequence of Oracle, the Oracle to Oracle replication is possible.
Yes, ArkCDC optimized the data migration and replication process on a hybrid platform. One of the keys is ArkCDC has a very little performance impact since it extracts the data changes by reading the REDO LOG.
Yes. That's correct. The same server has to be installed as for the source. If the target cannot install the agent like PaaS, the agent can be installed in the compute node.
The research for what you asked is finished and the functions will be added on the next release.
Please elaborate your question first, what do you mean with PostgreSQL HA Matrix? Which matrix? What is the correlation between Oracle HA and Postgres? Two different types of Database cannot coexist in a HA Constellation.

If you can elaborate more, perhaps our team is able to answer, thanks.
Replication can be done with different OS on both sides.
Network problems in the middle of replication will not give impact on ArkCDC, since ArkCDC will extract and store the data to trace files. Therefore, if there are some problems with the replication communication, ArkCDC Agent will resend and continue the replication after reconnecting again.
Hello, If you wish to construct DR for files of windows server, it is possible with Ark for FR, which is also another solution that we provide. It can replicate files to the remote server on schedule or periodically.
Since each status of the module is managed separately, even in the case of a crash, the process will be continued based on the processing status. If the process fails, the process monitoring the process will be restarted. If the crash still happens even after the process is repeated in limited try, the suspended status will be kept.
ArkCDC does not replicate stored procedures, therefore there is no relation between replicating the data changes and the programming language on the database.
To be clear, ArkCDC is not a database, but a tool to help to do migration and replication, especially from Oracle to PostgreSQL. Some advantages are no performance impact, heterogenous RDBMS support, middleware architecture, replication data stability and consistency. For further information, you can visit https://equnix.asia/product/arkdata