Configuring optional replication advanced options

In Oracle Cloud Infrastructure Database Migration, for online migrations using Oracle GoldenGate, you can configure some Oracle GoldenGate performance settings in the Migration resource Advanced Settings, Replication tab.

• Acceptable lag (in seconds) specifies the amount of lag. The lag is the time taken to extract or apply the data from the time it was created on the source database. This parameter specifies the amount of lag, in seconds, that triggers Oracle GoldenGate end-to-end latency monitoring. Monitoring continues until the lag time is lower than the specified value. The maximum value is 30 seconds, and the minimum is 2 seconds. The default value is 30 seconds.

• Extraction settings

  • Performance profile Sets the Oracle GoldenGate PERFORMANCEPROFILE parameter. Valid for GoldenGate Extract in Integrated Capture mode.

    • HIGH (default) for high volume use cases

    • MEDIUM

    • LOW RES to minimize resource usage for memory or resource constrained deployment

    This setting helps achieve better performance by tuning the group of Oracle GoldenGate parameters that affect performance. Once the performance profile is set up, this option automatically configures the relevant parameters to achieve the desired throughput and latency.

  • Transaction maximum duration specifies the length of time, in seconds, that a transaction can be open before Extract generates a warning message that the transaction is long-running. You can remove the value from this field if you don’t want these error messages generated.

• Replication settings

  • Performance profile simplifies the Replicat performance.

    • Use HIGH when you have no concurrent workload on target. When HIGH is set, set Replicat Mappers to 5 and Appliers to 2 * PDB CPU_COUNT .

    • Use LOW when you have a concurrent workload on target. When LOW is set, set Replicat Mappers to 4 and Appliers to PDB CPU_COUNT / 2 on Target system.

• Advanced parameters lets you specify the advanced parameters for Replication settings for online migrations.

  While creating migration, select a list of parameters for migration. Select the Parameter name and Parameter value from the list. Click + Another parameter to add the parameters.

  For more information, see Zero Downtime Migration Logical Migration Response File Parameters Reference . Note: This option is currently applicable for Oracle to Oracle migrations only.

• GoldenGate instance (Optional) Use Marketplace GoldenGate instance: Select this option if you want to perform replication using your own Marketplace GoldenGate instance provisioned by you in your tenancy.

  Note: Currently, the support for the Use Marketplace GoldenGate instance option is limited to Oracle to Oracle online migrations.

  Note: Oracle recommends using the Use online replication default option. Select the Use Marketplace GoldenGate instance option only when you want to use your own Marketplace GoldenGate compute instance.

  Enter the following details:

  • GoldenGate instance OCID: The instance ID of the compute that is hosting the Marketplace GoldenGate.

  • GoldenGate hub URL: Enter a URL containing only the public host name or IP address of your Marketplace GoldenGate instance.

  • GoldenGate administrator username: Enter the user name for connecting to your Marketplace GoldenGate instance.

  • GoldenGate administrator password: Enter the password for connecting to your Marketplace GoldenGate instance.

  Note: You must use Marketplace as the default name for your GoldenGate deployment.