Oracle goldengate服务未启动:无法检索缺少的Oracle重做日志的名称

Question

我试图启动GG服务，当尝试‘启动my_service’然后启动，但它没有启动，状态总是改变开始停止。我需要开始金牌服务..。我不知道它的服务发生了什么，该做什么来解决这个问题。帮我，伙计们

我的服务名称是: MY_SERVICE

以下是日志：

 2020-02-17 14:52:37  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start MY_SERVICE.
2020-02-17 14:52:37  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [192.168.1.100 ]:37022 (START EXTRACT MY_SERVICE ).
2020-02-17 14:52:37  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #6).
2020-02-17 14:52:37  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT MY_SERVICE starting.
2020-02-17 14:52:37  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  EXTRACT MY_SERVICE starting.
2020-02-17 14:52:37  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Operating system character set identified as UTF-8.
2020-02-17 14:52:37  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  ANSI SQL parameter syntax is used for parameter parsing.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable ORACLE_SID=MYSNAME.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable ORACLE_SID=MYSNAME.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1.
2020-02-17 14:52:38  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Setting session time zone to source database time zone 'GMT'.
2020-02-17 14:52:38  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /u01/ogg/BR/MY_SERVICE.
2020-02-17 14:52:38  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  filecaching started: thread ID: 140383342216960.
2020-02-17 14:52:38  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /u01/ogg/dirtmp.
2020-02-17 14:52:38  INFO    OGG-01639  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p49266_extr.
2020-02-17 14:52:38  INFO    OGG-01640  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: recovery start XID: 0.0.0.
2020-02-17 14:52:38  INFO    OGG-01641  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: recovery start position: SeqNo: 11932, RBA: 25311476, SCN: 1.353105371 (4648072667), Timestamp: 2019-12-30 16:06:40.000000, Thread: 2.
2020-02-17 14:52:38  INFO    OGG-01642  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: recovery end position: SeqNo: 11932, RBA: 25311476, SCN: 1.353105371 (4648072667), Timestamp: 2019-12-30 16:06:40.000000, Thread: 2.
2020-02-17 14:52:38  INFO    OGG-01643  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: CANCELED: for object pool 1: p49266_extr.
2020-02-17 14:52:38  INFO    OGG-01579  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: VALID BCP: CP.MY_SERVICE.000002823.
2020-02-17 14:52:38  INFO    OGG-01629  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <<NONE TO RECOVER>>.
2020-02-17 14:52:40  WARNING OGG-02045  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Database does not have streams_pool_size initialization parameter configured.
2020-02-17 14:52:40  INFO    OGG-02248  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Logmining server DDL filtering enabled.
2020-02-17 14:54:47  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2020-02-17 14:55:41  ERROR   OGG-02037  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Failed to retrieve the name of a missing Oracle redo log.
2020-02-17 14:55:41  ERROR   OGG-00662  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  OCI Error retrieving bind info for query (status = 100).
2020-02-17 14:55:41  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  PROCESS ABENDING.

Answer 1

您的解压缩过程正在查找六周前(2019-12-30年)存档的重做日志文件，而这些日志文件已不再可用。

如果您必须让解压缩从它停止的位置拾取，则需要从序列11932开始恢复丢失的归档日志，然后重新启动解压缩。

如果您不需要提取过去六周的事务，您就可以删除该摘录，然后再添加它。

还有一个中间点，您可以将摘录重新定位到数据库管理系统所知道的最古老的归档日志中，然后启动提取。