Oracle OGG-00446错误处理
注意:OGG的命令结尾不需要带分号,否则报错!
1 发现问题
1.1 进程ABENDED
GGSCI (G3-XCLCT) 1> info exgj
EXTRACT EXGJ Last Started 2021-02-05 05:32 Status ABENDED
Checkpoint Lag 00:00:00 (updated 04:08:03 ago)
Log Read Checkpoint Oracle Redo Logs
2021-02-05 03:00:08 Seqno 1630, RBA 140551680
SCN 28.4096043455 (124355127743)
1.2 查看错误日志
GGSCI (G3-XCLCT) 2> view report exgj
2021-02-05 09:21:27 ERROR OGG-00446 Redo sequence 1630 no longer available in online logs for thread 1 without archiving enabled, SQL <SELECT MAX(sequenc
e#) FROM v$log WHERE thread# = :ora_thread>, error retrieving redo file name for sequence 1630, archived = 0, use_alternate = 0Not able to establish initial
position for se