更新时间:2026-08-26 GMT+08:00
Oracle为源实时同步
- 全量同步失败报错,关键词“has date/datetime: *** which is outside of dest allowed range”
- 全量或增量阶段失败报错,关键词“Got minus one from a read call”
- 增量同步失败报错,关键词“Source supplemental log level is PK/UI. Missing column data at delete+insert on ***”
- 增量同步失败报错,关键词“timeout when get next file log, maybe has been deleted, please check it.”
- 增量同步失败报错,关键词“Failed to construct kafka producer. ”
- 增量同步失败报错,关键词“Topic *** not present in metadata after 300000 ms”
- 全量同步失败报错,关键词“bind column[***] value failed: column:**invalid value:Infinity”
- 全量同步失败报错,关键词“Database connection failed when starting copy”
- 全量同步失败报错,关键词“Requested array size exceeds VM limit”
- 全量同步失败报错,关键词“apply to *** failed: [***] ERROR: Out of memory.”
- 全量同步失败报错,关键词“apply to *** failed:[***] ERROR: numeric field overflow.”
- 全量同步失败报错,关键词“Unable to connect to DBMS,Caused by:IO Error: Got minus one from a read call.”
- 全量同步失败报错,关键词“Unable to connect to DBMS,Caused by:IO Error: Connecttion reset by peer,Authentication lapse ***ms.”
- 全量同步失败报错,关键词“apply table *** data failed: [***] ERROR: inserted partition key does not map to any table partition.”
- 全量同步失败报错,关键词“service DATAMOVE failed, cause by:IO Error:Sockect read timed out”.
- 全量同步失败报错,关键词“apply to *** failed:[***] ERROR: character with byte sequence 0xef 0xbf 0xbd in encoding 'UTF-8' has no equivalent in encoding 'GBK' Where: COPY ***”
- 全量同步失败报错,关键词“ORA-01555:snapshot too old: rollback segment number *** with name ‘***’ too small”
- 全量同步失败报错,关键词“apply to *** failed:[***] ERROR: value too long for type character varying(32)”
- 全量同步失败报错,关键词“apply to *** failed:[***] ERROR: Don't support COPY FROM table with INSERT triggers Hint”
- 全量同步失败报错,关键词“ERROR: invalid byte sequence for encoding "UTF8": 0x00”
- 全量同步失败报错,关键词“ERROR: duplicate key value violates unique constraint”
- 增量同步失败报错,关键词“service INCREMENT failed,cause by:column xx of primary key null in table xxx value is null”
- 增量同步失败报错,关键词“ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT”
- 增量同步失败报错,关键词“arch log of thread x is deleted, sequence is xxx”
- 增量同步失败报错,关键词“An error occurred in the process CAPTURER, caused by: back query failed,table:***,scn:***, back query failed ,sql: ***, error: ORA-00904: 'xx': invalid identifier”
- 增量同步失败报错,关键词“oracle supplemental log level min is off,stop work”或“The minimum supplemental log of the Oracle database is not enabled, stop working”
- 增量同步失败报错,关键词“LOGMANAGER,ORA-01284: file xx cannot be opened ORA-01090: shutdown in progress - connection is not permitted ORA-06512: at 'SYS.DBMS_LOGMNR'”
- 增量同步失败报错,关键词“An error occurred in the process INCREMENT,caused by: Source supplemental log level is PK/UI. Missing column data at delete+insert on table xxx”
- 增量同步失败报错,关键词“failed to delete index tuple(XXXX) = (XXXXXXX) in xx”
- 增量同步失败报错,关键词“ORA-01435: user does not exist, ORA-06512: at "SYS.DBMS_LOGMER"line 72: ORA-06512”或“ORA-16331: container 'HBYYDB' is not open ORA-06512: at 'SYS.DBMS_LOGMNR', line 58 ORA-06512: at line 1”
- 增量同步失败报错,关键词“service LOGMANAGER failed, caused by: ORA-06550, identifier 'SYS.DBMS_LOGMNR' must be declared”
- 增量同步失败报错,关键词“service INCREMENT failed, cause by: update xx.xxx failed: ERROR: Write to replicated table returned different results from the DataNodes on current DN:dn_*** and previous DN:dn_***”
- 增量同步失败报错,关键词“service INCREMENT failed, caused by : single update affect more than one row,stop work”
- 增量同步失败报错,关键词“service INCREMENT failed, caused by: column *** of primary key null in table table_name value not set in source db log”
- 增量同步失败报错,关键词“service LOGMANAGER failed, caused by: get Oracle log file info of sequence xx failed for can not find it”或“get Oracle log file info of sequence:xx failed for file is deleted”
- 全量或增量阶段失败报错,关键词“invalid byte sequence for encoding "UTF8": 0x00”
- 增量同步失败报错,关键词“parse DDL exception: Parse ddl: alter table 'xxx'.'xxxx' shrink space CHECK;. failed, seqno:xxxx”
父主题: 失败案例