oracle ORA-14402 OGG-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