[Translated from mos] using the ggserr. log method cyclically in Oracle GoldenGate, oraclegoldengate
Use ggserr. log cyclically in OGG:
Reference Original:
OGG How Do I Recycle The "ggserr. log" File? (Docid 967932.1)
Applicable:
Oracle GoldenGate-Version 4.0.0 and later
Generic Linux
Problem
The ggserr. log File of GoldenGate contains information about GoldenGate events, such as process startup, shutdown, error, and warning. The file may become very large. To use this file cyclically, you have to stop all GoldenGate processes.
Solution:
1. One requirement is that ggserr. log is cyclically used when the GoldenGate process is running. In this case, you can use the following method:
1). Back up the "ggserr.log" file using the following command: cp -p ggserr.log ggserr.log.bkup 2). Truncate the file using the following command: cat /dev/null > ggserr.log
Note:
In windows, you need to use a unix simulator (such as cygwin) to complete the preceding operations.
If ggserr. log is very large, and the previous step may take a long time. During this time, note that this time refers to the time difference between 1) and 2, entries inserted between Step 1 and Step 2 will be lost.
If you do not want to lose any entries, the row at the end of ggserr. log (the row newly inserted between Step 1 and step 2) can be backed up again.
Example:
tail -500 > ggserr.log.bkup_2
For external data:
Similar functionality is available for the specified data transmission data. log.
See note 1385983.1 for details.
2. Another solution is to use logrotate (note 1466849.1)
---> Note: note 1466849.1 refers to: How to Rotate GoldenGate ggserr. log using logrotate utility for Unix/Linux? (Docid 1466849.1)
Synchronization of GoldenGate and sequence in oracle
It may be because the sequence parameters on the target and the source are different. The source is nocache, the target is cache, or the cache_size settings are different.
Does your goldengate support DDL? We recommend that you pay attention to the DSG Realsync ORACLE data synchronization software.
Oracle GoldenGate unidirectional Replication
Switch the role.
The original backup server is now used as the master server;
The original master server is now used as a backup server;