Thứ Ba, 1 tháng 12, 2020

Sử dụng LogMiner để debug Golden Gate


1. View report repxxx
 
MAP resolved (entry user1.table1):
  map user1.table1, target user11.table1;
Using following columns in default map by name:
  SUB_ID, ORG_MOB_TYPE, ....
 
Using the following key columns for target table user11.table1: SUB_ID, SEGMENT_ID.
 
 
Source Context :
  SourceModule            : [ggstd.conv.endian]
  SourceID                : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/gglib/ggstd/lecnv.c]
  SourceFunction          : [convCompSQL]
  SourceLine              : [589]
 
2011-10-27 15:05:23  ERROR   OGG-01163  Bad column length (4) specified for column MOB_TYPE in table user1.table1, maximum allowable length is 3.
 
***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************
 
Reading /u03/gg/dirdat/p1001633, current RBA 118046018, 270 records
2. View record error

2.1. Vào logdump

bash-3.00$ logdump
 
Oracle GoldenGate Log File Dump Utility
Version 11.1.1.0.0 Build 078
 
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
 
 
2.2.  Mở file trail (lấy tham số từ report)

Logdump 33 >open /u03/gg/dirdat/p1001633
Current LogTrail is /u03/gg/dirdat/p1001633 

2.3. Tìm đến vị trí bản ghi

Logdump 35 >pos 118046018
Reading forward from RBA 118046018 

Logdump 36 >detail on

Logdump 37 >n
 
2011/10/25 03:24:09.066.039 FieldComp            Len   112 RBA 118046018 

Name: user1.table1 
After  Image:                                             Partition 4   G  m   
0000 000a 0000 0000 0000 045f e210 0002 0008 0000 | ..........._........  
0004 4643 5056 0004 0013 0000 000f 3435 3230 3132 | ..FCPV........452012  
3130 3235 3030 3030 3200 0800 0a00 0000 0000 0000 | 102500002...........  
0000 0100 0900 1500 0032 3031 312d 3031 2d31 383a | .........2011-01-18:  
3030 3a30 303a 3030 000e 0006 0000 0002 3030 0010 | 00:00:00........00..  
000a 0000 0000 0000 0000 0000                     | ............  
Column     0 (x0000), Len    10 (x000a)  
Column     2 (x0002), Len     8 (x0008)  
Column     4 (x0004), Len    19 (x0013)  
Column     8 (x0008), Len    10 (x000a)  
Column     9 (x0009), Len    21 (x0015)  
Column    14 (x000e), Len     6 (x0006)  
Column    16 (x0010), Len    10 (x000a)  


KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH: 📧 Mail: binhoracle@gmail.com ☎️ Mobile: 0902912888 ⚡️ Skype: tranbinh48ca 👨 Facebook: https://www.facebook.com/BinhOracleMaster 👨 Inbox Messenger: https://m.me/101036604657441 (profile) 👨 Fanpage: https://www.facebook.com/tranvanbinh.vn 👨 Inbox Fanpage: https://m.me/tranvanbinh.vn 👨👩 Group FB: https://www.facebook.com/groups/OracleDBAVietNam 👨 Website: http://www.tranvanbinh.vn 👨 Blogger: https://tranvanbinhmaster.blogspot.com 🎬 Youtube: http://bit.ly/ytb_binhoraclemaster 👨 Tiktok: https://www.tiktok.com/@binhoraclemaster?lang=vi 👨 Linkin: https://www.linkedin.com/in/binhoracle 👨 Twitter: https://twitter.com/binhoracle 👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội #OracleTutorial #OracleDBA #OracleDatabaseAdministration #học oracle database #oca #ocp #oce #ocm

ĐỌC NHIỀU

Trần Văn Bình - Oracle Database Master