WARNING OGG-00952 Purging log history from OGG. GGS_DDL_HIST, ogg-00952purging

Source: Internet
Author: User

WARNING OGG-00952 Purging log history from OGG. GGS_DDL_HIST, ogg-00952purging

The following warning is often found during OGG log inspection:
16:52:56 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr. prm: Purging log history from OGG. GGS_DDL_HIST older than 15:52:56. 084114: cocould not delete rows from OGG. GGS_DDL_HIST, no database specified.
16:52:56 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr. prm: Purging log history from OGG. GGS_DDL_HIST_ALT older than 2013-01-13 15:52:56. 084261: cocould not delete rows from OGG. GGS_DDL_HIST_ALT, no database specified.
16:52:56 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr. prm: Purging log history from OGG. GGS_MARKER older than 15:52:56. 084448: cocould not delete rows from OGG. GGS_MARKER, no database specified.

At first, we did not pay much attention to it. Later we found that the table space usage of OGG gradually increased. I thought it had something to do with it, so I checked the information online. Indeed

The cause of this warning is that OGG needs to enter the database to perform this operation, so we need to add the following parameters to the MANAGER:
Userid ogg, password dfasdfasfasdadfad, ENCRYPTKEY DEFAULT

The MANAGER does not need to restart the process to modify the parameters. It only needs to refresh the process:
Refresh manager

The above warning was not found in the OGG ggserr. log monitoring again.





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.