This post provides a sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup in line with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. The GLOBALS file stores parameters that relate to the GoldenGate […]
GoldenGate
Oracle GoldenGate: Replicat Sample Parameter File
This post provides 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. Replicat Process The replicate process is the apply process within an Oracle […]
Oracle GoldenGate: Pump (Extract) Sample Parameter File
This post provides 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. Pump (Extract) Process The data pump group is a secondary extract group […]
Oracle GoldenGate: Extract Sample Parameter File
This post provides 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. Extract Process The extract process of Oracle GoldenGate is used to perform […]
Oracle GoldenGate: Manager Sample Parameter File
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. Manager Process The manager process is not the most talked about […]
Script to Automatically Start GoldenGate
Sample script to start Oracle GoldenGate processes in an automated way. This script can come in handy to DBA/admins who are a little lazy like me to run multiple commands to start the GoldenFate processes. 1. Here is an example of simple script: $ cat start_goldengate.sh cd /home/oracle/goldengate ./ggsci < EOF OBEY /home/oracle/goldengate/startup.txt EOF Here, […]
Create an output file from GGSCI commands
1. Create a shell script: ggsci_out.sh. It should contain the following: ./ggsci < {parameter file} >{output file} example: $ vim ggsci_out.sh ./ggsci >ggsci_out.list 2. The shell script access mode must be executible $ chmod +x ggsci_out.sh 3. Create a parameter file that contains the desired ggsci command. Example for INFO TRANDATA command: $ vim ggsci.prm […]
How To Run ggsci In “silent” Mode
Question: Like sqlplus -S, how does one suppress the ggsci banner and extraneous output? Oracle GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise. It moves committed transactions from redo logs and maintains transaction integrity with sub-second latency. Its reliability is especially critical for enabling […]
Oracle Golden gate GGSCI commands quick reference (Cheat Sheet)
Oracle GoldenGate Components Manager: Is required to start and stop the other processes, but is not required for the ongoing operation of another process. That is, you can start the Manager, use the Manager to start the Extract, and then stop and restart the Manager (perhaps to pick up new Manager configuration parameters) without affecting […]
How to pass a value from shell script to GoldenGate replicat for mapping to target table column
The value must be assigned to an environment variable and the replicat must be started from the OS command line and not within GGSCI. Example: Start the replicat via the command line as part of the script and not calling GGSCI inside the script. If GGSCI is called to start replicat it will not recognize […]