LAGREPORT
Valid for
Manager
Description
LAGREPORTMINUTES and LAGREPORTHOURS determine the interval at which Manager checks lag for Extract and Replicat processing.
For example, LAGREPORTHOURS 1 reports lag every hour. If the lag is greater than the time specified by LAGCRITICAL, Manager reports the LAG as critical, otherwise, it reports the lag as an informational message. LAG is not reported if the values are below the threshold set with the LAGINFO parameter.
If LAG is being reported from Extract or Replicat, that it is “Running but has not checkpointed" in the specified time using either LAGCRITICAL or LAGINFO, you should send the process a STATUS command from GGSCI, and take the appropriate action depending on the reply. Do not stop the process.
Examples:
-
A Reply of
Process is suspended, waiting for Resume commandis the result of anEVENTACTIONtriggering aSUSPENDand waiting for aGGSCI RESUME. -
A reply of
Retrying open error 11 on fileis waiting for someone to create the missing target file for a Replicat to continue. -
A reply of status:
Waiting for more auditorRecords so far in current transactionis almost certainly working correctly; possibly waiting on a large transaction.If the problem persists and you are not sure how to resolve it, contact Oracle GoldenGate support.