OracleGoldenGate学习之--GoldenGate的监控-MySQL 튜토리얼-php.cn

집

데이터 베이스

MySQL 튜토리얼

OracleGoldenGate学习之--GoldenGate的监控

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 02:53 PM

Oracle GoldenGate学习之--GoldenGate的监控 1、使用GGSCI命令监控（1）进入GoldenGate安装目录，运行GGSCI，然后使用info all查看整体的运行状况 GGSCI(aix212)1infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGEORA_100:0

Oracle GoldenGate学习之--GoldenGate的监控

1、使用GGSCI命令监控

（1）进入GoldenGate安装目录，运行GGSCI，然后使用info all查看整体的运行状况

GGSCI (aix212) 1> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING
EXTRACT     RUNNING     EORA_1      00:00:00      00:00:03
EXTRACT     RUNNING     PORA_1      00:00:00      00:00:00

GGSCI (aix211) 1> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING
REPLICAT    RUNNING     RORA_1      00:00:00      00:00:09

로그인 후 복사

Group表示进程的名称（MGR进程不显示名字）；

Lag表示进程的延时；Status表示进程的状态，有4种状态。

STARTING 表示正在启动过程中。

RUNNING 表示进程正常运行。

STOPPED 表示进程被正常关闭。

ABENDED 表示进程非正常关闭，需要进一步调查原因。

正常情况下，所有进程的状态应该为RUNNING，且Lag应该在一个合理的范围内。

（2）使用view params <进程名> 可以查看进程的参数设置，该命令支持通配符*

源端：
GGSCI (aix212) 4> view param mgr
dynamicportlist 7800-8000
autorestart extract *,waitminutes 2,resetminutes 5

GGSCI (aix212) 7> view param eini_1

EXTRACT EINI_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,PASSWORD ogg
RMTHOST 192.168.8.211,MGRPORT 7809
RMTTASK REPLICAT, GROUP RINI_1
TABLE scott.EMP_OGG;

GGSCI (aix212) 5> view param eora_1
EXTRACT EORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,PASSWORD ogg
EXTTRAIL ./dirdat/aa
TABLE scott.emp_ogg;

GGSCI (aix212) 6> view param pora_1
EXTRACT PORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
PASSTHRU
RMTHOST 192.168.8.211,MGRPORT 7809
RMTTRAIL ./dirdat/pa
TABLE scott.emp_ogg;

目标端：
GGSCI (aix211) 4> view param mgr
port 7809
dynamicportlist 7800-8000
autorestart extract *,waitminutes 2,resetminutes 5

GGSCI (aix211) 3> view param rini_1
REPLICAT RINI_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
ASSUMETARGETDEFS
USERID ogg,PASSWORD ogg
DISCARDFILE ./dirrpt/RINIaa.dsc,PURGE
MAP scott.emp_ogg, TARGET scott.emp_ogg;

GGSCI (aix211) 2> view param rora_1
REPLICAT RORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,PASSWORD ogg
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORA_aa.DSC,PURGE
MAP scott.oem_ogg, TARGET scott.emp_ogg;

로그인 후 복사

（3）使用info <进程名称> 命令可以查看进程信息，可以查看到的信息包括进程状态、checkpoint信息、延时等

GGSCI (aix212) 8> info eora_1
EXTRACT    EORA_1    Last Started 2014-09-25 16:09   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2014-09-25 17:00:16  Seqno 5, RBA 21645824
                     SCN 0.658565 (658565)
                     
GGSCI (aix212) 9> info pora_1
EXTRACT    PORA_1    Last Started 2014-09-25 16:09   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint  File ./dirdat/pa000000
                     First Record  RBA 0
                     
GGSCI (aix211) 5> info rora_1
REPLICAT   RORA_1    Last Started 2014-09-25 16:25   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint  File ./dirdat/pa000000
                     First Record  RBA 0

로그인 후 복사

（4）还可以使用info <进程名称> detail 命令查看更详细的信息，包括所使用的trail文件、参数文件、报告文件、警告日志的位置等

GGSCI (aix212) 10> info eora_1 detail
EXTRACT    EORA_1    Last Started 2014-09-25 16:09   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2014-09-25 17:01:58  Seqno 5, RBA 21770240
                     SCN 0.658666 (658666)
  Target Extract Trails:
  Remote Trail Name                                Seqno        RBA     Max MB
  ./dirdat/aa                                          2       2354          5
  Extract Source                          Begin             End
  /u01/app/oracle/oradata/orcl/redo01.log  2014-09-25 16:07  2014-09-25 17:01
  /u01/app/oracle/oradata/orcl/redo01.log  2014-09-23 20:34  2014-09-25 16:08
  /u01/app/oracle/oradata/orcl/redo03.log  2014-09-23 15:17  2014-09-23 20:35
  Not Available                           * Initialized *   2014-09-23 15:17
Current directory    /ogg
Report file          /ogg/dirrpt/EORA_1.rpt
Parameter file       /ogg/dirprm/eora_1.prm
Checkpoint file      /ogg/dirchk/EORA_1.cpe
Process file         /ogg/dirpcs/EORA_1.pce
Stdout file          /ogg/dirout/EORA_1.out
Error log            /ogg/ggserr.log

GGSCI (aix211) 6> info rora_1 detail
REPLICAT   RORA_1    Last Started 2014-09-25 16:25   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint  File ./dirdat/pa000000
                     First Record  RBA 0
  Extract Source                          Begin             End
  ./dirdat/pa000000                       * Initialized *   First Record
  ./dirdat/pa000000                       * Initialized *   First Record
Current directory    /ogg
Report file          /ogg/dirrpt/RORA_1.rpt
Parameter file       /ogg/dirprm/rora_1.prm
Checkpoint file      /ogg/dirchk/RORA_1.cpr
Checkpoint table     ogg.checkpoint
Process file         /ogg/dirpcs/RORA_1.pcr
Stdout file          /ogg/dirout/RORA_1.out
Error log            /ogg/ggserr.log

로그인 후 복사

（5）使用info <进程名称> showch 命令可以查看到详细的关于checkpoint的信息，用于查看GoldenGate进程处理过的事务记录

GGSCI (aix212) 11> info eora_1 showch
EXTRACT    EORA_1    Last Started 2014-09-25 16:09   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2014-09-25 17:04:50  Seqno 5, RBA 21797888
                     SCN 0.658739 (658739)
Current Checkpoint Detail:
Read Checkpoint #1
  Oracle Redo Log
  Startup Checkpoint (starting position in the data source):
    Thread #: 1
    Sequence #: 5
    RBA: 19244560
    Timestamp: 2014-09-25 16:07:15.000000
    SCN: 0.656759 (656759)
    Redo File: /u01/app/oracle/oradata/orcl/redo01.log
  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 1
    Sequence #: 5
    RBA: 21795856
    Timestamp: 2014-09-25 17:04:43.000000
    SCN: 0.658736 (658736)
    Redo File: /u01/app/oracle/oradata/orcl/redo01.log
  Current Checkpoint (position of last record read in the data source):
    Thread #: 1
    Sequence #: 5
    RBA: 21797888
    Timestamp: 2014-09-25 17:04:50.000000
    SCN: 0.658739 (658739)
    Redo File: /u01/app/oracle/oradata/orcl/redo01.log
  BR Previous Recovery Checkpoint:
    Thread #: 0
    Sequence #: 0
    RBA: 0
    Timestamp: 2014-09-23 15:22:40.485502
    SCN: Not available
    Redo File:
  BR Begin Recovery Checkpoint:
    Thread #: 1
    Sequence #: 4
    RBA: 10054144
    Timestamp: 2014-09-23 19:22:47.000000
    SCN: 0.629912 (629912)
    Redo File:
  BR End Recovery Checkpoint:
    Thread #: 1
    Sequence #: 4
    RBA: 10054144
    Timestamp: 2014-09-23 19:22:47.000000
    SCN: 0.629912 (629912)
    Redo File:
Write Checkpoint #1
  GGS Log Trail
  Current Checkpoint (current write position):
    Sequence #: 2
    RBA: 2354
    Timestamp: 2014-09-25 17:04:54.617925
    Extract Trail: ./dirdat/aa
CSN state information:
  CRC: B9-8B-16-BD
  Latest CSN: 658581
  Latest TXN: 3.47.317
  Latest CSN of finished TXNs: 658581
  Completed TXNs: 3.47.317
Header:
  Version = 2
  Record Source = A
  Type = 10
  # Input Checkpoints = 1
  # Output Checkpoints = 1
File Information:
  Block Size = 2048
  Max Blocks = 100
  Record Length = 2048
  Current Offset = 0
Configuration:
  Data Source = 3
  Transaction Integrity = 1
  Task Type = 0
Status:
  Start Time = 2014-09-25 16:09:02
  Last Update Time = 2014-09-25 17:04:54
  Stop Status = A
  Last Result = 400

로그인 후 복사

其中比较重要的是Extract进程的recovery checkpoint，它表示源数据中最早的未被处理的事务；通过recovery checkpoint可以查看到该事务的redo log位于哪个日志文件以及该日志文件的序列号。

所有序列号比它大的日志文件，均需要保留。

（6）lag <进程名称> 可以查看详细的延时信息

GGSCI (aix212) 12> lag eora_1
Sending GETLAG request to EXTRACT EORA_1 ...
Last record lag: 2 seconds.
At EOF, no more records to process.

로그인 후 복사

（7）stats可以查看进程处理的记录数：

该报告会详细地列出处理的类型和记录数，例如：

stats <进程名称>,<时间频度>,table .

GGSCI (aix212) 13> stats eora_1, total
Sending STATS request to EXTRACT EORA_1 ...
Start of Statistics at 2014-09-25 17:08:54.
Output to ./dirdat/aa:
Extracting from SCOTT.EMP_OGG to SCOTT.EMP_OGG:
*** Total statistics since 2014-09-25 16:11:23 ***
        Total inserts                                      3.00
        Total updates                                      0.00
        Total deletes                                      6.00
        Total discards                                     0.00
        Total operations                                   9.00
End of Statistics.

로그인 후 복사

列出自进程启动以来处理的所有记录数，如图11-8所示。

GGSCI (aix212) 15> stats eora_1,daily, table scott.emp_ogg
Sending STATS request to EXTRACT EORA_1 ...
Start of Statistics at 2014-09-25 17:11:16.
Output to ./dirdat/aa:
Extracting from SCOTT.EMP_OGG to SCOTT.EMP_OGG:
*** Daily statistics since 2014-09-25 16:11:23 ***
        Total inserts                                      3.00
        Total updates                                      0.00
        Total deletes                                      6.00
        Total discards                                     0.00
        Total operations                                   9.00
End of Statistics.

로그인 후 복사

列出当天以来处理的有关scott.emp_ogg表的所有记录数。

（8）view report <进程名称> 可以查看运行报告

GGSCI (aix212) 16> view report eora_1
***********************************************************************
                 Oracle GoldenGate Capture for Oracle
      Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
  AIX 5L, ppc, 64bit (optimized), Oracle 10.2 on Apr 23 2012 07:57:02
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
                    Starting at 2014-09-25 16:09:01
***********************************************************************
Operating System Version:
AIX
Version 5, Release 3
Node: aix212
Machine: 0009746A4C00
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited
Process id: 229538
Description:
***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
2014-09-25 16:09:01  INFO    OGG-03035  Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
EXTRACT EORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,PASSWORD ***
EXTTRAIL ./dirdat/aa
TABLE scott.emp_ogg;
2014-09-25 16:09:01  INFO    OGG-01815  Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/BR/EORA_1.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR      = /ogg
2014-09-25 16:09:02  INFO    OGG-01815  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE:                               64G
CACHEPAGEOUTSIZE (normal):                8M
PROCESS VM AVAIL FROM OS (min):         128G
CACHESIZEMAX (strict force to disk):     96G
2014-09-25 16:09:02  INFO    OGG-01639  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p536622_extr.
2014-09-25 16:09:02  INFO    OGG-01640  BOUNDED RECOVERY: recovery start XID: 0.0.0.
2014-09-25 16:09:02  INFO    OGG-01641  BOUNDED RECOVERY: recovery start position: SeqNo: 4, RBA: 10053648, SCN: 0.629912 (629912), Timestamp: 201
4-09-23 19:22:47.000000, Thread: 1.
2014-09-25 16:09:02  INFO    OGG-01642  BOUNDED RECOVERY: recovery end position: SeqNo: 4, RBA: 10054144, SCN: 0.629912 (629912), Timestamp: 2014-
09-23 19:22:47.000000, Thread: 1.
2014-09-25 16:09:02  INFO    OGG-01643  BOUNDED RECOVERY: CANCELED: for object pool 1: p536622_extr.
2014-09-25 16:09:02  INFO    OGG-01579  BOUNDED RECOVERY: VALID BCP: CP.EORA_1.000000001.
2014-09-25 16:09:02  INFO    OGG-01629  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <<NONE TO RECOVER>>.
Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Productio
NLSRTL Version 10.2.0.1.0 - Production
Database Language and Character Set:
NLS_LANG         = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE     = "AMERICAN"
NLS_TERRITORY    = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
2014-09-25 16:09:02  INFO    OGG-01513  Positioning to Sequence 5, RBA 19244560, SCN 0.656759.
2014-09-25 16:09:02  INFO    OGG-01516  Positioned to Sequence 5, RBA 19244560, SCN 0.656759, Sep 25, 2014 3:07:15 PM.
2014-09-25 16:09:02  INFO    OGG-01055  Recovery initialization completed for target file ./dirdat/aa000001, at RBA 1007.
2014-09-25 16:09:02  INFO    OGG-01478  Output file ./dirdat/aa is using format RELEASE 11.2.
2014-09-25 16:09:02  INFO    OGG-01026  Rolling over remote file ./dirdat/aa000001.
2014-09-25 16:09:02  INFO    OGG-01053  Recovery completed for target file ./dirdat/aa000002, at RBA 1007.
2014-09-25 16:09:02  INFO    OGG-01057  Recovery completed for all targets.
***********************************************************************
**                     Run Time Messages                             **
***********************************************************************
2014-09-25 16:09:02  INFO    OGG-01517  Position of first record processed Sequence 5, RBA 19244560, SCN 0.656759, Sep 25, 2014 3:07:15 PM.
TABLE resolved (entry scott.emp_ogg):
  TABLE "SCOTT"."EMP_OGG";
Using the following key columns for source table SCOTT.EMP_OGG: EMPNO.
2014-09-25 17:07:03  INFO    OGG-01021  Command received from GGSCI: GETLAG.
2014-09-25 17:08:54  INFO    OGG-01021  Command received from GGSCI: STATS   total.
2014-09-25 17:10:43  INFO    OGG-01021  Command received from GGSCI: STATS  daily,scott.emp_ogg.
2014-09-25 17:11:16  INFO    OGG-01021  Command received from GGSCI: STATS  daily, table scott.emp_ogg.

로그인 후 복사

（9）也可以进入到 /dirrpt/目录下，查看对应的报告文件。

最新的报告总是以<进程名称>.rpt命名的。加后缀数字的报告是历史报告，数字越大对应的时间越久

[oracle@aix212@ ogg]$cd dirrpt
[oracle@aix212@ dirrpt]$ls -lt
total 248
-rw-rw-rw-    1 oracle   oinstall       4962 Sep 25 17:11 EORA_1.rpt
-rw-rw-rw-    1 oracle   oinstall       3124 Sep 25 16:32 EINI_1.rpt
-rw-rw-rw-    1 oracle   oinstall       2252 Sep 25 16:32 MGR.rpt
-rw-rw-rw-    1 oracle   oinstall       3124 Sep 25 16:27 EINI_10.rpt
-rw-rw-rw-    1 oracle   oinstall       3124 Sep 25 16:09 EINI_11.rpt
-rw-rw-rw-    1 oracle   oinstall       2377 Sep 25 16:09 PORA_1.rpt
-rw-rw-rw-    1 oracle   oinstall       3124 Sep 25 16:08 EINI_12.rpt
-rw-rw-rw-    1 oracle   oinstall       1897 Sep 25 16:08 MGR0.rpt
-rw-rw-rw-    1 oracle   oinstall      20631 Sep 25 16:08 EORA_10.rpt
-rw-rw-rw-    1 oracle   oinstall      11416 Sep 25 16:07 PORA_10.rpt
-rw-rw-rw-    1 oracle   oinstall       3124 Sep 25 15:35 EINI_13.rpt
-rw-rw-rw-    1 oracle   oinstall       3899 Sep 23 19:22 EORA_11.rpt
-rw-rw-rw-    1 oracle   oinstall       3124 Sep 23 16:27 EINI_14.rpt
-rw-rw-rw-    1 oracle   oinstall       3078 Sep 23 16:27 MGR1.rpt
-rw-rw-rw-    1 oracle   oinstall       3124 Sep 23 16:24 EINI_15.rpt
-rw-rw-rw-    1 oracle   oinstall       3124 Sep 23 16:23 EINI_16.rpt
-rw-rw-rw-    1 oracle   oinstall       3031 Sep 23 16:20 EINI_17.rpt
-rw-rw-rw-    1 oracle   oinstall       3031 Sep 23 16:18 EINI_18.rpt
-rw-rw-rw-    1 oracle   oinstall       3031 Sep 23 16:13 EINI_19.rpt
-rw-rw-rw-    1 oracle   oinstall       1897 Sep 23 15:49 MGR2.rpt
-rw-rw-rw-    1 oracle   oinstall       2377 Sep 23 15:25 PORA_11.rpt
-rw-rw-rw-    1 oracle   oinstall       1372 Sep 23 15:15 MGR3.rpt
-rw-rw-rw-    1 oracle   oinstall       1547 Sep 23 15:09 MGR4.rpt

로그인 후 복사

[oracle@aix212@ dirrpt]$cat EORA_1.rpt

***********************************************************************
                 Oracle GoldenGate Capture for Oracle
      Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
  AIX 5L, ppc, 64bit (optimized), Oracle 10.2 on Apr 23 2012 07:57:02
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
                    Starting at 2014-09-25 16:09:01
***********************************************************************
Operating System Version:
AIX
Version 5, Release 3
Node: aix212
Machine: 0009746A4C00
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited
Process id: 229538
Description:
***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
2014-09-25 16:09:01  INFO    OGG-03035  Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
EXTRACT EORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,PASSWORD ***
EXTTRAIL ./dirdat/aa
TABLE scott.emp_ogg;
2014-09-25 16:09:01  INFO    OGG-01815  Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/BR/EORA_1.
......

로그인 후 복사

如果进程运行时有错误，则报告文件中会包括错误代码和详细的错误诊断信息。通过查找错误代码，可以帮助定位错误原因，解决问题。

2、ggserr.log日志监控

（1）可以用以下方法查看日志文件。

可以通过操作系统命令直接查看ggserr.log文件。

使用GoldenGate Director。

在GGSCI中运行命令view ggsevt。

（2）在日志文件中可以查看到的内容如下。

GGSCI命令的历史记录。

GoldenGate进程的启动与停止。

已执行的处理。

发生的错误。

信息和警告消息。

（3）日志文件的部分内容

GGSCI (aix212) 1> view ggsevt
2014-09-23 15:02:08  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit param mg.
2014-09-23 15:02:16  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit param mgr.
2014-09-23 15:04:37  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit param mgr.
2014-09-23 15:04:57  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
2014-09-23 15:04:58  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2014-09-23 15:06:09  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): add extract eini_1 sourceistable
......

로그인 후 복사

案例分析1：

目标端replicat进程启动异常

GGSCI (aix211) 16> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                            
REPLICAT    ABENDED     RORA_1      00:00:00      43:38:02

로그인 후 복사

查看日志：

日志1：

2014-09-25 16:03:42  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/dirtmp.
2014-09-25 16:03:42  ERROR   OGG-00446  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  Checkpoint table ogg.checkpoint does not exist.  Pleas
e create the table or recreate the RORA_1 group using the correct table.
2014-09-25 16:03:42  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  PROCESS ABENDING.

로그인 후 복사

无法找到checkpint table ！

GGSCI (aix211) 2> delete checkpointtable

GGSCI (aix211) 3> edit param ./GLOBALS
CHECKPOINTTABLE ogg.checkpoint

GGSCI (aix211) 3>exit
必须退出ggsci，checkpoint table 才会生效

[oracle@rh6 ogg]$ ./ggsci
GGSCI (aix211) 1> dblogin userid ogg,password ogg
Successfully logged into database.
  
GGSCI (aix211) 2> add checkpointtable
No checkpoint table specified, using GLOBALS specification (ogg.checkpoint)...
Successfully created checkpoint table ogg.checkpoint.

로그인 후 복사

重新启动replicat进程：

GGSCI (aix211) 16> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                            
REPLICAT    ABENDED     RORA_1      00:00:00      43:38:02

로그인 후 복사

启动失败，查看日志！

日志2：

[oracle@aix211 ogg]$tail ggserr.log 
2014-09-25 16:11:47  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT RORA_1 starting.
2014-09-25 16:11:48  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  REPLICAT RORA_1 starting.
2014-09-25 16:11:48  INFO    OGG-03035  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
2014-09-25 16:11:48  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/dirtmp.
2014-09-25 16:11:48  ERROR   OGG-00446  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  No data selecting position from checkpoint table ogg.checkpoint for group 'RORA_1', key 1056363220 (0x3ef6d2d4), SQL <SELECT a.current_dir, a.seqno, a.rba, a.audit_ts, a.log_csn, a.log_xid, a.log_cmplt_csn, a.log_cmplt_xids, b.log_cmplt_xids FROM ogg.checkpoint a LEFT JOIN ogg.checkpoint_lox b ON a.group_name = b.group_name AND a.group_key = b.group_key AND a.log_cmplt_csn = b.log_cmplt_csn WHERE a.group_name = 'RORA_1' AND a.group_key  = 1056363220>.
2014-09-25 16:11:48  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  PROCESS ABENDING.

로그인 후 복사

checkpointtable 错误！

处理方法：

删除replicat进程：
GGSCI (aix211) 7> delete replicat rora_1
Deleted REPLICAT RORA_1.

添加新的replicat进程：
GGSCI (aix211) 8> add replicat rora_1,exttrail ./dirdat/pa,checkpointtable ogg.checkpoint
REPLICAT added.

GGSCI (aix211) 9> edit param rora_1
"/ogg/dirprm/rora_1.prm" 7 lines, 198 characters 
REPLICAT RORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,PASSWORD ogg
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORA_aa.DSC,PURGE
MAP scott.oem_ogg, TARGET scott.emp_ogg;
~

重新启动replicat进程
GGSCI (aix211) 10> start replicat rora_1
Sending START request to MANAGER ...
REPLICAT RORA_1 starting
GGSCI (aix211) 11> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                             
REPLICAT    RUNNING     RORA_1      00:00:00      00:00:03
启动成功！

로그인 후 복사

查看ogg日志：

GGSCI (aix211) 12> view ggsevt

2014-09-25 16:25:13  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT RORA_1 starting.
2014-09-25 16:25:13  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  REPLICAT RORA_1 starting.
2014-09-25 16:25:13  INFO    OGG-03035  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  Operating system characte
r set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
2014-09-25 16:25:13  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  Virtual Memory Facilities
 for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/dirtmp.
2014-09-25 16:25:13  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rora_1.prm:  REPLICAT RORA_1 started.

로그인 후 복사

案例分析2：

源端初始化进程（eini_1)和目标端初始化进程（rini_1)

目标端初始化进程rini_1：

GGSCI (aix211) 13> info rini_1
REPLICAT   RINI_1    Initialized   2014-09-23 15:40   Status STOPPED
Checkpoint Lag       00:00:00 (updated 48:46:37 ago)
Log Read Checkpoint  Not Available
Task                 SPECIALRUN

로그인 후 복사

源端初始化进程eini_1：

GGSCI (aix212) 21> info eini_1
EXTRACT    EINI_1    Last Started 2014-09-25 16:09   Status STOPPED
Checkpoint Lag       Not Available
Log Read Checkpoint  Table SCOTT.EMP_OGG
                     2014-09-25 16:09:35  Record 14
Task                 SOURCEISTABLE

로그인 후 복사

启动源端初始化进程：

GGSCI (aix212) 22> start eini_1
Sending START request to MANAGER ...
EXTRACT EINI_1 starting

GGSCI (aix212) 23> info eini_1
EXTRACT    EINI_1    Last Started 2014-09-25 16:09   Status RUNNING
Checkpoint Lag       Not Available
Log Read Checkpoint  Table SCOTT.EMP_OGG
                     2014-09-25 16:09:35  Record 14
Task                 SOURCEISTAB

로그인 후 복사

进程启动后，目标端初始化进程自动启动！

GGSCI (aix211) 14> info rini_1
REPLICAT   RINI_1    Initialized   2014-09-23 15:40   Status RUNNING
Checkpoint Lag       00:00:00 (updated 48:47:03 ago)
Log Read Checkpoint  Not Available
Task                 SPECIALRUN

로그인 후 복사

본 웹사이트의 성명

본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.

핫 AI 도구

Undresser.AI Undress

사실적인 누드 사진을 만들기 위한 AI 기반 앱

AI Clothes Remover

사진에서 옷을 제거하는 온라인 AI 도구입니다.

Undress AI Tool

무료로 이미지를 벗다

Clothoff.io

AI 옷 제거제

AI Hentai Generator

AI Hentai를 무료로 생성하십시오.

뜨거운 도구

메모장++7.3.1

사용하기 쉬운 무료 코드 편집기

SublimeText3 중국어 버전

중국어 버전, 사용하기 매우 쉽습니다.

스튜디오 13.0.1 보내기

강력한 PHP 통합 개발 환경

드림위버 CS6

시각적 웹 개발 도구

SublimeText3 Mac 버전

신 수준의 코드 편집 소프트웨어(SublimeText3)

뜨거운 주제

Gmail 이메일의 로그인 입구는 어디에 있나요?

7478

Cakephp 튜토리얼

1377

Steam의 계정 이름 형식은 무엇입니까?

Win11 활성화 키 영구

NYT 연결 힌트와 답변

Related knowledge

Alter Table 문을 사용하여 MySQL에서 테이블을 어떻게 변경합니까? Mar 19, 2025 pm 03:51 PM

이 기사는 MySQL의 Alter Table 문을 사용하여 열 추가/드롭 테이블/열 변경 및 열 데이터 유형 변경을 포함하여 테이블을 수정하는 것에 대해 설명합니다.

MySQL 연결에 대한 SSL/TLS 암호화를 어떻게 구성합니까? Mar 18, 2025 pm 12:01 PM

기사는 인증서 생성 및 확인을 포함하여 MySQL에 대한 SSL/TLS 암호화 구성에 대해 설명합니다. 주요 문제는 자체 서명 인증서의 보안 영향을 사용하는 것입니다. [문자 수 : 159]

InnoDB 전체 텍스트 검색 기능을 설명하십시오. Apr 02, 2025 pm 06:09 PM

InnoDB의 전체 텍스트 검색 기능은 매우 강력하여 데이터베이스 쿼리 효율성과 대량의 텍스트 데이터를 처리 할 수있는 능력을 크게 향상시킬 수 있습니다. 1) InnoDB는 기본 및 고급 검색 쿼리를 지원하는 역 색인화를 통해 전체 텍스트 검색을 구현합니다. 2) 매치 및 키워드를 사용하여 검색, 부울 모드 및 문구 검색을 지원합니다. 3) 최적화 방법에는 워드 세분화 기술 사용, 인덱스의 주기적 재건 및 캐시 크기 조정, 성능과 정확도를 향상시키는 것이 포함됩니다.