OGG-02091解决以及ggsci常用命令

一.背景

测试11g单实例到19c某个pdb的单向ogg同步，搭建完成之后19c这边复制进程无法启动。
很简单的一个错误，主要是复习一下ogg的命令，好久不用了，最近有个项目迁移要用，先测试复习一下。

二.详细过程

2.1.目标端11g进程状态

GGSCI (single) 21> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     RUNNING     DPE1        00:00:00      00:00:03    
EXTRACT     RUNNING     EXTU1       00:00:00      00:00:04    
GGSCI (single) 22>

可以看到源端状态都是running

2.2.查看目标端19c的进程状态

GGSCI (single19) 11> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    STOPPED     REP1        00:00:00      22:35:02    
GGSCI (single19) 12> 

尝试启动复制进程

--同步数据之后第一次启动
start REP1, aftercsn 2555825
GGSCI (single19) 3> start REP1, aftercsn 2555825
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (single19) 4>
--状态还是不变
GGSCI (single19) 2> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    STOPPED     REP1        00:00:00      22:29:43    
GGSCI (single19) 3>

2.3.检查复制进程的配置

view params 进程名

GGSCI (single19) 10> view params rep1

REPLICAT rep1
setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
--setenv (ORACLE_SID=)
userid ogg@pdb1, password ogg
REPORT AT 08:59
REPORTCOUNT EVERY 30 MINUTES, RATE
CACHEMGR CACHESIZE 2048MB, CACHEDIRECTORY /home/oracle/ogg/dirtmp
REPERROR DEFAULT, ABEND
DISCARDFILE /home/oracle/ogg/dirrpt/rep1.dsc, APPEND, MEGABYTES 1024
DISCARDROLLOVER AT 3:00
GETTRUNCATES
ALLOWNOOPUPDATES
APPLYNOOPUPDATES
ASSUMETARGETDEFS
DBOPTIONS DEFERREFCONST
DBOPTIONS SUPPRESSTRIGGERS
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DDLERROR 942 IGNORE
MAP test1.* TARGET test1.*;
MAP test2.* TARGET test2.*;
MAP test3.* TARGET test3.*;
GGSCI (single19) 11>

2.4.查看进程信息

命令：
info 进程名
info 进程名 detail

GGSCI (single19) 12> info rep1

REPLICAT   REP1      Initialized   2024-10-22 14:18   Status STOPPED
Checkpoint Lag       00:00:00 (updated 22:35:07 ago)
Log Read Checkpoint  File /home/oracle/ogg/dirdat/ss000000000
                     First Record  RBA 0
GGSCI (single19) 13>
GGSCI (single19) 15> info rep1 detail

REPLICAT   REP1      Initialized   2024-10-22 14:18   Status STOPPED
Checkpoint Lag       00:00:00 (updated 22:36:41 ago)
Log Read Checkpoint  File /home/oracle/ogg/dirdat/ss000000000
                     First Record  RBA 0
Current Log BSN value: (requires database login)
Last Committed Transaction CSN value: (requires database login)
  Extract Source                          Begin             End             
  /home/oracle/ogg/dirdat/ss000000000     * Initialized *   First Record    
Current directory    /home/oracle

Report file          /home/oracle/ogg/dirrpt/REP1.rpt
Parameter file       /home/oracle/ogg/dirprm/rep1.prm
Checkpoint file      /home/oracle/ogg/dirchk/REP1.cpr
Checkpoint table     ogg.rep1_ckpt
Process file         
Error log            /home/oracle/ogg/ggserr.log
GGSCI (single19) 16>

看到有个错误日志 /home/oracle/ogg/ggserr.log
查看这个错误日志看到如下信息

2024-10-22T15:25:47.616+0800  ERROR   OGG-02091  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Operation not supported because enable_goldengate_replication is not set to true.
2024-10-22T15:25:47.616+0800  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rep1.prm:  PROCESS ABENDING.
2024-10-22T15:25:54.376+0800  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.

看到这个就知道问题在哪里了，只打开了源端11g的ogg参数，没有打开目标端的ogg参数。

2.5.启动进程

show parameter enable_goldengate_replication
alter system set enable_goldengate_replication=true scope=both sid='*';
show parameter enable_goldengate_replication

GGSCI (single19) 17> start REP1, aftercsn 2555825
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (single19) 18> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP1        00:00:00      00:00:00    
GGSCI (single19) 19>

三.总结ggsci命令

对goldengate最简单的监控方式就是通过ggsci，可以查看进程状态、检查点信息、参数文件配置等信息。

3.1.进入ggsci

ggsci

[oracle@single ~]$ cd $OGG_HOME
[oracle@single ogg]$ ./ggsci 
Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Oct 17 2019 23:13:12
Operating system character set identified as GBK.
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
GGSCI (single) 1>

3.2.查看运行状态

info all

GGSCI (single) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     RUNNING     DPE1        00:00:00      00:00:03    
EXTRACT     RUNNING     EXTU1       00:00:00      00:00:07    
GGSCI (single) 2>

GGSCI (single19) 2> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP1        00:00:00      00:00:07    
GGSCI (single19) 3>

info 进程名 可以查看进程信息

GGSCI (single) 2> info dpe1

EXTRACT    DPE1      Last Started 2024-10-23 12:49   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:00 ago)
Process ID           80569
Log Read Checkpoint  File /home/oracle/ogg/dirdat/ss000000000
                     2024-10-23 13:03:12.000000  RBA 41319
GGSCI (single) 3> info extu1

EXTRACT    EXTU1     Last Started 2024-10-22 12:55   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Process ID           64333
Log Read Checkpoint  Oracle Redo Logs
                     2024-10-23 13:43:43  Seqno 9, RBA 279552
                     SCN 0.2563861 (2563861)
GGSCI (single) 4>
GGSCI (single19) 3> info rep1

REPLICAT   REP1      Last Started 2024-10-23 13:00   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:07 ago)
Process ID           30027
Log Read Checkpoint  File /home/oracle/ogg/dirdat/ss000000001
                     2024-10-23 13:03:12.080343  RBA 2174
GGSCI (single19) 4> 

info 进程名 detail 可以查看更详细的进程信息

GGSCI (single) 4> info dpe1 detail
EXTRACT    DPE1      Last Started 2024-10-23 12:49   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Process ID           80569
Log Read Checkpoint  File /home/oracle/ogg/dirdat/ss000000000
                     2024-10-23 13:03:12.000000  RBA 41319
  Target Extract Trails:
  Trail Name                                       Seqno        RBA     Max MB Trail Type
  /home/oracle/ogg/dirdat/ss                           1       2174       1024 RMTTRAIL  
  Extract Source                          Begin             End             
  /home/oracle/ogg/dirdat/ss000000000     2024-10-22 15:24  2024-10-23 13:03
  /home/oracle/ogg/dirdat/ss000000000     2024-10-22 15:24  2024-10-22 15:24
  /home/oracle/ogg/dirdat/ss000000000     2024-10-22 15:24  2024-10-22 15:24
  /home/oracle/ogg/dirdat/ss000000000     2024-10-22 15:24  2024-10-22 15:24
  /home/oracle/ogg/dirdat/ss000000000     * Initialized *   2024-10-22 15:24
  /home/oracle/ogg/dirdat/ss000000000     * Initialized *   First Record    
  /home/oracle/ogg/dirdat/ss000000000     * Initialized *   First Record    
  /home/oracle/ogg/dirdat/ss000000000     * Initialized *   First Record    
  /home/oracle/ogg/dirdat/ss000000000     * Initialized *   First Record    
  /home/oracle/ogg/dirdat/ss000000000     * Initialized *   First Record    
Current directory    /home/oracle/ogg
Report file          /home/oracle/ogg/dirrpt/DPE1.rpt
Parameter file       /home/oracle/ogg/dirprm/dpe1.prm
Checkpoint file      /home/oracle/ogg/dirchk/DPE1.cpe
Process file         
Error log            /home/oracle/ogg/ggserr.log
GGSCI (single) 5>

3.3.查看进程参数设置

view params 进程名

GGSCI (single19) 5> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP1        00:00:00      00:00:07    
GGSCI (single19) 6> view params REP1
REPLICAT rep1
setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
userid ogg@pdb1, password ogg
REPORT AT 08:59
REPORTCOUNT EVERY 30 MINUTES, RATE
CACHEMGR CACHESIZE 2048MB, CACHEDIRECTORY /home/oracle/ogg/dirtmp
REPERROR DEFAULT, ABEND
DISCARDFILE /home/oracle/ogg/dirrpt/rep1.dsc, APPEND, MEGABYTES 1024
DISCARDROLLOVER AT 3:00
GETTRUNCATES
ALLOWNOOPUPDATES
APPLYNOOPUPDATES
ASSUMETARGETDEFS
DBOPTIONS DEFERREFCONST
DBOPTIONS SUPPRESSTRIGGERS
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DDLERROR 942 IGNORE
MAP test1.* TARGET test1.*;
MAP test2.* TARGET test2.*;
MAP test3.* TARGET test3.*;
GGSCI (single19) 7>

3.4.进程报告

view report 进程名 查看运行报告

GGSCI (single19) 9> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP1        00:00:00      00:00:05    
GGSCI (single19) 10> view report rep1
***********************************************************************
                 Oracle GoldenGate Delivery for Oracle
    Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
   Linux, x64, 64bit (optimized), Oracle 11g on Oct 17 2019 23:13:43
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.

也可以到ogg安装目录的dirrpt目录下直接查看报告，进程名.rpt是最新的报告，加后缀的都是之前的，后缀数字越大越旧。

3.5.ggserr.log

ogg安装目录有ggserr.log日志。
可以直接查看，也可以在ggsci界面查看。 view ggsevt

GGSCI (single19) 30> view ggsevt
2024-10-22T14:14:23.427+0800  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command 
(oracle): dblogin userid ogg@TESTOGG password ***.

四.更多goldengate知识

19c-文档
goldengate其他产品：
1.Oracle GoldenGate Product Family
2.Oracle GoldenGate Veridata :
GoldenGate Veridata 将一组数据与另一组数据进行比较，识别不同步的数据，并允许修复发现的任何不同步数据
3.Oracle GoldenGate Plug-in for EMCC:
适用于 Oracle GoldenGate 的 Enterprise Manager 插件
4.Oracle GoldenGate Monitor:
Oracle GoldenGate Monitor 是一个基于 Web 的实时监视控制台
5.Oracle GoldenGate for Big Data:
适用于大数据的 Oracle GoldenGate 包含内置支持，可将 Oracle GoldenGate 跟踪记录中的操作数据写入各种大数据目标（例如 HDFS、HBase、Kafka、Flume、JDBC、Cassandra 和 MongoDB）
6.Oracle GoldenGate Application Adapters:
Oracle GoldenGate Application Adapters 与 Oracle GoldenGate核心产品的安装集成，以引入 Java 消息服务 （JMS） 信息或以 JMS 消息或文件的形式提供信息
7.Oracle GoldenGate for HP NonStop (Guardian):
8.Oracle GoldenGate Studio:
Oracle GoldenGate Studio 支持通过自动处理表和列映射、允许拖放自定义映射、从模板生成优秀实践配置以及包含上下文相关帮助来设计和部署大容量实时复制。