點擊上方“IT那活兒”公眾號,關注后了解更多內容,不管IT什么活兒,干就完了!!!
某客戶現場有一套數據同步環境,通過Oracle GoldenGate工具進行同步,但同步過程中Rep進程經常Abend,嚴重影響數據同步的一致性,下面就一起帶大家了解解決該問題的全過程。
ggsci>view report rep
Wildcard MAP resolved (entry MKT01.*):
MAP MKT01.TABLE1, target MKT01.TABLE1;
2022-03-22 09:42:02 WARNING OGG-00869 No unique key is defined for table TABLE1. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Using following columns in default map by name:
col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11, col12, col13, col14, col15, col16,
col17, col18, col19, col20, col21, col22, col23, col24, col25, col26, col27, col28, col29, col30,
col31, col32, col33, col34, col35, col36, col37, col38, col39, col40, col41, col42, col43, col44,
col45, col46
Using the following key columns for target table MKT01.TABLE1: col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11, col12, col13, col14, col15, col16, col17, col18, col19, col20, col21, col22, col23, col24, col25, col26, col27, col28, col29, col30, col31, col32, col33, col34, col35, col36, col37, col38, col39, col40, col41, col42, col43, col44, col45, col46.
2022-03-22 09:42:02 WARNING OGG-01431 Aborted grouped transaction on MKT01.TABLE1, Mapping error.
2022-03-22 09:42:02 WARNING OGG-01003 Repositioning to rba 1203 in seqno 56963.
2022-03-22 09:42:02 WARNING OGG-01151 Error mapping from MKT01.TABLE1 to MKT01.TABLE1.
2022-03-22 09:42:02 WARNING OGG-01003 Repositioning to rba 1203 in seqno 56963.
Source Context :
SourceModule: [er.main]
SourceID : [/scratch/pradshar/view_storage/pradshar_bug_12547936/oggcore/OpenSys/src
/app/er/rep.c]
SourceFunction : [take_rep_err_action]
SourceLine : [15849]
2022-03-22 09:42:02 ERROR OGG-01296 Error mapping from MKT01.TABLE1 to MKT01.TABLE1.
vi /ogg/ggs/dirrpt/repdsc.dsc
Oracle GoldenGate Delivery for Oracle process started, group REP discard file opened: 2022-03-22 09:42:02
Current time: 2022-03-22 09:42:02
Discarded record from action ABEND on error 0
Aborting transaction on /ogg/ggs/dirdat/zy beginning at seqno 56963 rba 1203
error at seqno 56963 rba 1203
Problem replicating MKT01.TABLE1 to MKT01.TABLE1
Mapping problem with compressed update record (target format)...
*
col1 = 32887
col2 = 0
col3 = 7875DFD3A5E5CE1DB1E37ADA550209CB
col4 = 01
col5 = A38BD55A8B8054C1AE6F4071C750FAAD4F5DBBBD34CB150CCA7810D15CBB8795
col6 = 74
col7 = NULL
col8 = NULL
col9 = NULL
col10 = 6FA95A63159E2034AA855EF545A9C5D4
col11 = NULL
col12 = NULL
col13 = NULL
col14 = NULL
col15 = 1
col16 = 1
col17 = NULL
col18 = 370103
col19 = NULL
col20 = NULL
col21 = NULL
col22 = NULL
col23 = NULL
col24 = NULL
col25 = NULL
col26 = NULL
col27 = NULL
col28 = NULL
col29 = NULL
col30 = NULL
col31 = 0
col32 = 2022-01-07 09:06:59
col33 = 0
col34 = NULL
col35 = <Raw Data>
000000: e5 b1 b1 e4 b8 9c e7 9c 81 e5 b9 bf e5 ae 89 e7 |................|
000010: 89 a9 e4 b8 9a e6 9c 89 e9 99 90 e5 85 ac e5 8f |................|
000020: b8 |. |
col36 = 2022-01-07 09:06:59
col37 = <Raw Data>
000000: e5 b1 b1 e4 b8 9c e7 9c 81 e5 b9 bf e5 ae 89 e7 |................|
000010: 89 a9 e4 b8 9a e6 9c 89 e9 99 90 e5 85 ac e5 8f |................|
000020: b8 |. |
col38 = NULL
col39 = 1
col40 = 488
col41 = 4881113301
col42 = 1
col43 = NULL
col44 = 2
col45 = 1939-10-25 00:00:00
*
Process Abending : 2022-03-22 09:42:02
Would it be feasible to exclude the table and sync it up later.
實際上 select * from dba_log_group_columns where table_name=TABLE1;這個就反饋0;
SELECT * FROM dba_log_groups where table_name not in (select distinct table_name from DBA_LOG_GROUP_COLUMNS where owner=MKT01 )。
and owner=MKT01
TABLE1_LS
WY_XQXXB_LS
WY_XQXXB
TABLE1
TABLE11
If the table contains only primary key columns then the table will be listed in dba_log_group_columns view else it will be listed in dba_log_groups.
文章版權歸作者所有,未經允許請勿轉載,若此文章存在違規行為,您可以聯系管理員刪除。
轉載請注明本文地址:http://specialneedsforspecialkids.com/yun/129478.html
摘要:并發模塊本身有兩種不同的類型進程和線程,兩個基本的執行單元。調用以啟動新線程。在大多數系統中,時間片發生不可預知的和非確定性的,這意味著線程可能隨時暫停或恢復。 大綱 什么是并發編程?進程,線程和時間片交織和競爭條件線程安全 策略1:監禁 策略2:不可變性 策略3:使用線程安全數據類型 策略4:鎖定和同步 如何做安全論證總結 什么是并發編程? 并發并發性:多個計算同時發生。 在現代...
閱讀 1347·2023-01-11 13:20
閱讀 1685·2023-01-11 13:20
閱讀 1133·2023-01-11 13:20
閱讀 1860·2023-01-11 13:20
閱讀 4101·2023-01-11 13:20
閱讀 2705·2023-01-11 13:20
閱讀 1386·2023-01-11 13:20
閱讀 3598·2023-01-11 13:20