Automate Maintenance Tasks

Use the Tasks tab on the Configuration page, to set up the following automated tasks.

Purging Trails

The Purge Trail page works the same way as the Manager PURGEOLDEXTRACTS parameter in the Classic Architecture. It allows you to purge trail files when Oracle GoldenGate has finished processing them. Automating this task ensures that the trail files are periodically deleted to avoid excessive consumption of disk space.

From the Tasks tab, when you select the Purge Trail page, it allows you to configure the Administration Service purge trail process.

1. Add a Purge Trail task by clicking the + sign .

2. Enter the Operation Name of the Administration Service task. The operation name is case sensitive. For example, you can create an operation with the name TASK1 and another operation named task1.

3. Enter the trail path or trail name in the Trail field.

4. Click the + sign to add the trail to the Selected Trails list.

5. If you don’t need to use checkpoints, disable the option Use Checkpoints. However, Oracle recommends using checkpoints. If you don't use checkpoints. the trail will be purged whether or not it has been consumed if the keep rule is met.

6. Set the Keep Rule value to specify the maximum number of hours, days, or number of files for which the Purge Trails task needs to be active.

7. Specify the number of hours or days when the purge trails task has to run, in the Purge Frequency field and click Submit.

8. Use the Purge Trails task table to edit or delete the task, as required.

   Also see PURGE EXTTRAIL.

Purging Tasks

You can automatically purge processes associated with an Administration Service.

From the Tasks tab, click Purge Tasks.

1. Enter the Operation Name that you need to set up for automatic purging.

2. Select the Extract or Replicat task (initial load process) Process Name for the operation. The list contains all processes so ensure that you select the correct task.

3. Select the Extract or Replicat task (initial load) Process Type for the operation.

4. If you enable Use Stop Status, the status of the task is used to perform the purge task.

5. Enter the hours or days after which you need to purge the process and click Submit.

6. Edit or delete the purge process task using the relevant icon from the Purge Tasks table.

Reporting Lag

You can manage lag reports from the Lag Report tab. To do so:

1. From the Tasks tab, click Lag Report.

2. The Action column contains all the options to delete, alter, refresh, and view the lag report task details.

3. Select the required option.

4. If you select the Alter Task option, you are presented with options to edit the lag report. The options are:

   • Enabled: To keep processing the lag report task.

   • Check Every (in minutes): To set a time interval to check the lag report.

   • Report: To log report for the task.

   • If Exceeds: To specify a threshold after which a warning would be initiated.

   • Warning: To allow a warning to be generated incase the lag threshold exceeds the specified limit.

   • When Exceeds: The lag threshold after which the warning is triggered.

5. Click Submit.