Use the Process Report
Use the process report to view (depending on the process):
-
parameters in use
-
table and column mapping
-
database information
-
runtime messages and errors
-
runtime statistics for the number of operations processed
Every Extract, Replicat process generates a report file. The report can help you diagnose problems that occurred during the run, such as invalid mapping syntax, SQL errors, and connection errors.
To view a process report, use any of the following:
-
standard shell command for viewing a text file
-
Performance Metrics Service
-
VIEW REPORT
command. -
To view information if a process abends without generating a report, use the following command to run the process from the command shell of the operating system (not Oracle GoldenGate command line) to send the information to the terminal.
process paramfile path.prm
Where:
-
The value for
process
is eitherextract
orreplicat
. -
The value for
path
.prm
is the fully qualified name of the parameter file, for example:REPLICA PARAMFILE /ogg/dirdat/repora.prm
-
By default, reports have a file extension of .rpt
, for example EXTORA.rpt
. The default location is the dirrpt
sub-directory of the Oracle GoldenGate directory. However, these properties can be changed when the group is created. Once created, a report file must remain in its original location for Oracle GoldenGate to operate properly after processing has started.
To determine the name and location of a process report, use the INFO
EXTRACT
, or INFO REPLICAT
commands.
Scheduling Runtime Statistics in the Process Report
By default, runtime statistics are written to the report once, at the end of each run. For long or continuous runs, you can use optional parameters to view these statistics on a regular basis, without waiting for the end of the run.
To set a schedule for reporting runtime statistics, use the REPORT
parameter in the Extract or Replicat parameter file to specify a day and time to
generate runtime statistics in the report. See REPORT
.
To send runtime statistics to the report on demand, use the SEND EXTRACT
or SEND REPLICAT
command with the REPORT
option to view current runtime statistics when needed.
Viewing Record Counts in the Process Report
Use the REPORTCOUNT
parameter to report a
count of transaction records that Extract or Replicat processed since startup. Each
transaction record represents a logical database operation that was performed within a
transaction that was captured by Oracle GoldenGate. The record count is printed to the
report file and to the screen.
Prevent SQL Errors from Filling the Replicat Report File
Use the WARNRATE
parameter to set a
threshold for the number of SQL errors that can be tolerated on any target table before
being reported to the process report and to the error log. The errors are reported as a
warning. If your environment can tolerate a large number of these errors, increasing
WARNRATE
helps to minimize the size of those files.