oracleORA-14402OGG-01296

2018-06-22 14:58:04 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repsl.prm: Repositioning to rba 67512607 in seqno 320.
2018-06-22 14:58:04 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, repsl.prm:
SQL error 14402 mapping SE.T_TEST_SET to TS.T_TEST_SET OCI Error ORA-14402:
updating partition key column would cause a partition change (status = 14402). UPDATE "SSP"."T_TEST_SET"
SET "STR_DT" = :a1 WHERE "SET_ONO" = :b0.
2018-06-22 14:58:04 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repsl.prm: Repositioning to rba 67512607 in seqno 320.
2018-06-22 14:58:04 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, repsl.prm: Error mapping from SE.T_TEST_SET to TS.T_TEST_SET.
2018-06-22 14:58:04 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repsl.prm: PROCESS ABENDING.

GGSCI (testdb_env) 2> info REPSL

REPLICAT REPSL Last Started 2018-06-22 14:58 Status ABENDED
Checkpoint Lag 04:10:36 (updated 00:08:42 ago)
Log Read Checkpoint File ./dirdat/ss000320
2018-06-22 10:47:27.988209 RBA 67512607

GGSCI (testdb_env) 3> exit

---可以看到当前队列文件为 ss000320

[oracle@testdb_env ggs12]$ logdump

Oracle GoldenGate Log File Dump Utility for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

Logdump 1 >open ./dirdat/ss000320
Current LogTrail is /home/oracle/ogg/ggs12/dirdat/ss000320
Logdump 2 >pos 67512607
Reading forward from RBA 67512607
Logdump 3 >n

2018/06/22 10:47:27.988.209 FieldComp Len 43 RBA 67512607
Name: SE.T_TEST_SET
After Image: Partition 4 G s
0000 0017 0000 0013 4f53 5832 3031 3830 3132 3530 | ........OSX201801250
3332 3935 3430 3700 0300 0c00 0000 0832 3031 3830 | 3295407........20180
3632 30

Logdump 4 >n

2018/06/22 10:47:30.988.205 FieldComp Len 43 RBA 67512782
Name: SE.T_TEST_SET
After Image: Partition 4 G s
0000 0017 0000 0013 4f53 5832 3031 3830 3132 3930 | ........OSX201801290
3332 3936 3236 3300 0c00 0c00 0000 0832 3031 3830 | 3296263........20180
3632 32

Logdump 5 >exit
[oracle@testdb_env ggs12]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (testdb_env) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTSL 00:00:00 00:00:01
EXTRACT RUNNING PUMPSL 00:00:00 00:00:09
REPLICAT ABENDED REPSL 04:10:36 00:10:46

GGSCI (testdb_env) 2> alter REPSL ,extseqno 320 extrba 67512782
REPLICAT altered.

--跳过seqno为320，RBA为67512782的事物

GGSCI (testdb_env) 3> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTSL 00:00:00 00:00:05
EXTRACT RUNNING PUMPSL 00:00:00 00:00:03
REPLICAT STOPPED REPSL 00:00:00 00:00:02

GGSCI (testdb_env) 4> start repsl

Sending START request to MANAGER ...
REPLICAT REPSL starting

GGSCI (testdb_env) 5> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTSL 00:00:00 00:00:09
EXTRACT RUNNING PUMPSL 00:00:00 00:00:07
REPLICAT STOPPED REPSL 00:00:00 00:00:05

GGSCI (testdb_env) 6> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTSL 00:00:00 00:00:00
EXTRACT RUNNING PUMPSL 00:00:00 00:00:08
REPLICAT RUNNING REPSL 00:00:00 00:00:07

日积月累