Editing parameter files for online Oracle migrations

When an online migration gets into Needs Attention state or Waiting state due to a failed or a waiting migration job, using the GoldenGate Service integration, then you may choose to view and edit the Extract and Replicat parameter files and then resume the online Oracle migration.

Note:

You can only view the Extract/Replicat parameter files, if the corresponding process Extract/Replicat is Active. You can edit only if the respective process Extract/Replicat is not active at that time and the migration is in the Needs Attention state and the migration job is in Failed state, or when the migration is in a Waiting state.

This capability is applicable only for some phases such as Prepare, Prepare replication target, Monitor replication lag, and Switchover, wherein the file is displayed only if the GoldenGate Extract or Replicat is available.

The Oracle Cloud Infrastructure Database Migration service provides you a comprehensive feature to edit your replication parameter files whenever applicable during the migration process. It has the following features:

• You can view and edit the current Extract or Replicat parameter file belonging to the replication setup for your online migration.

• Any updates that you perform to the replication parameter files are versioned for your convenience.

• Whenever you edit on the Extract or Replicat parameter files, the original factory default version is always retained for you to revert for your reference.

• When you perform edits to either Extract or Replicat parameter files, after saving it, it is immediately applied to the replication setup.

• You can resume the migration after saving the file, from the failed process.

Job Details - Phases

On a migration resource detail page, you can click Jobs, then the job name, then Phases, and see the phase of the job that has failed.

Click the Edit parameter file option to view the current GoldenGate Extract and Replicat parameter files.

Note: You can edit the parameter depending on the phase and the current state of the GoldenGate process (Extract or Replicat).

The Parameter files panel displays the parameter files currently in use.

1. Details such as Type and creation details.

2. Click Edit parameter file to edit the Extract or Replicat files.

3. Edit the parameter file using a free-form editor.

4. If you perform an invalid parameter file edit, then GoldenGate rejects the edit with the error displayed on the screen.

5. Click Save as new and make current option to save this new version of the file and access it from the list available in the Show all files option. The new version is saved and applied to GoldenGate and marked as In use.

6. Click Cancel if you do not want to save the edited file.

Click the Show all files option to view the details of the files such as Name, Type, and Created details. The file currently being used is shown as In use. The following types of files are available in this option:

• You can switch between any of these two edited versions or the original (factory) parameter file.

• The original (factory) parameter file is provided by Oracle.

• From the action menu (three dots), select Edit and make current to switch between the files. You can view, edit, and save the file or you can view and save the file.

• You can switch back to the factory (original) parameter file.

• The original (factory) parameter file provided by Oracle is never deleted and you can use it when needed.

You can modify the relevant GoldenGate parameter file for the failed phase.

After modifying the parameter files, resume the online migration in this failed state.

Downloading Oracle GoldenGate logs

For Oracle online migrations, Oracle GoldenGate logs are available during the Monitor replication phase. Access to these logs works similarly to Data Pump logs.

In the Monitor replication phase, open the action menu (three dots), and select Download log. The log is stored in your Object Storage bucket.