[Translated from mos] using the ggserr. log method cyclically in Oracle GoldenGate, oraclegoldengate

Source: Internet
Author: User

[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;

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.