NING
REPLICAT RUNNING REP1 00:00:00 00:00:04
--源端插入数据
[oracle@db12c ~]$ sqlplus ggtest/ggtest@zhongwc1
SQL*Plus: Release 12.1.0.1.0 Production on Tue Apr 8 16:15:27 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Tue Apr 08 2014 16:00:22 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> insert into tab01 values(8,'11gR2 RAC OCE');
1 row created.
SQL> commit;
Commit complete.
SQL> update tab01 set sid=18 where sid=8;
1 row updated.
SQL> commit;
Commit complete.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 ZHONGWC1 READ WRITE NO
SQL> show user
USER is "GGTEST"
--目标端logdump查看
[oracle@test12c ggs]$ logdump
Oracle GoldenGate Log File Dump Utility for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
Logdump 1 >ghdr on
Logdump 2 >detail on
Logdump 3 >detail data
Logdump 4 >usertoken on
Logdump 5 >open /u01/app/oracle/ggs/dirdat/rt000000
Current LogTrail is /u01/app/oracle/ggs/dirdat/rt000000
Logdump 6 >n
2014/04/08 16:01:27.656.085 FileHeader Len 1427 RBA 0
Name: *FileHeader*
3000 0327 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0..'0...GG..TL..1...
0004 3200 0004 2000 0000 3300 0008 02f2 1cb6 d8da | ..2... ...3.........
7695 3400 0026 0024 7572 693a 6462 3132 633a 3a75 | v.4..&.$uri:db12c::u
3031 3a61 7070 3a6f 7261 636c 653a 6767 733a 4558 | 01:app:oracle:ggs:EX
5444 5031 3500 0028 3500 0024 0022 7572 693a 6462 | TDP15..(5..$."uri:db
3132 633a 3a75 3031 3a61 7070 3a6f 7261 636c 653a | 12c::u01:app:oracle:
6767 733a 4558 5431 3600 0013 0011 2e2f 6469 7264 | ggs:EXT16....../dird
Logdump 7 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x00)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 0 (x0000) IO Time : 2014/04/08 16:01:30.673.111
IOType : 151 (x97) OrigNode : 0 (x00)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 0 AuditPos : 0
Continued : N (x00) RecCount : 0 (x00)
2014/04/08 16:01:30.673.111 RestartOK Len 0 RBA 1435
Name:
After Image: Partition 0 G s
Logdump 8 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 28 (x001c) IO Time : 2014/04/08 16:04:18.445.081
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 30 AuditPos : 18933828
Continued : N (x00) RecCount : 1 (x01)
2014/04/08 16:04:18.445.081 Insert Len 28 RBA 1494
Name: ZHONGWC1.GGTEST.TAB01
After Image: Partition 4 G s
0000 000a 0000 0000 0000 0000 0001 0001 000a 0000 | ....................
0006 4747 5445 5354 | ..GGTEST
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0000 0001 | ..........
Column 1 (x0001), Len 10 (x000a)
0000 0006 4747 5445 5354 | ....GGTEST
Logdump 9 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 28 (x001c) IO Time : 2014/04/08 16:11:12.516.573
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 30 AuditPos : 19556368
Continued : N (x00) RecCount : 1 (x01)
2014/04/0