ERROR OGG-01028

最新推荐文章于 2023-12-27 07:59:27 发布
最新推荐文章于 2023-12-27 07:59:27 发布
阅读量5.7k 收藏
点赞数
分类专栏： ogg
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/rgb_rgb/article/details/9318385
版权

2013-07-13 12:17:24  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start extb.
2013-07-13 12:17:24  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 129.100.253.8 (START EXTRACT EXTB ).
2013-07-13 12:17:24  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT EXTB starting.
2013-07-13 12:17:24  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, extb.prm:  EXTRACT EXTB starting.
2013-07-13 12:17:25  INFO    OGG-01639  Oracle GoldenGate Capture for Oracle, extb.prm:  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p8650836_extr.
2013-07-13 12:17:25  INFO    OGG-01640  Oracle GoldenGate Capture for Oracle, extb.prm:  BOUNDED RECOVERY: recovery start XID: 32.2.131091.
2013-07-13 12:17:25  INFO    OGG-01641  Oracle GoldenGate Capture for Oracle, extb.prm:  BOUNDED RECOVERY: recovery start position: SeqNo: 4862, RBA: 594428944, SCN: 0.3929465961 (3929465961), Timestamp: 2013-07-12 17:55:17.000000.
2013-07-13 12:17:25  INFO    OGG-01642  Oracle GoldenGate Capture for Oracle, extb.prm:  BOUNDED RECOVERY: recovery end position: SeqNo: 4862, RBA: 594516608, SCN: 0.3929466118 (3929466118), Timestamp: 2013-07-12 17:55:49.000000.
2013-07-13 12:17:25  INFO    OGG-01579  Oracle GoldenGate Capture for Oracle, extb.prm:  BOUNDED RECOVERY: VALID BCP: CP.EXTB.000000498.
2013-07-13 12:17:25  INFO    OGG-01629  Oracle GoldenGate Capture for Oracle, extb.prm:  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: 2.
2013-07-13 12:17:26  INFO    OGG-01513  Oracle GoldenGate Capture for Oracle, extb.prm:  Positioning to Sequence 4862, RBA 594428944.
2013-07-13 12:17:26  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, extb.prm:  Positioned to Sequence 4862, RBA 594428944, Jul 12, 2013 5:55:17 PM.
2013-07-13 12:17:26  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, extb.prm:  EXTRACT EXTB started.
2013-07-13 12:17:26  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, extb.prm:  Recovery initialization completed for target file ./dirdat/eb015004, at RBA 988.
2013-07-13 12:17:26  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, extb.prm:  Output file ./dirdat/eb is using format RELEASE 10.4/11.1.
2013-07-13 12:17:26  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extb.prm:  Rolling over remote file ./dirdat/eb015004.
2013-07-13 12:17:26  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, extb.prm:  Recovery completed for target file ./dirdat/eb015005, at RBA 988.
2013-07-13 12:17:26  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, extb.prm:  Recovery completed for all targets.
2013-07-13 12:17:26  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, extb.prm:  Position of first record processed Sequence 4862, RBA 594428944, SCN 0.3929465961, Jul 12, 2013 5:55:17 PM.
2013-07-13 12:17:35  ERROR   OGG-01028  Oracle GoldenGate Capture for Oracle, extb.prm:  Record position (SeqNo: 4863, RBA: 1040, SCN: 0.3929846419 (3929846419)) is beyond end of recovery (SeqNo: 4862, RBA: 594516608, SCN: 0.3929466118 (3929466118), Timestamp: 2013-07-12 17:55:49.000000).
2013-07-13 12:17:35  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extb.prm:  PROCESS ABENDING.
2013-07-13 12:17:35  WARNING OGG-00543  Oracle GoldenGate Capture for Oracle, extb.prm:  Unexpected threading library failure. Error code 16 (Device busy).
2013-07-13 12:17:49  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, extc.prm:  Long Running Transaction: XID 10.27.148495, Items 0, Extract EXTC, Redo Thread 1, SCN 0.3888595726 (3888595726), Redo Seq #4777, Redo RBA 560756240.


GGSCI (P550) 7> info extb

EXTRACT    EXTB      Last Started 2013-07-13 13:22   Status ABENDED
Checkpoint Lag       00:00:00 (updated 17:14:02 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2013-07-12 20:13:08  Seqno 4863, RBA 201120768


GGSCI (P550) 8> info extb detail

EXTRACT    EXTB      Last Started 2013-07-13 13:22   Status ABENDED
Checkpoint Lag       00:00:00 (updated 17:14:26 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2013-07-12 20:13:08  Seqno 4863, RBA 201120768

  Target Extract Trails:

  Remote Trail Name                                Seqno        RBA     Max MB

  ./dirdat/eb                                      14888   71514188        200

  Extract Source                          Begin             End            

  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13
  +DATA/sgerp5/onlinelog/group_3.401.802575155  2013-07-09 08:00  2013-07-12 20:13


Current directory    /orabak/ggs

Report file          /orabak/ggs/dirrpt/EXTB.rpt
Parameter file       /orabak/ggs/dirprm/extb.prm
Checkpoint file      /orabak/ggs/dirchk/EXTB.cpe
Process file         /orabak/ggs/dirpcs/EXTB.pce
Stdout file          /orabak/ggs/dirout/EXTB.out
Error log            /orabak/ggs/ggserr.log


GGSCI (P550) 9>

GGSCI (P550) 9> info extb showch

EXTRACT    EXTB      Last Started 2013-07-13 13:34   Status ABENDED
Checkpoint Lag       00:00:00 (updated 17:24:34 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2013-07-12 20:13:08  Seqno 4863, RBA 201120768


Current Checkpoint Detail:

Read Checkpoint #1

  Oracle Redo Log

  Startup Checkpoint (starting position in the data source):
    Sequence #: 4775
    RBA: 1438627856
    Timestamp: 2013-07-09 08:00:30.000000
    Redo File: Not Avaliable

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Sequence #: 4777
    RBA: 560756240
    Timestamp: 2013-07-09 11:11:04.000000
    Redo File: Not Avaliable

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 4863
    RBA: 201120768
    Timestamp: 2013-07-12 20:13:08.000000
    Redo File: +DATA/sgerp5/onlinelog/group_3.401.802575155

  BR Previous Recovery Checkpoint:
    Sequence #: 4839
    RBA: 1404786704
    Timestamp: 2013-07-12 02:41:30.000000
    Redo File:

  BR Begin Recovery Checkpoint:
    Sequence #: 4862
    RBA: 594428944
    Timestamp: 2013-07-12 17:55:17.000000
    Redo File:

  BR End Recovery Checkpoint:
    Sequence #: 4862
    RBA: 594516608
    Timestamp: 2013-07-12 17:55:49.000000
    Redo File:

Write Checkpoint #1

  GGS Log Trail

  Current Checkpoint (current write position):
    Sequence #: 14888
    RBA: 71514188
    Timestamp: 2013-07-12 20:13:14.675584
    Extract Trail: ./dirdat/eb

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

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

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

Status:
  Start Time = 2013-07-13 13:34:47
  Last Update Time = 2013-07-12 20:13:14
  Stop Status = A
  Last Result = 400

 

GGSCI (P550) 10>


GGSCI (P550) 7> info extb

EXTRACT    EXTB      Last Started 2013-07-13 13:22   Status ABENDED
Checkpoint Lag       00:00:00 (updated 17:14:02 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2013-07-12 20:13:08  Seqno 4863, RBA 201120768


ALTER EXTRACT extb, TRANLOG, BEGIN 2013-07-12 20:13:09

--重置抽取进程，本地文件序列号从0开始生成。
--alter extract ext1,extseqno 0,extrba 0

2013-07-13 13:52:34  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): ALTER EXTRACT extb  TRANLOG, BEGIN 2013-07-12 20:13:09.
2013-07-13 13:52:42  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start extb.
2013-07-13 13:52:42  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 129.100.253.8 (START EXTRACT EXTB ).
2013-07-13 13:52:42  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT EXTB starting.
2013-07-13 13:52:42  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, extb.prm:  EXTRACT EXTB starting.
2013-07-13 13:52:42  INFO    OGG-01635  Oracle GoldenGate Capture for Oracle, extb.prm:  BOUNDED RECOVERY: reset to initial or altered checkpoint.
2013-07-13 13:52:43  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, extb.prm:  Positioning to begin time Jul 12, 2013 8:13:09 PM.
2013-07-13 13:52:44  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, extb.prm:  Positioned to Sequence 4863, RBA 201120768, Jul 12, 2013 8:13:09 PM.
2013-07-13 13:52:44  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, extb.prm:  EXTRACT EXTB started.
2013-07-13 13:52:44  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, extb.prm:  Recovery initialization completed for target file ./dirdat/eb015021, at RBA 988.
2013-07-13 13:52:44  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, extb.prm:  Output file ./dirdat/eb is using format RELEASE 10.4/11.1.
2013-07-13 13:52:44  WARNING OGG-01438  Oracle GoldenGate Capture for Oracle, extb.prm:  Checkpoint marked as from graceful shutdown, but records found after checkpoint in trail ./dirdat/eb.  Expected EOF Seqno 14888, RBA 71514188.  Found Seqno 15021, RBA 988.
2013-07-13 13:52:44  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extb.prm:  Rolling over remote file ./dirdat/eb015021.
2013-07-13 13:52:44  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, extb.prm:  Recovery completed for target file ./dirdat/eb015022, at RBA 988.
2013-07-13 13:52:44  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, extb.prm:  Recovery completed for all targets.
2013-07-13 13:52:44  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, extb.prm:  Position of first record processed Sequence 4863, RBA 201121296, SCN 0.3929882856, Jul 12, 2013 8:13:18 PM.
2013-07-13 13:52:49  WARNING OGG-00869  Oracle GoldenGate Capture for Oracle, extb.prm:  Object 000.TBSAMUNAPPORTION has NOLOGGING option specified either at the table level or at the level of one of its (sub)partitions.
2013-07-13 13:53:33  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extb.prm:  Rolling over remote file ./dirdat/eb015022.
2013-07-13 13:53:34  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, pmpb_1.prm:  Rolling over remote file ./dirdat/pe005289.
2013-07-13 13:53:57  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extb.prm:  Rolling over remote file ./dirdat/eb015023.
2013-07-13 13:53:58  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, pmpb_1.prm:  Rolling over remote file ./dirdat/pe005290.
2013-07-13 13:54:19  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extb.prm:  Rolling over remote file ./dirdat/eb015024.
2013-07-13 13:54:20  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, pmpb_1.prm:  Rolling over remote file ./dirdat/pe005291.
2013-07-13 13:54:41  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extb.prm:  Rolling over remote file ./dirdat/eb015025.
2013-07-13 13:54:42  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, pmpb_1.prm:  Rolling over remote file ./dirdat/pe005292.
2013-07-13 13:55:04  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extb.prm:  Rolling over remote file ./dirdat/eb015026.

 

Applies to:

Oracle GoldenGate - Version: 11.1.1.1.0 and later   [Release: 11.1.1 and later ]
Information in this document applies to any platform.
Symptoms

Extract abends with below error:

ERROR OGG- 01028 Record position (SeqNo: 336, RBA: 1040, SCN: 0.40418944 (40418944)) is beyond end of recovery (SeqNo: 335, RBA: 9016952, SCN: 0.40255602 (40255602), Timestamp: 2011-06-21 10:57:03.000000).
Cause

Extract may have hit bug which can occur while processing a 0-length record while the extract is enabled for Bounded Recovery.
Solution

As a work around , please use the below extract parameter and start the extract which will turn off the Bounded recovery. When BR is off,  the Extract will do a normal recovery, so it needs all the archive logs file starting from recovery checkpoint of the extract.

BR BROFF

The only time BR is used is upon restart of extract, and only if there were any long running transactions that were persisted. If all of the transactions in the workload are of short duration (less than the BR interval default of 4 hrs), then even upon restart, standard recovery is active instead of bounded recovery.

And regarding transactions we are only concerned with ones that modify data. There may, of course, be batch jobs which run and take a long time, so these could fall into the long duration category thats mentioned above, but even in this case, as long as the redo logs/archive logs are available for standard recovery, the restart time should not be much longer with SR (standard recovery) than BR.

Once the extract has passed by the problematic RBA, this parameter can be removed.The permanent fix is planned for OGG v11.2.1.  

This is now fixed in bug 12330566 . Customers needing the fix should submit a build request to get the fix backported
rgb_rgb
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
OGG-01028问题处理记录
cuidai4743的博客
12-14 1724
OGG-01028问题处理记录 参考： http://blog.itpub.net/26277071/viewspace-713360/ http://oracle11ggotchas.com/articles/TheIm...
OGG-01433故障解决方法
09-11
表压缩设置引起的OGG-01433报错，解决办法，在源库： alter table xxxx nocompress； 然后重启ogg对应进程。 或者那张表要是不重要可忽略，方法如下（此方法不建议，若后期需要这个表再手工导出导入）： edit params...
【OGG】OGG故障错误处理总结
小麦苗DBA宝典
07-23 6931
【OGG】OGG故障错误处理总结 第一章GoldenGate错误分析与处理 在维护GoldenGate过程中，由于各种意外情况，难免还...
OGG-01028 Record position is beyond end of recovery
12-15 84
sometimes, extract abends due to below error:ERROR OGG-01028 Record position (SeqNo: 336, RBA: 1040, S...
OGG-01028分析处理
m0_37917722的博客
11-14 835
ogg-01028
ERROR OGG-01028
ckhwddy577380的博客
05-15 578
最近客户1套OGG系统，抽取进程经常报OGG-01028错误，该错误一般是由于OGG Bug 10356426引起的，日志如下：ERROR OGG-01028 Oracle GoldenGate...
OGG之ORA-01403案例
04-21
OGG 之 ORA-01403 案例中，出现了复制进程 abended 状态，报告显示错误信息为 OCI Error ORA-01403: no data found。该错误的原因可能是由于表字段不一致、索引不一致或数据不一致等原因引起的。 二、解决方法 ...
OGG-1224 Address already in use
08-31
2. **OGG-1224 Error**: 这个错误代码表示端口冲突，意味着OGG的某个进程试图使用的网络资源已经被其他进程占用。这可能是由于端口被其他OGG进程、系统服务或者外部扫描活动占用。 3. **端口扫描**: 端口扫描是一种...
ogg错误信息大全(英文版)
05-31
ogg错误信息大全 个人收集电子书，仅用学习使用，不可用于商业用途，如有版权问题，请联系删除！
goldengate+oracle部署文档
06-01
oracle部署goldengate实操文档
OGG故障OGG-01028分析处理
最新发布
bing_yuan的博客
12-27 476
OGG故障OGG-01028分析处理。
ogg跳过错误事务 OGG-01028
liuzhilong的博客
09-24 1935
复制进程abended GGSCI (jcyqdb02) 2> info RPEYAD REPLICAT RPEYAD Last Started 2019-09-07 01:15 Status ABENDED Checkpoint Lag 00:54:28 (updated 05:47:00 ago) Log Read Checkpoint File /og...
OGG-01028:归档漂移
anjianshangren0505的博客
08-21 273
之前由于数据库宕机导致归档不连续，进程起不来，俗称归档漂移。 完美的解决方案是找回漂移的归档，我们采取的方案是：暂时抛弃漂移的归档、启动进程保证业务连续（修改当前归档编号），事后申请检修初始化丢失数据的表，修改归档编号的操作如下： 1、获取抽取进程checkpoint信息： info extmb,showch 2、修改抽取进程的current checkpoint信息 alter extmb,ex...
OGG-01028错误处理
02-02 680
OGG抽取进程报错如下： ERROR OGG-01028 encountered commit SCN 3090.2667129739 (13274116074379) that is not greater t...
ERROR OGG-01028解决方法
weixin_33898876的博客
05-22 368
今天测试goldengate时报如下错误： 2012-05-09 18:24:13ERROR OGG-01028Oracle GoldenGate Capture for Oracle, ext1.prm:Formatting error on: table name MIBON..TEST, rowid AAAS14AAGAAAAI3AAA, XID 3.26....
OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint
weiwang的专栏
03-17 2607
ogg环境上的extract抽取进程启动了运行一段时间停止，再次启动启动不了报错 OGG-01635  BOUNDED RECOVERY: reset to initial or altered checkpoint 重新配置抽取进程 delete extract eora delete exttrail D:/ogg/dirdat/et add extract eora, tran
Oracle 日志解析ogg,对一段OracleGoldenGate（OGG）传输进程日志（.rpt文件）的解
weixin_39874795的博客
04-05 239
说明： /u02/ggs/dirdat/sb为源头抽取进程形成的trail文件名 /u02/ggs/dirdat/tb为源头传输进程往目的端传输，在目的端形成的trail文件名。 2014-08-01 13:51:11 INFO OGG-01026 Rolling over remote file /u02/ggs/dirdat/tb001540.---这个Rolling over 就说明：/u0...
测试，OGG从归档日志中抽取数据
zzbsa99的博客
06-24 1002
OGG测试
error Ogg-015051
08-24
- *1* *2* [ERROR OGG-01028 Detect partial pdata at rba xxxxxx without coinciding crash recovery marker record](https://blog.csdn.net/ly7472712/article/details/124923181)[target="_blank" data-report-...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值