[OGG] LOGDUMP
<로그 확인>
[SOURCE]ogg@WEST:/u01/app/ogg_source_12.1.2/dirrpt> tail -f EXT01.rpt
[SOURCE]ogg@WEST:/u01/app/ogg_source_12.1.2/dirrpt> tail -f PMP01.rpt
[TARGET]ogg@EAST:/u01/app/ogg_target_12.1.2/dirrpt> tail -f REP01.rpt
--------------------------------------------------------------------------------------------------------------------------------------
2016-09-19 11:59:05 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep02.prm: Repositioning to rba 15805631 in seqno 6.
--------------------------------------------------------------------------------------------------------------------------------------
1. To view the record header with the data:
Logdump 1> GHDR ON
The record header contains information about the transaction.
2. To add column information:
Logdump 2> DETAIL ON
Column information includes the number and length in hex and ASCII.
3. To add hex and ASCII data values to the column information:
Logdump 3> DETAIL DATA
4. To view user tokens:
Logdump 4> USERTOKEN ON
User tokens are custom user-defined information that is specified in a TABLE or
FILE mapping statement and stored in the trail file for specific purposes.
5. To view automatically generated tokens:
Logdump 4> GGSTOKEN ON
Oracle GoldenGate automatically generated tokes include the transaction ID (XID),
the row id for DML operations, the fetching status (if applicable), and tag value.
6. To control how much record data is displayed:
Logdump 5> RECLEN length
Extract 의 stats확인 (Source)
GGSCI (dis) >stats extract ext01 latest
GGSCI (dis) >stats replicat rep01 latest
-ER 에 대한 자세한 정보 확인
: Extract/Replicat 의 현황 중 Trail 파일과 관련된 내용에 대해서 확인한다.
GGSCI> info ext01 detail
GGSCI> stats ext01, totalsonly app.*
GGSCI> info rep01 detail
GGSCI> info ext01 showch
GGSCI> send ext01 showtrans
[SOURCE]ogg@WEST:/u01/app/ogg_source_12.1.2> ls ?al dirdat/
-Logdump 을 이용한 확인
: Logdump 명령어를 통한 변경 데이터 확인 및 검색
[TARGET]ogg@EAST:/u01/app/ogg_target_12.1.2> ./logdump
LOGDUMP> open dirdat/ex000000
LOGDUMP>
ghdr on
usertoken detail
ggstoken detail
headertoken detail
detail data
detail on
sfh
fileheader detail
LOGDUMP>
LOGDUMP> help
LOGDUMP> count
LOGDUMP> n
LOGDUMP> pos 0
LOGDUMP> filter include filename SOE.INVENTORIES;
LOGDUMP> filter match all
LOGDUMP> filter clear
또한 Logdump 을 이용할 경우 일반적으로 사용되는 명령어는 다음과 같다.
1) filter rectype INSERT
2) filter string /017443/;
3) filter include GGSTOKEN ORAROWID = AAGJpjAF9AAM5ADAAl
4) pos reverse
5) pos forward
6) nexttrail
##################################################################################
##################################################################################
##################################################################################
ggsci> info repc
--------------------------------------------------------------------
REPLICAT REPC Last Started 2014-10-20 12:22 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint File ./dirdat/RC000001
2014-10-21 09:15:19.485950 RBA 36328
--------------------------------------------------------------------
os/ogg> logdump
--------------------------------------------------------------------
Oracle GoldenGate Log File Dump Utility for Oracle
Version 11.2.1.0.7 16934304 OGGCORE_11.2.1.0.7_PLATFORMS_130709.1600.1
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
Logdump 1> open ./dirdat/RC000001
Logdump 2> pos 36328
Logdump 3> n
2014/10/21 09:55:56.555.337 Insert Len 402 RBA 36328
Name: BIGFILE.ALEX_LINKPRICE
After Image: Partition 4 G s
0000 000a 0000 0006 3637 3830 3039 0001 0015 0000 | ........678009......
3230 3134 2d31 302d 3231 3a30 393a 3535 3a35 3600 | 2014-10-21:09:55:56.
0200 0f00 0000 0b79 6f68 616e 3530 3134 3033 0003 | .......yohan501403..
0007 0000 0003 3132 3600 0400 0a00 0053 2020 2020 | ......126......S
2020 2000 0500 0500 0000 0130 0006 0008 0000 0004 | ........0........
3635 3339 0007 0004 ffff 0000 0008 0007 0000 0003 | 6539................
544e 4b00 0900 7e00 0000 7a26 6170 705f 6964 3d36 | TNK...~...z&app_id=6
원하는 트랜잭션이 보일때까지 n 을 눌러서 확인한다
--------------------------------------------------------------------
ggsci> alter replicat REPC extseqno 1, extrba 36330
?ggsci> start replicat REPC
** extseqno 1 -- RC000001 ( 숫자 )
만일 ./dirdat/RC002701 이였으며 extseqno 2701 입니다.
[출처] Golden gate replicate가 abend가 되었을때|작성자 아울이
##################################################################################
##################################################################################
##################################################################################
[test@oggtest:/oggtest/kkt] ll
total 178128
-rw-r--r-- 1 test dba 91194539 Jul 26 11:10 r6000021
[test@oggtest:/oggtest/kkt] /oggtest/oggt/logdump
Oracle GoldenGate Log File Dump Utility
Version 11.1.1.1.2_05 13609969 OGGCORE_11.1.1.1.3_PLATFORMS_120127.1840
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Logdump 1 >open /oggtest/kkt/r6000021
Current LogTrail is /oggtest/kkt/r6000021
Logdump 2 >ghdr on
Logdump 3 >detail data
Logdump 4 >pos 44156067
Reading forward from RBA 44156067
Logdump 5 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 529 (x0211) IO Time : 2012/07/24 07:05:18.003.114
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 1246 AuditPos : 171559040
Continued : N (x00) RecCount : 1 (x01)
2012/07/24 07:05:18.003.114 Insert Len 529 RBA 44156067
Name: SCOTT.TEST
After Image: Partition 4 G s
0000 000b 0000 0007 324c 4452 3130 3000 0100 1600 | ........XXXXXXX.....
0000 1247 4d2d 324c 442d 3247 2d44 4452 332d 324e | ...XX-XXX-XX-XXXX-XX
4400 0200 0d00 0000 0900 c194 0a19 920a 743e 0003 | X...............t>..
000c 0000 0008 1432 3031 3230 3732 0004 0007 0000 | .......2012072......
0003 3430 3400 0500 04ff ff00 0000 0600 0800 0000 | ..404...............
0434 3331 3300 0700 04ff ff00 0000 0800 04ff ff00 | .4313...............
0000 0900 04ff ff00 0000 0a00 04ff ff00 0000 0b00 | ....................
Column 0 (x0000), Len 11 (x000b)
0000 0007 324c 4452 3130 30 | ....XXXXXXX
Column 1 (x0001), Len 22 (x0016)
0000 0012 474d 2d32 4c44 2d32 472d 4444 5233 2d32 | ....XX-XXX-XX-XXXX-X
4e44 | XX
Column 2 (x0002), Len 13 (x000d)
0000 0009 00c1 940a 1992 0a74 3e | ...........t>
Column 3 (x0003), Len 12 (x000c)
0000 0008 1432 3031 3230 3732 | .....2012072
.....
Column 38 (x0026), Len 4 (x0004)
ffff 0000 | ....
Column 39 (x0027), Len 4 (x0004)
ffff 0000 | ....
Column 40 (x0028), Len 4 (x0004)
ffff 0000 | ....
Column 41 (x0029), Len 4 (x0004)
ffff 0000 | ....
[출처] [OGG] LOGDUMP|작성자 채니아빠