which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

If multiple GoldenGate processes are accessing a set of trial files which of the processes should
include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

If multiple GoldenGate processes are accessing a set of trial files which of the processes should
include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

A.
Manager

B.
Extract

C.
Replicat

D.
Both Extract and Replicat

Explanation:
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf



Leave a Reply 3

Your email address will not be published. Required fields are marked *


franciscotmjr

franciscotmjr

Correct is A (manager)
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters122.htm

PURGEOLDEXTRACTS should only be used in an Extract or Replicat parameter file if there is only one instance of the process. If multiple groups are reading the same set of trail files, one process could purge a file before another is finished with it. Instead, use the Manager version of PURGEOLDEXTRACTS, which is the preferred use of the parameter in all Oracle GoldenGate configurations because it allows you to manage trail files in a centralized fashion.

Rajesh

Rajesh

Correct answer is A, because there are mutltiple gg processes are running and accessing the trails. If single process, then you can use extract or replicate parameter file.

ajcujar

ajcujar

A manager
PURGEOLDEXTRACTS should only be used in an Extract or Replicat parameter file if there is only one instance of the process. If multiple groups are reading the same set of trail files, one process could purge a file before another is finished with it. Instead, use the Manager version of PURGEOLDEXTRACTS, which is the preferred use of the parameter in all Oracle GoldenGate configurations because it allows you to manage trail files in a centralized fashion.