报错信息1:
GGSCI (dbserver) 5>view report EORA_1
2020-04-18 15:02:06 ERROR OGG-00446 Could not find archived log for sequence 8432 thread 1 under default destinations SQL <SELECT name FROM v$archived_log WHE
RE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND deleted = 'NO' AND
name not like '+%' AND standby_dest = 'NO' >, error retrieving redo file name for sequence 8432, archived = 1, use_alternate = 0Not able to establish initi
al position for begin time 2020-04-07 10:29:29.
2020-04-18 15:02:06 ERROR OGG-01668 PROCESS ABENDING.
--sequence 8432这个seq找不到,查询一下seq
select FIRST_TIME,(sequence#) from v$archived_log order by FIRST_TIME desc;
......................
FIRST_TIME SEQUENCE#
------------ ----------
07-APR-20 8437
07-APR-20 8436
07-APR-20 8435
07-APR-20 8434
07-APR-20 8433
07-APR-20 8432
07-APR-20 8431
--设置为最大的seq
GGSCI (dbserver) 5> alter extract EORA_1 thread 1,extseqno 6312
报错信息2:
2020-04-18 21:22:48 ERROR OGG-01044 The trail '/app/oggdata/dirdat/pa' is not assigned to extract 'PORA_1'. Assign the trail to the extract with the command "ADD EX
TTRAIL/RMTTRAIL /app/oggdata/dirdat/pa, EXTRACT PORA_1".
2020-04-18 21:22:48 ERROR OGG-01668 PROCESS ABENDING.
明显是已经给出了答案:
修改路径
报错信息3:
复制char字段报错OGG-00869Invalid character value,因缺少trandata log引起
2020-04-19 10:35:18 WARNING OGG-00869 [SQL error 0 (0x0)][Oracle][ODBC PostgreSQL Wire Protocol driver]Invalid character value. Error in parameter 2.
2020-04-19 10:35:18 WARNING OGG-01004 Aborted grouped transaction on 'ogg.t_ogg2', Database error 0 ([SQL error 0 (0x0)][Oracle][ODBC PostgreSQL Wire Protocol driver]
Invalid character value. Error in parameter 2.
).
2020-04-19 10:35:18 WARNING OGG-01003 Repositioning to rba 5401 in seqno 2.
2020-04-19 10:35:18 WARNING OGG-00869 [SQL error 0 (0x0)][Oracle][ODBC PostgreSQL Wire Protocol driver]Invalid character value. Error in parameter 2.
2020-04-19 10:35:18 WARNING OGG-01151 Error mapping from OGG.T_OGG2 to ogg.t_ogg2.
处理方式:
Oracle 端:
./ggsci
GGSCI (dbserver) 17> dblogin userid ogg password ogg
Successfully logged into database.
GGSCI (dbserver) 18> list table ogg.*
OGG.T_OGG
OGG.T_OGG2
Found 2 tables matching list criteria.
--查看trandata
GGSCI (dbserver) 19> info trandata ogg.*
Logging of supplemental redo log data is disabled for table OGG.T_OGG.
Logging of supplemental redo log data is disabled for table OGG.T_OGG2.
--先停止extract进程
GGSCI (dbserver) 20> stop EORA_1
Sending STOP request to EXTRACT EORA_1 ...
Request processed.
--增加trandata
GGSCI (dbserver) 21> add trandata ogg.*
Logging of supplemental redo data enabled for table OGG.T_OGG.
Logging of supplemental redo data enabled for table OGG.T_OGG2.
GGSCI (dbserver) 22> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EORA_1 00:00:00 00:00:19
EXTRACT RUNNING PORA_1 00:00:00 00:00:01
GGSCI (dbserver) 23> start EXTRACT EORA_1
Sending START request to MANAGER ...
EXTRACT EORA_1 starting
GGSCI (dbserver) 24> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORA_1 00:00:34 00:00:01
EXTRACT RUNNING PORA_1 00:00:00 00:00:04