01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
|
Using the following key columns for target table TARGET.BIG_DEPT: DEPTNO.
MAP resolved (entry SOURCE.EMP5B):
MAP SOURCE.EMP5B, TARGET target.emp5b;
Using following columns in default map by name:
EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO
Using the following key columns for target table TARGET.EMP5B: EMPNO.
2011 - 04 - 08 02 : 03 : 09 GGS WARNING 218 Aborted grouped transaction on 'TARGET.EMP5B' , Database error 100 (retrieving bind
info for query).
2011 - 04 - 08 02 : 03 : 09 GGS WARNING 218 Repositioning to rba 2674 in seqno 0.
2011 - 04 - 08 02 : 03 : 10 GGS WARNING 218 SQL error 1403 mapping SOURCE.EMP5B to TARGET.EMP5B.
2011 - 04 - 08 02 : 03 : 10 GGS WARNING 218 Repositioning to rba 153345 in seqno 0.
2011 - 04 - 08 02 : 03 : 10 GGS ERROR 218 Error mapping from SOURCE.EMP5B to TARGET.EMP5B.
|
检查discard file:
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
GGSCI (edvmr1p0) 3> sh more dirrpt/rep_5b.dsc
GoldenGate Delivery
for
Oracle process started,
group
REP_5B discard file opened: 2011-04-08 02:03:04
Current
time
: 2011-04-08 02:03:10
Discarded record
from
action
ABEND
on
error 1403
Aborting
transaction
on
./dirdat/5b beginning
at
seqno 0 rba 153345
error
at
seqno 0 rba 153345
Problem replicating SOURCE.EMP5B
to
TARGET.EMP5B
Record
not
found
Error (1403) occurred
with
compressed
update
record (target format)...
*
EMPNO =
COMM = 10.00
*
Process Abending : 2011-04-08 02:03:10
GGSCI (edvmr1p0) 4> dblogin userid source,
password ggs
Successfully logged into database .
GGSCI (edvmr1p0) 5> info trandata SOURCE.EMP5B
Logging of supplemental redo log data is disabled for table SOURCE.EMP5B.
|
检查这个SQL所在的事务,用Logdump:
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
[oracle@edvmr1p0 OGG_Target]$ logdump
GoldenGate Log File Dump Utility
Version 10.4.0.12 Build 001
Copyright (C) GoldenGate Software, Inc. 1995-2009.
The GoldenGate software may include other code written
by
third parties;
details regarding such third party code, including applicable copyright,
Logdump 46 >
open ./dirdat/5b000000
Current LogTrail is /home/oracle/OGG_Target/dirdat/5b000000
Logdump 47 >ghdr on
Logdump 48 >detail on
Logdump 49 >pos 153345
Reading forward from RBA 153345
从Discard File获取这条记录的RBA,通过Logdump定位到这条记录
Logdump 60 >pos 153345
Reading forward from RBA 153345
Logdump 61 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 28 (x001c) IO
Time
: 2011/04/08 00:30:59.001.728
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 231 AuditPos : 11214352
Continued : N (x00) RecCount : 1 (x01)
2011/04/08 00:30:59.001.728 FieldComp Len 28 RBA 153345
Name
: SOURCE.EMP5B
After
Image: Partition 4 G b
0000 000a ffff 0000 0000 0000 0000 0006 000a 0000 | ....................
0000 0000 0000 03e8 | ........
Column
0 (x0000), Len 10 (x000a)
Column
6 (x0006), Len 10 (x000a)
为了不破坏事务的完整性,找到这个SQL的事务结尾,找到下个事务的起始RBA
Logdump 62 >scanforendtrans
End
of
Transaction
found
at
RBA 165149
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 28 (x001c) IO
Time
: 2011/04/08 00:30:59.001.728
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x02) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 231 AuditPos : 11246304
Continued : N (x00) RecCount : 1 (x01)
2011/04/08 00:30:59.001.728 FieldComp Len 28 RBA 165149
Name
: SOURCE.EMP5B
After
Image: Partition 4 G e
0000 000a ffff 0000 0000 0000 0000 0006 000a 0000 | ....................
0000 0000 0001 86a0 | ........
Column
0 (x0000), Len 10 (x000a)
Column
6 (x0006), Len 10 (x000a)
Logdump 63 >pos 165149
Reading forward from RBA 165149
Logdump 64 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 28 (x001c) IO
Time
: 2011/04/08 00:30:59.001.728
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x02) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 231 AuditPos : 11246304
Continued : N (x00) RecCount : 1 (x01)
2011/04/08 00:30:59.001.728 FieldComp Len 28 RBA 165149
Name
: SOURCE.EMP5B
After
Image: Partition 4 G e
0000 000a ffff 0000 0000 0000 0000 0006 000a 0000 | ....................
0000 0000 0001 86a0 | ........
Column
0 (x0000), Len 10 (x000a)
Column
6 (x0006), Len 10 (x000a)
通过Scanforheader知道下一个事务的开始
Logdump 65 >scanforheader
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 14 (x000e) IO
Time
: 2011/04/08 00:30:59.001.728
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 231 AuditPos : 11247120
Continued : N (x00) RecCount : 1 (x01)
2011/04/08 00:30:59.001.728
Delete
Len 14 RBA 165268
Name
: SOURCE.EMP5B
Before Image: Partition 4 G b
0000 000a 0000 0000 0000 0000 0315 | ..............
Column
0 (x0000), Len 10 (x000a)
|
Solution:
GGSCI (edvmr1p0) 5> alter REP_5B, extseqno 0, extrba 165268
REPLICAT altered.