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