新鄭網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián)公司,新鄭網(wǎng)站設(shè)計(jì)制作，有大型網(wǎng)站制作公司豐富經(jīng)驗(yàn)。已為新鄭上千余家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\成都外貿(mào)網(wǎng)站建設(shè)公司要多少錢，請(qǐng)找那個(gè)售后服務(wù)好的新鄭做網(wǎng)站的公司定做！

1. 參考文檔

http://blog.csdn.net/chentaocba/article/details/7435131

http://www.cnblogs.com/myrunning/p/5329139.html

 

Oracle 10.2 CDC：http://docs.oracle.com/cd/B19306_01/server.102/b14223/cdc.htm

Oracle 11g CDC：http://docs.oracle.com/cd/B28359_01/server.111/b28313/cdc.htm#CHDEHIIE

DBMS_CDC_PUBLISH：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_cdcpub.htm#ARPLS023

DBMS_CDC_SUBSCRIBE：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_cdcsub.htm#ARPLS024

Oracle 11.2 CDC:

https://docs.oracle.com/cd/E11882_01/server.112/e25554/cdc.htm#DWHSG016

 

 

2. 錯(cuò)誤處理

2.1. ORA-31466:未找到發(fā)布內(nèi)容

執(zhí)行訂閱表信息時(shí)，提示ORA-31466：未找到發(fā)布內(nèi)容，排查發(fā)現(xiàn)是沒(méi)有將變更表cdc_employee_info的查詢權(quán)限賦予訂閱者用戶cdc_subscriber導(dǎo)致。

解決方法：

SQL> conn cdc_publisher/cdc_publisher

Connected.

SQL> grant select on cdc_employee_info to cdc_subscriber;

Grant succeeded.

2.2. 激活訂閱之后，對(duì)源表進(jìn)行操作，捕獲不到數(shù)據(jù)

監(jiān)控SYS用戶的employee_info表，沒(méi)有出現(xiàn)任何異常，就是捕獲不到數(shù)據(jù)，后來(lái)我替換給backupuser用戶的employee_info表，按照以上步驟操作，就能正常捕獲到數(shù)據(jù)了，官網(wǎng)也沒(méi)查到相關(guān)的文檔說(shuō)明，很奇怪，還需要進(jìn)一步研究。

2.3. ORA-26723創(chuàng)建變更集報(bào)錯(cuò)

報(bào)錯(cuò)內(nèi)容：

ORA-26723:用戶 "SYS"要求角色 "DV_STREAMS_ADMIN/DV_XSTREAM_ADMIN/DV_GOLDENGATE_ADMIN"

ORA-06512:在 "SYS.DBMS_LOGREP_UTIL", line 197

ORA-06512:在 "SYS.DBMS_LOGREP_UTIL", line 240

ORA-06512:在 "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 391

ORA-06512:在 line 1

ORA-06512:在 "SYS.DBMS_CDC_PUBLISH", line 719

ORA-06512:在 "SYS.DBMS_CDC_PUBLISH", line 927

ORA-06512:在 line 2

 

處理辦法就是關(guān)閉dba vault。

1)     關(guān)閉數(shù)據(jù)庫(kù)；

2)     在所有節(jié)點(diǎn)上以oracle用戶執(zhí)行：oracle> chopt disable dv

Writing to /oracle/app/oracle/product/11.2.0/install/disable_dv.log...

/usr/bin/make -f /oracle/app/oracle/product/11.2.0/rdbms/lib/ins_rdbms.mk dv_off ORACLE_HOME=/oracle/app/oracle/product/11.2.0

/usr/bin/make -f /oracle/app/oracle/product/11.2.0/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/oracle/app/oracle/product/11.2.0

2.4. ORA-31489: DDL_MARKERS值無(wú)效

同步模式中，創(chuàng)建變更記錄表，執(zhí)行報(bào)錯(cuò)：

ORA-31489: DDL_MARKERS值無(wú)效

ORA-06512:在 "SYS.DBMS_CDC_PUBLISH", line 1002

ORA-06512:在 line 2

處理：

ddl_markers默認(rèn)是y,但同步得用n;

 

2.5. 啟動(dòng)發(fā)布訂閱日志顯示

數(shù)據(jù)庫(kù)alert日志

Logminer Bld: Done

Streams Capture: CDC$C_CDC_SCOTT_TEST CAPTURE Created

CAPTURE CDC$C_CDC_SCOTT_TEST: Start SCN: 1924579 (0x1d5de3.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: First SCN: 1924579 (0x1d5de3.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: Required Checkpoint SCN: 0 (0x0000.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: Captured SCN: 0 (0x0000.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: Applied SCN: 0 (0x0000.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: Capture Type: LOCAL

CAPTURE CDC$C_CDC_SCOTT_TEST: Logminer Id: 1

CAPTURE CDC$C_CDC_SCOTT_TEST: Source Database: ORCL.SITE

knlciAlterCapture: start scn is changed to 1925382 (0x1d6106.00000000) for CAP CDC$C_CDC_SCOTT_TEST.

Thu Feb 08 20:03:32 2018

Streams APPLY AP01 for CDC$A_CDC_SCOTT_TEST started with pid=31, OS id=13370

APPLY CDC$A_CDC_SCOTT_TEST: Apply User: CDC_PUBLISHER

APPLY CDC$A_CDC_SCOTT_TEST: Apply Tag: 0

APPLY CDC$A_CDC_SCOTT_TEST: Parameter Set by User: COMMIT_SERIALIZATION Value: NONE

APPLY CDC$A_CDC_SCOTT_TEST: Parameter Set by User: DISABLE_ON_ERROR Value: Y

APPLY CDC$A_CDC_SCOTT_TEST: Parameter Set by User: DISABLE_ON_LIMIT Value: Y

Thu Feb 08 20:03:32 2018

Streams CAPTURE CP01 for CDC$C_CDC_SCOTT_TEST started with pid=32, OS id=13372

CAPTURE CDC$C_CDC_SCOTT_TEST: Start SCN: 1925382 (0x1d6106.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: First SCN: 1924579 (0x1d5de3.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: Required Checkpoint SCN: 0 (0x0000.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: Captured SCN: 0 (0x0000.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: Applied SCN: 0 (0x0000.00000000)

CAPTURE CDC$C_CDC_SCOTT_TEST: Capture Type: LOCAL

CAPTURE CDC$C_CDC_SCOTT_TEST: Logminer Id: 1

CAPTURE CDC$C_CDC_SCOTT_TEST: Source Database: ORCL.SITE

CAPTURE CDC$C_CDC_SCOTT_TEST: Parameter Set by User: DISABLE_ON_LIMIT Value: Y

CAPTURE CDC$C_CDC_SCOTT_TEST: Parameter Set by User: MAXIMUM_SCN Value: INFINITE

Thu Feb 08 20:03:32 2018

Streams Apply Reader for CDC$A_CDC_SCOTT_TEST started AS01 with pid=41 OS id=13374

Thu Feb 08 20:03:32 2018

Streams Apply Server for CDC$A_CDC_SCOTT_TEST started AS02 with pid=42 OS id=13376

 

Thu Feb 08 20:03:32 2018

Propagation Sender/Receiver (CCA) for Streams Capture  and Apply CDC$A_CDC_SCOTT_TEST with pid=43, OS id=13378 started.

APPLY CDC$A_CDC_SCOTT_TEST: Source Database: NA

APPLY CDC$A_CDC_SCOTT_TEST: Applied Message Number: NA

APPLY CDC$A_CDC_SCOTT_TEST: Message Create Time: NA

First applied SCN for apply w/ object number 91923 and subscriber sequence number 1 is updated to SCN: 0 (0x0000.00000000)

First applied SCN of the Streams path from capture (CDC$C_CDC_SCOTT_TEST) to propagation () to apply (CDC$A_CDC_SCOTT_TEST) is set to SCN: 1924579 (0x1d5de3.00000000)

Streams CAPTURE CP01 for CDC$C_CDC_SCOTT_TEST with pid=32, OS id=13372 is in combined capture and apply mode.

Capture CDC$C_CDC_SCOTT_TEST is handling 1 applies.

Starting persistent Logminer Session with sid = 1 for Streams Capture CDC$C_CDC_SCOTT_TEST

LOGMINER: Parameters summary for session# = 1

LOGMINER: Number of processes = 3, Transaction Chunk Size = 1

LOGMINER: Memory Size = 30M, Checkpoint interval = 1000M

LOGMINER: SpillScn 0, ResetLogScn 1286002

LOGMINER: summary for session# = 1

LOGMINER: StartScn: 1925373 (0x0000.001d60fd)

LOGMINER: EndScn: 0

LOGMINER: HighConsumedScn: 1925382 (0x0000.001d6106)

LOGMINER: session_flag: 0x0

LOGMINER: Read buffers: 16

LOGMINER: Memory LWM: limit 10M, LWM 24M, 80%

LOGMINER: Memory Release Limit: 1M

LOGMINER: LowCkptScn: 0 (0x0000.00000000)

LOGMINER: HighCkptScn: 0 (0x0000.00000000)

LOGMINER: SkipScn: 1924579 (0x0000.001d5de3)

Thu Feb 08 20:03:39 2018

LOGMINER: session#=1 (CDC$C_CDC_SCOTT_TEST), reader MS00 pid=46 OS id=13385 sid=138 started

Thu Feb 08 20:03:39 2018

LOGMINER: session#=1 (CDC$C_CDC_SCOTT_TEST), builder MS01 pid=47 OS id=13387 sid=202 started

Thu Feb 08 20:03:39 2018

LOGMINER: session#=1 (CDC$C_CDC_SCOTT_TEST), preparer MS02 pid=48 OS id=13389 sid=15 started

LOGMINER: Begin mining logfile during dictionary load for session 1 thread 1 sequence 63, /oracle/app/oracle/fast_recovery_area/ORCL/archivelog/2018_02_08/o1_mf_1_63_f7rh2v7s_.arc

 

文章題目：Oracle_CDC整理3-參考及錯(cuò)誤處理
文章網(wǎng)址：http://jinyejixie.com/article24/pdcjje.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供云服務(wù)器、網(wǎng)站導(dǎo)航、虛擬主機(jī)、微信小程序、品牌網(wǎng)站建設(shè)、網(wǎng)站策劃

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)