goldengate的trail文件默认存放的不是sql,是sql执行的记录数对应的条数变更,就是redo的image ,比如源端插入10行,那么trail文件就可以有10个行的操作与其对应
sql:
SQL> insert into t1 select object_id,object_name from dba_objects where rownum<10;
9 rows created.
SQL> commit;
Commit complete.
SQL> select * from t1;
ID NAME
---------- --------------------
20 ICOL$
46 I_USER1
1 nag
28 CON$
15 UNDO$
29 C_COBJ#
3 I_OBJ#
25 PROXY_ROLE_DATA$
41 I_IND1
54 I_CDEF2
10 rows selected.
GGSCI (stdb) 35> info replt1
REPLICAT REPLT1 Last Started 2013-03-20 15:09 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint File /u01/app/goldengate/dirdat/tt000005
2013-03-20 15:12:58.876750 RBA 2156
Logdump 1 >open /u01/app/goldengate/dirdat/tt000005
Current LogTrail is /u01/app/goldengate/dirdat/tt000005
Logdump 2 >pos 2156
Reading forward from RBA 2156
Logdump 3 >n
2013/03/20 15:37:40.963.521 Insert Len 23 RBA 2156
Name: SCOTT.T1
After Image: Partition 4 G b
0000 0006 0000 0002 3230 0001 0009 0000 0005 4943 | ........20........IC
4f4c 24 | OL$
Logdump 4 >n
2013/03/20 15:37:40.963.521 Insert Len 25 RBA 2288
Name: SCOTT.T1
After Image: Partition 4 G m
0000 0006 0000 0002 3436 0001 000b 0000 0007 495f | ........46........I_
5553 4552 31 | USER1
Logdump 5 >n
2013/03/20 15:37:40.963.521 Insert Len 22 RBA 2400
Name: SCOTT.T1
After Image: Partition 4 G m
0000 0006 0000 0002 3238 0001 0008 0000 0004 434f | ........28........CO
4e24 | N$
Logdump 6 >n
2013/03/20 15:37:40.963.521 Insert Len 23 RBA 2509
Name: SCOTT.T1
After Image: Partition 4 G m
0000 0006 0000 0002 3135 0001 0009 0000 0005 554e | ........15........UN
444f 24 | DO$
Logdump 7 >n
2013/03/20 15:37:40.963.521 Insert Len 25 RBA 2619
Name: SCOTT.T1
After Image: Partition 4 G m
0000 0006 0000 0002 3239 0001 000b 0000 0007 435f | ........29........C_
434f 424a 23 | COBJ#
Logdump 8 >n
2013/03/20 15:37:40.963.521 Insert Len 23 RBA 2731
Name: SCOTT.T1
After Image: Partition 4 G m
0000 0005 0000 0001 3300 0100 0a00 0000 0649 5f4f | ........3........I_O
424a 23 | BJ#