2.16 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 AUTORESTARTprocess_type
group_name
[, RETRIESmax_retries
] [, WAITMINUTESwait_minutes
] [, RESETMINUTESreset_minutes
]
-
process_type
-
Specify one of the following:
-
EXTRACT or EXT
-
REPLICAT or REP
-
ER (Extract and Replicat)
-
LOGGER
-
SYNCFILE
orSYNC
-
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 andRESETMINUTES
is 15. If process A is restarted and runs without abending for 15 minutesRETRIES
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 forAUTORESTART
,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