Shulou(Shulou.com)06/01 Report--

1. Reference documentation

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

two。 Error handling 2.1. ORA-31466: no published content found

When executing the subscription table information, prompt ORA-31466: the published content was not found, and it was found that the query permission to change the table cdc_employee_info was not granted to the subscriber user cdc_subscriber.

Solution:

SQL > conn cdc_publisher/cdc_publisher

Connected.

SQL > grant select on cdc_employee_info to cdc_subscriber

Grant succeeded.

2.2. After the subscription is activated, the source table is manipulated and no data is captured.

When I monitored the employee_info table of SYS users, there was no exception, but the data could not be captured. Later, I replaced the employee_info table for backupuser users and followed the above steps to capture the data normally. The official website did not find the relevant documentation, which is very strange and needs further research.

2.3. ORA-26723 creates changeset and reports an error

Error content:

ORA-26723: the user "SYS" requires the role "DV_STREAMS_ADMIN/DV_XSTREAM_ADMIN/DV_GOLDENGATE_ADMIN"

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

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

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

ORA-06512: in line 1

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

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

ORA-06512: in line 2

The solution is to shut down dba vault.

1) close the database

2) execute as oracle user on all nodes: 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: invalid DDL_MARKERS value

In synchronous mode, create a change record table and perform an error report:

ORA-31489: invalid DDL_MARKERS value

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

ORA-06512: in line 2

Deal with:

Ddl_markers defaults to y, but synchronization needs to be n

2.5. Start publish and subscribe log display

Database alert log

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.