ogg报错处理

报错信息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