1 OGG进程异常终止
REPLICAT ABENDED reptest 00:00:00 00:08:22
GGSCI (host1) 13> info reptest
REPLICAT reptest Last Started 2023-02-22 16:08 Status ABENDED
Checkpoint Lag 00:00:00 (updated 00:08:45 ago)
Log Read Checkpoint File ./dirdat/dn/dn000046
2023-02-22 15:42:53.999701 RBA 32786889
2 查看报错信息
2023-02-22 16:08:29 WARNING OGG-01154 SQL error 1438 mapping usera.TBALE_A to userb.TBALE_A OCI
Error ORA-01438: value larger than specified precision allowed for this column (status = 1438).
INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "userb"."TBALE_A" ..............
2023-02-22 16:08:29 WARNING OGG-01003 Repositioning to rba 32786889 in seqno 46.
Source Context :
SourceModule : [er.errors]
SourceID : [/scratch/pradshar/view_storage/pradshar_pse_15852019/oggcore/OpenSys/src/app/er/errors.cpp]
SourceFunction : [take_rep_err_action]
SourceLine : [623]
ThreadBacktrace : [8] elements
: [/goldengate/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7fc489de571e]]
: [/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7fc489dde6bc]]
: [/goldengate/libgglog.so(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)
1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, CMessageFactory::MessageDisposition)+0x53) [0x7fc489dda581]]
: [/goldengate/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, __std_rec_hdr*, char*, file_def*, b
ool)+0xdac) [0x521a80]]
: [/goldengate/replicat(process_extract_loop()+0x2388) [0x53ad18]]
: [/goldengate/replicat(main+0x732) [0x54cbd2]]
: [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7fc4841b73d5]]
: [/goldengate/replicat(__gxx_personality_v0+0x31a) [0x4c0c6a]]
2023-02-22 16:08:29 ERROR OGG-01296 Error mapping from usera.TBALE_A to userb.TBALE_A.
3 查看Oracle对报错信息的解释，根据如下信息，认为是表的某个列，数据列精度不匹配，需要进行调整，即往大里调整
[oracle@host1 dirrpt]$ oerr ora 1438
01438, 00000, "value larger than specified precision allowed for this column"
// *Cause: When inserting or updating records, a numeric value was entered
// that exceeded the precision defined for the column.
// *Action: Enter a value that complies with the numeric column's precision,
// or use the MODIFY option with the ALTER TABLE command to expand
// the precision.
4 由于以上报错信息，没有说明哪个列的数据精度有问题，则需要对比源端和目标端的表结构，将number类型的进行比对
5 查看OGG源端和目标端的映射关系，发现column_A的长度为20，比表目前设置的值大1
map usera.TBALE_A target userb.TBALE_A, KEYCOLS (COLUMN_B), colmap (usedefaults, target_write_time = @datenow(),
source_change_time = @GETENV ("GGHEADER", "COMMITTIMESTAMP"), CONTAINER = 959, C_COLUMN_A = 1019, COLUMN_A = @STRCAT("612", column2),
COLUMN_B = @STRCAT("612", column1));
6 使用discard进行数据分析，确定column_A列值比设置的小
7 修改表结果，并重启进程，ogg进程恢复正常
SYS@instance1 > alter table userb.TBALE_A modify COLUMN_A NUMBER(20);
Table altered.
GGSCI (host1) 19> start reptest
Sending START request to MANAGER ...
REPLICAT reptest starting
GGSCI (host1) 20> info reptest
REPLICAT reptest Last Started 2023-02-22 16:30 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint File ./dirdat/dn/dn000046
2023-02-22 16:29:59.000150 RBA 32790448