|
0-17 16:24:31.000000
SCN: 3044.3022349713
Redo thread #: 2
Sequence #: 34712
RBA: 940508
Timestamp: 2014-10-17 16:24:31.000000
SCN: 3044.3022349707
Current write position:
Sequence #: 5161
RBA: 79119190
Timestamp: 2014-10-17 17:15:30.448658
Extract Trail: ./dirdat/sa
Logdump 261 >open /goldengate/dirdat/sa005161
Current LogTrail is /goldengate/dirdat/sa005161
Logdump 262 >ghdr on
Logdump 263 >detail on
Logdump 264 >detail data
Logdump 265 >usertoken on
Logdump 266 >pos
Current position is RBA 0 Forward
Logdump 267 >pos 79119190
Reading forward from RBA 79119190
Logdump 268 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 124 (x007c) IO Time : 2014/10/17 16:24:31.000.000
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 34712 AuditPos : 942196
Continued : N (x00) RecCount : 1 (x01)
2014/10/17 16:24:31.000.000 Insert Len 124 RBA 79119190
Name: MW_APP.MWT_CBM_ZTLBGGL
After Image: Partition 4 G s
0000 002e 0000 002a 3538 3846 3634 4231 2d37 3938 | .......*588F64B1-798
452d 3444 3131 2d41 3930 332d 3546 3446 4130 4632 | E-4D11-A903-5F4FA0F2
3236 3033 2d33 3634 3938 0001 000d 0000 0009 3438 | 2603-36498........48
3331 3238 3538 3300 0200 04ff ff00 0000 0300 04ff | 3128583.............
ff00 0000 0400 04ff ff00 0000 0500 15ff ff31 3930 | .................190
302d 3031 2d30 313a 3030 3a30 303a 3030 0006 0004 | 0-01-01:00:00:00....
ffff 0000 | ....
Column 0 (x0000), Len 46 (x002e)
0000 002a 3538 3846 3634 4231 2d37 3938 452d 3444 | ...*588F64B1-798E-4D
3131 2d41 3930 332d 3546 3446 4130 4632 3236 3033 | 11-A903-5F4FA0F22603
2d33 3634 3938 | -36498
Column 1 (x0001), Len 13 (x000d)
0000 0009 3438 3331 3238 3538 33 | ....483128583
Column 2 (x0002), Len 4 (x0004)
ffff 0000 | ....
Column 3 (x0003), Len 4 (x0004)
ffff 0000 | ....
Column 4 (x0004), Len 4 (x0004)
ffff 0000 | ....
Column 5 (x0005), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 6 (x0006), Len 4 (x0004)
ffff 0000
SQL> SQL> select count(1) from MW_APP.MWT_UD_KW_SJBGJL;
COUNT(1)
----------
1220223
GGSCI (pmsnxdb1) 97> !
send ZBDBA status
Sending STATUS request to EXTRACT ZBDBA ...
EXTRACT ZBDBA (PID 2269368)
Current status: Recovery complete: Processing data
Current read positions:
Redo thread #: 1
Sequence #: 36700
RBA: 4528776
Timestamp: 2014-10-17 17:18:05.000000
SCN: 3044.3023151974
Redo thread #: 2
Sequence #: 34724
RBA: 87547776
Timestamp: 2014-10-17 17:18:06.000000
SCN: 3044.3023152070
Current write position:
Sequence #: 5165
RBA: 109446515
Timestamp: 2014-10-17 17:29:26.994375
Extract Trail: ./dirdat/sa
Logdump 269 >open /goldengate/dirdat/sa005165
Current LogTrail is /goldengate/dirdat/sa005165
Logdump 270 >ghdr on
Logdump 271 >detail on
Logdump 272 >detail data
Logdump 273 >usertoken on
Logdump 274 >pos 109446515
Reading forward from RBA 109446515
Logdump 275 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 176 (x00b0) IO Time : 2014/10/17 17:12:19.000.000
IOType : 15 (x0f) OrigNode : 255 (xff) |