Saturday, May 26, 2018

Oracle GoldenGate Processes & Status

Oracle GoldenGate Processes & Status


Manager Process
-Manager process is common for source and target datatabase.
-It is required for Stop and Start GoldenGate Extract, Pump and Replicat processes
-It will monitor the livileness of other processes within the system.
-Default port is 7809
-It is the actual process which control other sub-components.
-It makes the communication using GG user.

Status of manager process:
-Stopped
-Running

Extract Process
-This is the actual process on source side which reads the actual data.
-It reads database from online redo log files and optionally from archive log files and write data to local or remote trail files.

Status of extract process:
-Stopped
-Starting
-Running
-Abended

Pump Process
-It is optional process avaliable on source side.
-To reduce the load of extract process.
-It reads data from local trail file and writes data to remote trail over the TCP/IP network. It is an optional process but highly recommended.

Status of pump process:
-Stopped
-Starting
-Running
-Abended

Replicat Process
-This is the actual process which available on target and it is actually apply the data to the database.
-It reads data from remote trail files and write to the database one transaction at a time.

Status of replicat process:
-Stopped
-Starting
-Running
-Abended

Collector Process
-This process is only available on target side.
-It receives data from Pump Extract and writes data to remote trail files.

Trails and Files
- Trail files ar the files which actually contains the data in the source and target side.
-Trails files are required for continuous data replication. These files are canonical structured files which only GoldenGate process can read.

Checkpoint Table
-CKPT is to maintain the integrity of data on the soure and target system.
-Incase of failure it doesn't read from the scratch, it reads from the point-of-failure.
-It provides the transaction recovery in case GoldenGate processes stopped abnormally.

Wallet
-It is a secure common storage for User IDs and Passwords. It is highly recommended to use wallet for secure credentials

No comments:

Post a Comment