Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

Managing the process startup


In a near real-time data replication environment, we don't want to incur high latencies or outages due to a process failure. GoldenGate has a mechanism to automatically restart Extract or Replicat processes, should they fail. The AUTORESTART parameter of the Manager process governs this and provides additional options on retry attempts.

-- GoldenGate Manager parameter file
PORT 7809
AUTORESTART EXTRACT *, RETRIES 3, WAITMINUTES 1, RESETMINUTES 60
  • RETRIES: This option sets the maximum number of times the Manager process attempts to restart a process.

  • WAITMINUTES : This option sets the delay in minutes between restart attempts.

  • RESETMINUTES: This option sets a window of time that retry attempts are counted. After the time expires, the retry count returns to zero.

In addition, the AUTOSTART parameter enables automatic startup of either the Extract or Replicat processes when the Manager process starts.

The following is the code for the Manager process parameter file...