Oracle - online redo logs and archived redo logs

When using CDC Replication with an Oracle database, you will require the following:

  • Physical access to both redo and archive logs.
  • Retention of redo and archive logs for as long as the product is shut down or latent.
  • Supplemental logging is configured to meet CDC Replication requirements.

You can configure CDC Replication to do the following:

  • Replication processes can use copies of complete Oracle archive logs that are shipped to a secondary system that is physically accessible to CDC Replication. This is referred to as log shipping.
  • Read database logs that are remote from your source installation of CDC Replication if the database log directory is located on a shared storage device.
  • Replication process can use only archive logs and not online redo logs. This type of configuration can lead to latency since the product must wait for the logs to be archived which varies depending on data volume and Oracle configuration.
Note: To minimize the impact on your source database, the CDC Replication log reader only performs read-only operations when working with your database logs and will never write directly to these files. This reduces disk contention on your log files and minimizes the impact on your database.