OracleGoldenGate12c配置OracleDatabase12cMultitenantdatabase - 数据库编程

8 16:11:12.516.573 Insert Len 28 RBA 1645
Name: ZHONGWC1.GGTEST.TAB01
After Image: Partition 4 G s
0000 000a 0000 0000 0000 0000 0001 0001 000a 0000 | ....................
0006 3130 674f 4350 | ..10gOCP
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0000 0001 | ..........
Column 1 (x0001), Len 10 (x000a)
0000 0006 3130 674f 4350 | ....10gOCP

Logdump 10 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 32 (x0020) IO Time : 2014/04/08 16:14:16.547.033
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 30 AuditPos : 20605968
Continued : N (x00) RecCount : 1 (x01)

2014/04/08 16:14:16.547.033 Insert Len 32 RBA 1797
Name: ZHONGWC1.GGTEST.TAB01
After Image: Partition 4 G s
0000 000a 0000 0000 0000 0000 1639 0001 000e 0000 | .............9......
000a 3131 6752 4143 204f 4345 | ..11gRAC OCE
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0000 1639 | .........9
Column 1 (x0001), Len 14 (x000e)
0000 000a 3131 6752 4143 204f 4345 | ....11gRAC OCE

Logdump 11 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 35 (x0023) IO Time : 2014/04/08 16:15:57.565.282
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 30 AuditPos : 20854800
Continued : N (x00) RecCount : 1 (x01)

2014/04/08 16:15:57.565.282 Insert Len 35 RBA 1953
Name: ZHONGWC1.GGTEST.TAB01
After Image: Partition 4 G s
0000 000a 0000 0000 0000 0000 0008 0001 0011 0000 | ....................
000d 3131 6752 3220 5241 4320 4f43 45 | ..11gR2 RAC OCE
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0000 0008 | ..........
Column 1 (x0001), Len 17 (x0011)

0000 000d 3131 6752 3220 5241 4320 4f43 45 | ....11gR2 RAC OCE

Logdump 12 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 74 (x004a) IO Time : 2014/04/08 16:16:41.573.430
IOType : 135 (x87) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 30 AuditPos : 20905488
Continued : N (x00) RecCount : 1 (x01)

2014/04/08 16:16:41.573.430 GGSUnifiedPKUpdate Len 74 RBA 2112
Name: ZHONGWC1.GGTEST.TAB01
After Image: Partition 4 G s
0000 0023 0000 000a 0000 0000 0000 0000 0008 0001 | ...#................
0011 0000 000d 3131 6752 3220 5241 4320 4f43 4500 | ......11gR2 RAC OCE.
0000 0a00 0000 0000 0000 0000 1200 0100 1100 0000 | ....................
0d31 3167 5232 2052 4143 204f 4345 | .11gR2 RAC OCE
Before Image Len 39 (x00000027)
BeforeColumnLen 35 (x00000023)
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0000 0008 | ..........
Column 1 (x0001), Len 17 (x0011)
0000 000d 3131 6752 3220 5241 4320 4f43 45 | ....11gR2 RAC OCE

After Image Len 35 (x00000023)
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0000 0012 | ..........
Column 1 (x0001), Len 17 (x0011)
0000 000d 3131 6752 3220 5241 4320 4f43 45 | ....11gR2 RAC OCE

Logdump 13 >n

GGSCI (test12c.localdomain) 58> stats rep1

Sending STATS request to REPLICAT REP1 ...

Start of Statistics at 2014-04-08 16:49:24.

Integrated Replicat Statistics:

Total transactions 5.00
Redirected 0.00
DDL operations 0.00
Stored procedures 0.00
Datatype functionality 0.00
Event actions 0.00
Direct transactions ratio 0.00%

Replicating from ZHONGWC1.GGTEST.TAB01 to ZWC5.GGTEST

OracleGoldenGate12c配置OracleDatabase12cMultitenantdatabase(五)