GoldenGate

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 […]

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 […]

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 […]

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 […]

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 […]

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, […]

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 […]

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 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 […]

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 […]