This post provides a sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation.
The manager process is not the most talked about in the Oracle GoldenGate environment; however, it can be considered the brain of the process operation. The manager is responsible for many different parts within the environment. This is the one process that must be running, and remain running, on every system within a replication environment. Because it has to remain running on every system, the manager process is responsible for the following functions:
- Start and restart of Oracle GoldenGate processes
- Starting of dynamic processes
- Maintaining port numbers for processes
- Trail file management
- Event, error, and threshold reports
One manager process can control many different types of Oracle GoldenGate processes. This allows for central management of all things related to Oracle GoldenGate from a single home structure.
Process name: Manager
Description: Manager is GoldenGate’s parent process and is responsible for the management of GoldenGate processes, resources, user interface, and the reporting of thresholds and errors.
Manager parameter file (Sample)
-- Manager port number PORT [port number] -- As a Manager parameter, PURGEOLDEXTRACTS allows to manage trail -- files in a centralized fashion and take into account multiple -- processes. PURGEOLDEXTRACTS [path to the trail file], USECHECKPOINTS, MINKEEPHOURS ["x" hours] MINKEEPFILES ["y" number of files] -- 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. AUTORESTART EXTRACT *, RETRIES [x], WAITMINUTES [y], RESETMINUTES [z] --This is to specify a lag threshold that is considered critical, --and to force a warning message to the error log. Lagreport parameter --specifies the interval at which manager checks for extract / replicat --lag. LAGREPORTMINUTES [x] LAGCRITICALMINUTES [y]
Oracle GoldenGate: Manager Sample Parameter File
Oracle GoldenGate: Extract Sample Parameter File
Oracle GoldenGate: Pump (Extract) Sample Parameter File
Oracle GoldenGate: Replicat Sample Parameter File