goldengate trail file 与对应的sql

           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#