成人国产在线小视频_日韩寡妇人妻调教在线播放_色成人www永久在线观看_2018国产精品久久_亚洲欧美高清在线30p_亚洲少妇综合一区_黄色在线播放国产_亚洲另类技巧小说校园_国产主播xx日韩_a级毛片在线免费

資訊專(zhuān)欄INFORMATION COLUMN

GoldenGate REP進(jìn)程abend問(wèn)題處理

IT那活兒 / 2825人閱讀
GoldenGate REP進(jìn)程abend問(wèn)題處理

點(diǎn)擊上方“IT那活兒”公眾號(hào)，關(guān)注后了解更多內(nèi)容，不管IT什么活兒，干就完了?。?！


  

某客戶(hù)現(xiàn)場(chǎng)有一套數(shù)據(jù)同步環(huán)境，通過(guò)Oracle GoldenGate工具進(jìn)行同步，但同步過(guò)程中Rep進(jìn)程經(jīng)常Abend，嚴(yán)重影響數(shù)據(jù)同步的一致性，下面就一起帶大家了解解決該問(wèn)題的全過(guò)程。

 


問(wèn)題分析過(guò)程


1. 查看備庫(kù)rep進(jìn)程日志：
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.
除此之外，沒(méi)有明顯報(bào)錯(cuò)。
2. 查看備庫(kù)dsc文件：
vi /ogg/ggs/dirrpt/repdsc.dsc
Oracle GoldenGate Delivery for Oracle process started, group REP discard file opened: 2022-03-22 09:42:02
Key column UPDATETIME (45) is missing from update on table MKT01.TABLE1
Missing 1 key columns in update for table MKT01.TABLE1.
注意：報(bào)錯(cuò)UPDATETIME 找不到，其實(shí)在備庫(kù)和主庫(kù)，都是有此列的。注意報(bào)錯(cuò)中的45，45是在dba_log_group_columns中 MKT01.TABLE1表該列的位置(position)。
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
3. 根據(jù)Mos相關(guān)資料得知以下信息 ：

Would it be feasible to exclude the table and sync it up later.


It looks like trandata was not added again when the col46 column was added on source. The values of updatetime would be null on target as no value would be replicated if keycols are used.

--Output from source.

select count(1) from dba_log_group_columns where table_name=TABLE1;

If it returns as 45, please delete the trandata and re-add it again.

It should return as 46.

 

4. 檢查相關(guān)環(huán)境信息：

  • 實(shí)際上 select *  from dba_log_group_columns where table_name=TABLE1;這個(gè)就反饋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

此查詢(xún)返回如下的結(jié)果：
TABLE1_LS
WY_XQXXB_LS
WY_XQXXB
TABLE1
TABLE11
就是說(shuō)，如上的5個(gè)表在 dba_log_groups中有，但是在 dba_log_group_columns中沒(méi)有。
對(duì)此現(xiàn)象，參考資料：
OGG Supplemental Redo Log Data Is Enabled But Select From Dba_log_group_columns dont show the table. (Doc ID 1359172.1)
在此文章中，給出如下解釋?zhuān)?/span>

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. 


5. 先在rep進(jìn)程中排除此表，當(dāng)lag為0時(shí)，再初始化同步此表，問(wèn)題解決。




本文作者：張連坤

本文來(lái)源：IT那活兒（上海新炬王翦團(tuán)隊(duì)）

文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載,若此文章存在違規(guī)行為，您可以聯(lián)系管理員刪除。

轉(zhuǎn)載請(qǐng)注明本文地址：http://systransis.cn/yun/129478.html

相關(guān)文章

  • 第10章：并發(fā)和分布式編程 10.1并發(fā)性和線程安全性

    摘要：并發(fā)模塊本身有兩種不同的類(lèi)型進(jìn)程和線程，兩個(gè)基本的執(zhí)行單元。調(diào)用以啟動(dòng)新線程。在大多數(shù)系統(tǒng)中，時(shí)間片發(fā)生不可預(yù)知的和非確定性的，這意味著線程可能隨時(shí)暫?；蚧謴?fù)。 大綱 什么是并發(fā)編程？進(jìn)程，線程和時(shí)間片交織和競(jìng)爭(zhēng)條件線程安全 策略1：監(jiān)禁 策略2：不可變性 策略3：使用線程安全數(shù)據(jù)類(lèi)型 策略4：鎖定和同步 如何做安全論證總結(jié) 什么是并發(fā)編程？ 并發(fā)并發(fā)性：多個(gè)計(jì)算同時(shí)發(fā)生。 在現(xiàn)代...

    instein 評(píng)論0 收藏0

發(fā)表評(píng)論

0條評(píng)論

最新活動(dòng)
閱讀需要支付1元查看
<