OGG EXT又ABENDED了，但是没有报错信息，如何诊断？

武汉-SSH

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078

GGSCI (node02) 1> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING
EXTRACT     ABENDED     HIST        330:44:47     00:06:55

GGSCI (node02) 2> info HIST showch

EXTRACT    HIST      Last Started 2012-01-13 19:59   Status ABENDED
Checkpoint Lag       330:44:47 (updated 00:21:09 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2011-12-31 01:10:31  Thread 1, Seqno 39467, RBA 1086958476
Log Read Checkpoint  Oracle Redo Logs
                     2011-12-31 01:15:10  Thread 2, Seqno 14798, RBA 1493874600


Current Checkpoint Detail:

Read Checkpoint #1

  Oracle RAC Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 1
    Sequence #: 39467
    RBA: 1081792528
    Timestamp: 2011-12-31 01:09:56.000000
    SCN: 5.2161634871 (23636471351)
    Redo File: Not Avaliable

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 1
    Sequence #: 39467
    RBA: 1081792528
    Timestamp: 2011-12-31 01:09:56.000000
    SCN: 5.2161634871 (23636471351)
    Redo File: +FRA/sms/archivelog/2011_12_31/thread_1_seq_39467.1203.771299781

  Current Checkpoint (position of last record read in the data source):
    Thread #: 1
    Sequence #: 39467
    RBA: 1086958476
    Timestamp: 2011-12-31 01:10:31.000000
    SCN: 5.2161705954 (23636542434)
    Redo File: +DATA/sms/onlinelog/group_1.258.768740989

Read Checkpoint #2

  Oracle RAC Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 2
    Sequence #: 14798
    RBA: 1493529104
    Timestamp: 2011-12-31 01:10:34.000000
    SCN: 5.2161699111 (23636535591)
    Redo File: +DATA/sms/onlinelog/group_6.275.735804591

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 2
    Sequence #: 14798
    RBA: 1493863440
    Timestamp: 2011-12-31 01:15:10.000000
    SCN: 5.2162229873 (23637066353)
    Redo File: +FRA/sms/archivelog/2011_12_31/thread_2_seq_14798.1106.771302643

  Current Checkpoint (position of last record read in the data source):
    Thread #: 2
    Sequence #: 14798
    RBA: 1493874600
    Timestamp: 2011-12-31 01:15:10.000000
    SCN: 5.2162229927 (23637066407)
    Redo File: +FRA/sms/archivelog/2011_12_31/thread_2_seq_14798.1106.771302643

Write Checkpoint #1

  GGS Log Trail

  Current Checkpoint (current write position):
    Sequence #: 13709
    RBA: 958
    Timestamp: 2012-01-13 19:59:57.640949
    Extract Trail: dirdat/hi

Header:
  Version = 2
  Record Source = A
  Type = 6
  # Input Checkpoints = 2
  # Output Checkpoints = 1

File Information:
  Block Size = 2048
  Max Blocks = 100
  Record Length = 4096
  Current Offset = 0

Configuration:
  Data Source = 3
  Transaction Integrity = 1
  Task Type = 0

Status:
  Start Time = 2012-01-13 19:59:57
  Last Update Time = 2012-01-13 19:59:57
  Stop Status = A
  Last Result = 0



[oracle@node02 gg]$ tailf dirrpt/HIST.rpt
2012-01-13 19:59:57  INFO    OGG-01026  Rolling over remote file dirdat/hi013708.

2012-01-13 19:59:57  INFO    OGG-01053  Recovery completed for target file dirdat/hi013709, at RBA 958.

2012-01-13 19:59:57  INFO    OGG-01057  Recovery completed for all targets.

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

武汉-SSH

目前，即使生成了TRACE ，好像也无法分析吧？

Maclean Liu(刘相兵

到哪里去寻找Oracle Golden Gate的诊断线索？  这里只提供 troubleshooting的一些思路：


OGG troubleshooting way


Resources for finding information
GGSCI commands to view:
Processing status
Events
Errors
Checkpoints

GoldenGate reports and logs:
Process reports
Error log
Discard file
System logs



GoldenGate sends processing information to several locations to help you monitor processes and troubleshoot failures and unexpected results.
GGSCI - The GGSCI command interface provides several helpful commands for troubleshooting. For syntax, view the GGSCI online help by issuing the HELP command, or see the alphabetical reference in the GoldenGate for Windows and UNIX Reference Guide.
Process Reports - Each Extract, Replicat, and Manager process generates a report file showing:
    parameters in use                table and column mapping
    database information              runtime messages and errors
Event/Error log - The error log is a file that shows:
    a history of GGSCI commands         processes that started/stopped
    errors that occurred         informational messages
Discard file - GoldenGate creates a discard file when the DISCARDFILE parameter is used in the Extract or Replicat parameter file and the process has a problem with a record it is processing. The discard file contains column-level details for operations that a process could not handle, including:
  the database error message       
  the trail file sequence number
  the relative byte address of the record in the trail       
  details of the discarded record
System logs - GoldenGate writes operating-system-level errors to the Event Viewer on Windows or the syslog on UNIX. Errors appearing in the system logs also appear in the GoldenGate error log.




GoldenGate provides the following self-help tools:


GoldenGate Public Solutions Knowledge Base
Maintained by GoldenGate experts and accessible from the support site
GoldenGate Documentation
Configuration instructions and descriptions of GoldenGate errors, commands, parameters, and functions
SHOWSYNTAX parameter
Shows Replicat SQL statements
TRACE / TLTRACE parameters
Debugging feature to detect bottlenecks
Logdump utility
Tool for viewing and analyzing GoldenGate trails
Veridata?
High-speed table comparison solution