2.17 AUTORESTART

Valid for

Manager

Description

Use the AUTORESTART parameter to start one or more Extract and Replicat processes automatically after they fail. AUTORESTART provides fault tolerance when something temporary interferes with a process, such as intermittent network outages or programs that interrupt access to transaction logs.

You can use multiple AUTORESTART statements in the same parameter file.

Default

Do not auto-restart

Syntax

Syntax AUTORESTART process_type group_name
[, RETRIES max_retries]
[, WAITMINUTES wait_minutes]
[, RESETMINUTES reset_minutes]
process_type

Specify one of the following:

  • EXTRACT or EXT

  • REPLICAT or REP

  • ER (Extract and Replicat)

  • LOGGER

  • SYNCFILE or SYNC

  • COORD (Coordinator)

group name

A group name or wildcard specification for multiple groups. When wildcards are used, Oracle GoldenGate starts all groups of the specified process_type on the local system that satisfy the wildcard.

RETRIES max_retries

The maximum number of times that Manager should try to restart a process before aborting retry efforts.

If RETRIES is not set, MAXABENDRESTARTS is used. If neither is set, the default number of tries is 2.

WAITMINUTES wait_minutes

The amount of time to pause between discovering that a process has terminated abnormally and restarting the process. Use this option to delay restarting until a necessary resource becomes available or some other event occurs. The default delay is 1 minute.

RESETMINUTES reset_minutes

The window of time a restarted process must run without abending for the retries count to be reset to the maximum. If the process abends within this time, the maximum retries value is decremented. When it reaches zero, no more restarts are attempted.

For example, RETRIES is set to 2 and RESETMINUTES is 15. If process A is restarted and runs without abending for 15 minutes RETRIES will be reset to 2. If instead, process A abends in less than 15 minutes, RETRIES becomes 1. If it is restarted and abends again within 15 minutes, no more retries will be attempted.

If RETSETMINUTES is not set for AUTORESTART, RESTARTINERVAL is used. If neither option is set, the default is 20 minutes.

Example

In the following example, Manager tries to start all Extract processes three times after failure within a one hour time period, and waits five minutes before each attempt.

AUTORESTART EXTRACT *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 60