OGG的抽取进程和投递进程报OGG-01777错误

1 查看OGG进程状态，发现报错  EXTRACT     ABENDED     DPEJA       00:00:00      03:31:53      EXTRACT     ABENDED     EXTJA       00:00:00      03:13:01     2 查看报错信息，发现报OGG-01777错误，意思为trail文件号达到最大值999999 2021-08-10 05:58:20  INFO    OGG-01056  Recovery initialization completed for target file ./dirdat/ja/ja999999, at RBA 199999725, CSN 15824757068881. 2021-08-10 05:58:20  INFO    OGG-01478  Output file ./dirdat/ja/ja is using format RELEASE 11.2. Source Context :   SourceModule            : [er.extrout]   SourceID                : [/scratch/pradshar/view_storage/pradshar_pse_15852019/oggcore/OpenSys/src/app/er/extrout.c]   SourceFunction          : [handle_rollover]   SourceLine              : [2679]   ThreadBacktrace         : [8] elements                           : [/goldengate/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7fdd6f3ab71e]]                           : [/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7fdd6f3a46bc]]                           : [/goldengate/libgglog.so(_MSG_ERR_TRAIL_SEQNO_ERROR(CSourceContext*, CMessageFactory::MessageDisposition)+0x2c) [0x7fdd6f 385044]]                           : [/goldengate/extract(handle_rollover(extract_def*, __std_rec_hdr*)+0x1e6) [0x51a4b2]]                           : [/goldengate/extract(RECOVERY_writeRestartRecord(bool)+0x2ec) [0x52c48c]]                           : [/goldengate/extract(main+0x511) [0x574141]]                           : [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7fdd6b4e73d5]]                           : [/goldengate/extract(__gxx_personality_v0+0x392) [0x4ee23a]] 2021-08-10 05:58:20  ERROR   OGG-01777  Extract abended as it ran out of sequence numbers used to  create TRAIL files.  The maximum number of TRAIL files allowed is 999999. 2021-08-10 05:58:20  ERROR   OGG-01668  PROCESS ABENDING. 3 查看抽取进程生成的trail文件号，确实达到最大值 查看trail文件： -rw-rw-rw- 1 oracle oinstall 199999273 Aug 10 04:55 ja999996 -rw-rw-rw- 1 oracle oinstall 199998351 Aug 10 04:55 ja999997 -rw-rw-rw- 1 oracle oinstall 199998959 Aug 10 04:56 ja999998 -rw-rw-rw- 1 oracle oinstall 199999725 Aug 10 04:56 ja999999 4 查看trail文件的号，发现抽取和投递的trail文件号都达到了最大值 GGSCI (hosttest) 6> info exttrail * ....        Extract Trail: ./dirdat/aa              Extract: DPEJA                Seqno: 999999                  RBA: 184040692            File Size: 200M        Extract Trail: ./dirdat/ja/ja              Extract: EXTJA                Seqno: 999999                  RBA: 76124583            File Size: 200M 5 查看OGG读取的RBA号，发现投递进程由于号码达到999999，只投递到抽取进程的999896文件， 还有一百多的trail文件没有投递过去。故需要先将这部分数据投递过去。 GGSCI (hosttest) 10> info EXTJA EXTRACT    EXTJA     Last Started 2021-08-10 08:17   Status ABENDED Checkpoint Lag       00:00:00 (updated 03:23:43 ago) Log Read Checkpoint  Oracle Redo Logs                      2021-08-10 04:56:11  Thread 1, Seqno 880865, RBA 822924580                      SCN 3684.2097532919 (15824757051383) Log Read Checkpoint  Oracle Redo Logs                      2021-08-10 04:56:12  Thread 2, Seqno 473461, RBA 1741946996                      SCN 3684.2097536463 (15824757054927) Log Read Checkpoint  Oracle Redo Logs                      2021-08-10 04:56:08  Thread 3, Seqno 590152, RBA 817103536                      SCN 3684.2097519900 (15824757038364)                       GGSCI (hosttest) 7> info DPEJA EXTRACT    DPEJA     Last Started 2021-08-10 08:06   Status ABENDED Checkpoint Lag       00:00:00 (updated 03:34:34 ago) Log Read Checkpoint  File ./dirdat/ja/ja999896                      2021-08-10 04:34:40.000000  RBA 143927986 6 首先修改投递进程的远程投递的trail文件名 dblogin USERID goldengate, PASSWORD xxxxxx ADD RMTTRAIL ./dirdat/jb, EXTRACT DPEJA, MEGABYTES 500 启动进程 GGSCI (hosttest) 40> start DPEJA Sending START request to MANAGER ... EXTRACT DPEJA starting 查看进程状态，发现数据已经投递过去 GGSCI (hosttest) 56> ! info DPEJA EXTRACT    DPEJA     Last Started 2021-08-10 08:38   Status RUNNING Checkpoint Lag       03:45:21 (updated 00:00:45 ago) Log Read Checkpoint  File ./dirdat/ja/ja999999                      2021-08-10 04:56:04.000000  RBA 7921111                       查看日志，发现也同步到最后一个trail文件 Switching to next trail file ./dirdat/ja/ja999998 at 2021-08-10 08:41:23 due to EOF, with current RBA 199998351 Opened trail file ./dirdat/ja/ja999998 at 2021-08-10 08:41:23 Switching to next trail file ./dirdat/ja/ja999999 at 2021-08-10 08:41:25 due to EOF, with current RBA 199998959 Opened trail file ./dirdat/ja/ja999999 at 2021-08-10 08:41:25 2021-08-10 08:41:25  INFO    OGG-01026  Rolling over remote file ./dirdat/jb000041.   7 修改抽取进程的trail文件名称为jb,大小更改为500M GGSCI (hosttest) 75> add EXTTRAIL ./dirdat/ja/jb, EXTRACT EXTJA, MEGABYTES 500 EXTTRAIL added. 启动抽取进程，发现报如下错误： 2021-08-10 08:45:50  INFO    OGG-01517  Position of first record processed for Thread 1, Sequence 880713,  RBA 14008336, SCN 3684.2058085882, Aug 10,  2021 1:40:18 AM. Source Context :   SourceModule            : [er.extrout]   SourceID                : [/scratch/pradshar/view_storage/pradshar_pse_15852019/oggcore/OpenSys/src/app/er/extrout.c]   SourceFunction          : [get_extract_chkpts]   SourceLine              : [2780]   ThreadBacktrace         : [7] elements                           : [/goldengate/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f6539a9871e]]                           : [/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7f6539a916bc]]                           : [/goldengate/libgglog.so(_MSG_ERR_STARTUP_PARAMERROR_MISSING_REMOTE_TRAIL(CSourceContext*, char const*, CMessageFactory:: MessageDisposition)+0x31) [0x7f6539a7c56b]]                           : [/goldengate/extract(get_extract_chkpts(chkpt_context_t*)+0x19e) [0x5124de]]                           : [/goldengate/extract(main+0x3ef) [0x57401f]]                           : [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f6535bd43d5]]                           : [/goldengate/extract(__gxx_personality_v0+0x392) [0x4ee23a]] 2021-08-10 08:45:50  ERROR   OGG-01044  The trail './dirdat/ja/ja' is not assigned to extract 'EXTJA'. Assign the trail to the extract with the comma nd "ADD EXTTRAIL/RMTTRAIL ./dirdat/ja/ja, EXTRACT EXTJA". 2021-08-10 08:45:50  INFO    OGG-01517  Position of first record processed for Thread 2, Sequence 473308, RBA 602136592, SCN 3684.2047361007, Aug 10,  2021 12:03:59 AM. 2021-08-10 08:45:50  INFO    OGG-01517  Position of first record processed for Thread 3, Sequence 590064, RBA 496930320, SCN 3684.2087458326, Aug 10,  2021 4:10:04 AM. 2021-08-10 08:45:50  ERROR   OGG-01668  PROCESS ABENDING. 经祥查，发现在参数文件中 EXTTRAIL ./dirdat/ja/ja  将此参数文件修改为EXTTRAIL ./dirdat/ja/jb 再次启动，抽取进程恢复正常 GGSCI (hosttest) 111> info EXTJA info EXTJA EXTRACT    EXTJA     Last Started 2021-08-10 09:10   Status RUNNING Checkpoint Lag       03:29:47 (updated 00:00:00 ago) Log Read Checkpoint  Oracle Redo Logs                      2021-08-10 06:24:27  Thread 1, Seqno 880925, RBA 835446204                      SCN 3684.2112674268 (15824772192732) Log Read Checkpoint  Oracle Redo Logs                      2021-08-10 06:20:03  Thread 2, Seqno 473530, RBA 414698976                      SCN 3684.2111821069 (15824771339533) Log Read Checkpoint  Oracle Redo Logs                      2021-08-10 06:24:27  Thread 3, Seqno 590309, RBA 1641280232                      SCN 3684.2112675461 (15824772193925)                       8 修改投递进程中trail文件名 ALTER EXTRACT  DPEJA, EXTTRAILSOURCE ./dirdat/ja/jb  GGSCI (hosttest) 124> ALTER EXTRACT  DPEJA, EXTTRAILSOURCE ./dirdat/ja/jb EXTRACT altered. 启动，数据正常投递到目标端 GGSCI (hosttest) 142> info DPEJA EXTRACT    DPEJA     Last Started 2021-08-10 10:21   Status RUNNING Checkpoint Lag       00:00:00 (updated 00:00:03 ago) Log Read Checkpoint  File ./dirdat/ja/jb000271                      2021-08-10 11:00:23.000000  RBA 7331898                       -rw-r----- 1 oracle oinstall 499999090 Aug 10 10:58 jb000308 -rw-r----- 1 oracle oinstall 499998593 Aug 10 10:58 jb000309 -rw-r----- 1 oracle oinstall 499998347 Aug 10 10:59 jb000310 -rw-r----- 1 oracle oinstall 499999800 Aug 10 10:59 jb000311 -rw-r----- 1 oracle oinstall 499998571 Aug 10 11:00 jb000312 -rw-r----- 1 oracle oinstall 255813156 Aug 10 11:02 jb000313 9 目标端 目标端的数据aa生成的trail文件应用完成，则需要修改为jb即可