Friday, October 21, 2011

How to trace goldengate extract???

1. add trace/trace2 parameter to the paramfile
e.g.,
trace ./my_trace1
trace2 ./my_trace2

2. under OGG installation home directory, create an xml file named gglog-<EXT_OR_REP_NAME>.xml
for example, for replicate R1, the file name is gglog-R1.xml.
gglog-<EXT_OR_REP_NAME>.xml should look like this.... :-
<?xml version="1.0"?>
<configuration reset="true">
<appender name="myTraceFile" class="FileAppender">
<param name="File" value="myTrace-%I.log"/>
<param name="Append" value="true"/>
<layout class="PatternLayout"/>
</appender>
<logger name="ggstd.ptrace">
<level value="all"/>
</logger>
</configuration>

3. start (or restart) the extract/replicat
4. the trace will be generated.
5. after collecting the trace, remove the xml file and trace parameters. then restart the extract or replicat.

No comments:

Post a Comment