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即可