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

执行订阅表信息时，提示ORA-31466：未找到发布内容，排查发现是没有将变更表cdc_employee_info的查询权限赋予订阅者用户cdc_subscriber导致。

解决方法：

SQL> conncdc_publisher/cdc_publisher

Connected.

SQL> grantselect on cdc_employee_info to cdc_subscriber;

Grant succeeded.

监控SYS用户的employee_info表，没有出现任何异常，就是捕获不到数据，后来我替换给backupuser用户的employee_info表，按照以上步骤操作，就能正常捕获到数据了，官网也没查到相关的文档说明，很奇怪，还需要进一步研究。

报错内容：

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

处理办法就是关闭dbavault。

1) 关闭数据库；

2) 在所有节点上以oracle用户执行：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_offORACLE_HOME=/oracle/app/oracle/product/11.2.0

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

同步模式中，创建变更记录表，执行报错：

ORA-31489:DDL_MARKERS 值无效

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

ORA-06512: 在 line 2

处理：

ddl_markers默认是y,但同步得用n;

数据库alert日志

Logminer Bld:Done

Streams Capture:CDC$C_CDC_SCOTT_TEST CAPTURE Created

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

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

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

CAPTURECDC$C_CDC_SCOTT_TEST: Captured SCN: 0 (0x0000.00000000)

CAPTURECDC$C_CDC_SCOTT_TEST: Applied SCN: 0 (0x0000.00000000)

CAPTURECDC$C_CDC_SCOTT_TEST: Capture Type: LOCAL

CAPTURECDC$C_CDC_SCOTT_TEST: Logminer Id: 1

CAPTURECDC$C_CDC_SCOTT_TEST: Source Database: ORCL.SITE

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

Thu Feb 0820:03:32 2018

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

APPLYCDC$A_CDC_SCOTT_TEST: Apply User: CDC_PUBLISHER

APPLYCDC$A_CDC_SCOTT_TEST: Apply Tag: 0

APPLYCDC$A_CDC_SCOTT_TEST: Parameter Set by User: COMMIT_SERIALIZATION Value: NONE

APPLYCDC$A_CDC_SCOTT_TEST: Parameter Set by User: DISABLE_ON_ERROR Value: Y

APPLYCDC$A_CDC_SCOTT_TEST: Parameter Set by User: DISABLE_ON_LIMIT Value: Y

Thu Feb 0820:03:32 2018

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

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

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

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

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

CAPTURECDC$C_CDC_SCOTT_TEST: Applied SCN: 0 (0x0000.00000000)

CAPTURECDC$C_CDC_SCOTT_TEST: Capture Type: LOCAL

CAPTURECDC$C_CDC_SCOTT_TEST: Logminer Id: 1

CAPTURECDC$C_CDC_SCOTT_TEST: Source Database: ORCL.SITE

CAPTURECDC$C_CDC_SCOTT_TEST: Parameter Set by User: DISABLE_ON_LIMIT Value: Y

CAPTURECDC$C_CDC_SCOTT_TEST: Parameter Set by User: MAXIMUM_SCN Value: INFINITE

Thu Feb 0820:03:32 2018

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

Thu Feb 0820:03:32 2018

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

Thu Feb 0820:03:32 2018

PropagationSender/Receiver (CCA) for Streams Captureand Apply CDC$A_CDC_SCOTT_TEST with pid=43, OS id=13378 started.

APPLYCDC$A_CDC_SCOTT_TEST: Source Database: NA

APPLYCDC$A_CDC_SCOTT_TEST: Applied Message Number: NA

APPLYCDC$A_CDC_SCOTT_TEST: Message Create Time: NA

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

First appliedSCN 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 CAPTURECP01 for CDC$C_CDC_SCOTT_TEST with pid=32, OS id=13372 is in combined captureand apply mode.

CaptureCDC$C_CDC_SCOTT_TEST is handling 1 applies.

Startingpersistent Logminer Session with sid = 1 for Streams CaptureCDC$C_CDC_SCOTT_TEST

LOGMINER:Parameters summary for session# = 1

LOGMINER: Numberof processes = 3, Transaction Chunk Size = 1

LOGMINER: MemorySize = 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: Readbuffers: 16

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

LOGMINER: MemoryRelease Limit: 1M

LOGMINER:LowCkptScn: 0 (0x0000.00000000)

LOGMINER:HighCkptScn: 0 (0x0000.00000000)

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

Thu Feb 0820:03:39 2018

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

Thu Feb 0820:03:39 2018

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

Thu Feb 0820:03:39 2018

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

LOGMINER: Beginmining 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