Q43:

在xxxx平台RAC DB GGS在OS重启后出现如下问题：

--------

2017-02-08 17:00:53  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start XXXlc.

2017-02-08 17:00:53  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host paydb01 (START XXXRACT XXXLC ).

2017-02-08 17:00:53  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  XXXRACT XXXLC starting.

2017-02-08 17:00:53  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  XXXRACT XXXLC starting.

2017-02-08 17:00:53  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.

2017-02-08 17:00:53  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  Virtual Memory Facilities for: COM

    anon alloc: mmap(MAP_ANON)  anon free: munmap

    file alloc: mmap(MAP_SHARED)  file free: munmap

    target directories:

    /ggs/dirtmp.

2017-02-08 17:00:53  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  XXXRACT XXXLC started.

2017-02-08 17:00:58  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  Socket buffer size set to 27985 (flush size 27985).

2017-02-08 17:00:58  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  Recovery initialization completed for target file ./dirdat/rm000468, at RBA 1

182.

2017-02-08 17:00:58  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  Output file ./dirdat/rm is using format RELEASE 11.2.

2017-02-08 17:00:58  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  Rolling over remote file ./dirdat/rm000469.

2017-02-08 17:00:58  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  Recovery completed for target file ./dirdat/rm000469, at RBA 1144.

2017-02-08 17:00:58  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  Recovery completed for all targets.

2017-02-08 17:00:58  ERROR   OGG-01091  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  Unable to open file "./dirdat/lc000464" (error 2, No such file or directory).

2017-02-08 17:00:58  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, XXXlc.prm:  PROCESS ABENDING.

A43:

看起来是OS重启时463号文件出问题导致，手动调到464,再对比数据补齐差异

最后比对差异太大，还是要重做。

GGSCI (paydb01) 3> info XXXlc

XXXRACT    XXXLC     Initialized   2017-02-09 09:37   Status ABENDED

Checkpoint Lag       19:51:16 (updated 00:00:11 ago)

Log Read Checkpoint  File ./dirdat/lc000463

                     2017-02-08 14:48:27.000000  RBA 24403728

GGSCI (paydb01) 9> alter XXXract XXXlc, XXXseqno 464 ,XXXrba 0 

XXXRACT altered.

GGSCI (paydb01) 10> start XXXlc

Sending START request to MANAGER ...

XXXRACT XXXLC starting

GGSCI (paydb01) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           

XXXRACT     RUNNING     XXX6C       00:00:00      00:00:03    

XXXRACT     RUNNING     XXXLC       00:00:00      00:00:14    

XXXRACT     RUNNING     XXX6C       00:00:00      00:00:05    

XXXRACT     RUNNING     XXXLC       00:00:01      00:00:00    

GGSCI (paydb01) 12> info XXXlc

XXXRACT    XXXLC     Last Started 2017-02-09 10:44   Status RUNNING

Checkpoint Lag       00:00:00 (updated 00:00:02 ago)

Log Read Checkpoint  File ./dirdat/lc000464

                     First Record  RBA 0