OracleGoldenGate学习之--GoldenGate的监控
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 列出自进程启动以来处理的所有记录数，如图11-8所示。 列出当天以来处理的有关scott.emp_ogg表的所有记录数。 （8）view report <进程名称> 可以查看运行报告 （9）也可以进入到 最新的报告总是以<进程名称>.rpt命名的。加后缀数字的报告是历史报告，数字越大对应的时间越久 [oracle@aix212@ dirrpt]$cat EORA_1.rpt 如果进程运行时有错误，则报告文件中会包括错误代码和详细的错误诊断信息。通过查找错误代码，可以帮助定位错误原因，解决问题。 2、ggserr.log日志监控 （1）可以用以下方法查看日志文件。 可以通过操作系统命令直接查看ggserr.log文件。 使用GoldenGate Director。 在GGSCI中运行命令view ggsevt。 （2）在日志文件中可以查看到的内容如下。 GGSCI命令的历史记录。 GoldenGate进程的启动与停止。 已执行的处理。 发生的错误。 信息和警告消息。 （3）日志文件的部分内容 案例分析1： 目标端replicat进程启动异常 查看日志： 日志1： 无法找到checkpint table ！ 重新启动replicat进程： 启动失败，查看日志！ 日志2： checkpointtable 错误 ！ 处理方法： 查看ogg日志： GGSCI (aix211) 12> view ggsevt 案例分析2： 源端初始化进程（eini_1)和目标端初始化进程（rini_1) 目标端初始化进程rini_1： 源端初始化进程eini_1： 启动源端初始化进程： 进程启动后，目标端初始化进程自动启动！ Application basée sur l'IA pour créer des photos de nu réalistes Outil d'IA en ligne pour supprimer les vêtements des photos. Images de déshabillage gratuites Dissolvant de vêtements AI Générez AI Hentai gratuitement. Éditeur de code facile à utiliser et gratuit Version chinoise, très simple à utiliser Puissant environnement de développement intégré PHP Outils de développement Web visuel Logiciel d'édition de code au niveau de Dieu (SublimeText3) L'article discute de l'utilisation de l'instruction ALTER TABLE de MySQL pour modifier les tables, notamment en ajoutant / abandon les colonnes, en renommant des tables / colonnes et en modifiant les types de données de colonne. Les capacités de recherche en texte intégral d'InNODB sont très puissantes, ce qui peut considérablement améliorer l'efficacité de la requête de la base de données et la capacité de traiter de grandes quantités de données de texte. 1) INNODB implémente la recherche de texte intégral via l'indexation inversée, prenant en charge les requêtes de recherche de base et avancées. 2) Utilisez la correspondance et contre les mots clés pour rechercher, prendre en charge le mode booléen et la recherche de phrases. 3) Les méthodes d'optimisation incluent l'utilisation de la technologie de segmentation des mots, la reconstruction périodique des index et l'ajustement de la taille du cache pour améliorer les performances et la précision. L'article discute de la configuration du cryptage SSL / TLS pour MySQL, y compris la génération et la vérification de certificat. Le problème principal est d'utiliser les implications de sécurité des certificats auto-signés. [Compte de caractère: 159] L'article traite des outils de GUI MySQL populaires comme MySQL Workbench et PhpMyAdmin, en comparant leurs fonctionnalités et leur pertinence pour les débutants et les utilisateurs avancés. [159 caractères] L'article traite des stratégies pour gérer de grands ensembles de données dans MySQL, y compris le partitionnement, la rupture, l'indexation et l'optimisation des requêtes. L'article discute de la suppression des tables dans MySQL en utilisant l'instruction TABLE DROP, mettant l'accent sur les précautions et les risques. Il souligne que l'action est irréversible sans sauvegardes, détaillant les méthodes de récupération et les risques potentiels de l'environnement de production. L'article discute de la création d'index sur les colonnes JSON dans diverses bases de données comme PostgreSQL, MySQL et MongoDB pour améliorer les performances de la requête. Il explique la syntaxe et les avantages de l'indexation des chemins JSON spécifiques et répertorie les systèmes de base de données pris en charge. MySQL prend en charge quatre types d'index: B-Tree, hachage, texte intégral et spatial. 1. L'indice de tree B est adapté à la recherche de valeur égale, à la requête de plage et au tri. 2. L'indice de hachage convient aux recherches de valeur égale, mais ne prend pas en charge la requête et le tri des plages. 3. L'index de texte complet est utilisé pour la recherche en texte intégral et convient pour le traitement de grandes quantités de données de texte. 4. L'indice spatial est utilisé pour la requête de données géospatiaux et convient aux applications SIG.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.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.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.[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 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.
......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
......
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
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.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.
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
[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.删除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
启动成功！
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.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
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 SOURCEISTABLEGGSCI (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 SOURCEISTABGGSCI (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
Outils d'IA chauds
Undresser.AI Undress
AI Clothes Remover
Undress AI Tool
Clothoff.io
AI Hentai Generator
Article chaud
Outils chauds
Bloc-notes++7.3.1
SublimeText3 version chinoise
Envoyer Studio 13.0.1
Dreamweaver CS6
SublimeText3 version Mac
Comment modifier une table dans MySQL en utilisant l'instruction ALTER TABLE?
Mar 19, 2025 pm 03:51 PM
Expliquez les capacités de recherche en texte intégral InNODB.
Apr 02, 2025 pm 06:09 PM
Comment configurer le cryptage SSL / TLS pour les connexions MySQL?
Mar 18, 2025 pm 12:01 PM
Quels sont les outils de GUI MySQL populaires (par exemple, MySQL Workbench, PhpMyAdmin)?
Mar 21, 2025 pm 06:28 PM
Comment gérez-vous les grands ensembles de données dans MySQL?
Mar 21, 2025 pm 12:15 PM
Comment déposez-vous une table dans MySQL à l'aide de l'instruction TABLE DROP?
Mar 19, 2025 pm 03:52 PM
Comment créez-vous des index sur les colonnes JSON?
Mar 21, 2025 pm 12:13 PM
Expliquez différents types d'index MySQL (B-Tree, hachage, texte intégral, spatial).
Apr 02, 2025 pm 07:05 PM
