My Oracle Support Banner

Large Amount Of Archive Log Files Are Generated During Mgp Process And Compose/Apply Cycle Error (Doc ID 1199103.1)

Last updated on JANUARY 29, 2022

Applies to:

Oracle Lite - Version and later
Information in this document applies to any platform.


On : version, Mobile Server

When attempting to Compose/apply the data the MGP fails with the error Ora-00942 and it does not truncate the CLG$tables which increase the Amount of Archives.


The issue can be reproduced at will with the following steps:
1. start MGP
2. All the MGP Cycle fails with the Error Ora-00842
3. the MGP does not truncate the clg$tables and keep all their records which are composing again and increase the Amount of Archives.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.