OGG实验:喂奶间隔数据表通过OGG配置同步

Alfred Zhao

发布于 2020-02-18 14:22:33

1.2K0

发布于 2020-02-18 14:22:33

文章被收录于专栏：从ORACLE起航，领略精彩的IT技术。从ORACLE起航，领略精彩的IT技术。

我之前在《使用SQL计算宝宝每次吃奶的时间间隔(数据保障篇)》中提到数据实时同步的方案，其中有一种是数据表通过OGG进行同步，当时没有详细展开测试，只给了之前学习OGG时的配置示例。由于之前很少接触OGG的管理运维，最近在进行实际测试时遇到些问题，虽然不难，但也是初学者常遇到的问题，所以记录下这个过程。

需求：将TEST用户下的数据表T_BABY通过OGG进行同步。

环境：

源端：RHEL6.5, IP地址：192.168.1.61

Oracle 11.2.0.4 RAC（2 nodes）+ OGG 12.2.0.2

待同步数据表test.t_baby已有数据

目标端：OEL5.7, IP地址：192.168.1.11

Oracle 11.2.0.3 单实例 + OGG 12.2.0.2

数据表通过OGG配置同步：

1.源端和目标端软件安装部署
2.源端配置
3.目标端配置
4.实验中遇到的问题处理

1.源端和目标端软件安装部署

在源端和目标端都部署OGG 12.2.0.2，使用图形界面安装，默认选择安装完成后自动启动mgr进程，安装截图类似如下：

2.源端配置

首先确认数据库是否处于归档模式，是否开启force logging和数据库最小附加日志：

select log_mode,supplemental_log_data_min,force_logging from v$database;

特殊参数enable_goldengate_replication设置：

alter system set enable_goldengate_replication=true scope=both;

2.1 数据库开启最小附加日志、归档模式、force logging

--1) RAC开启归档模式
srvctl stop database -d demo
sqlplus / as sysdba
startup mount
alter database archivelog;
alter database open;
srvctl start database -d demo

--2）开启force logging
alter database force logging;

--3）开启数据库最小附加日志
alter database add supplemental log data;

开启后再次检查确认数据库已经处于归档模式、开启了force logging和数据库最小附加日志：

sys@DEMO> select log_mode,supplemental_log_data_min,force_logging from v$database;

LOG_MODE     SUPPLEME FOR
------------ -------- ---
ARCHIVELOG   YES      YES

2.2 需要同步的表开启详细附加日志

在GGSCI命令行下，使用"add trandata user.table_name"开启表的详细附加日志。

GGSCI (jystdrac1) 1> add trandata test.t_baby;
ERROR: Not logged into database, use DBLOGIN.

GGSCI (jystdrac1) 2> dblogin userid ggs_admin
Password: 
Successfully logged into database.

GGSCI (jystdrac1 as ggs_admin@demo1) 3> add trandata test.t_baby;
ERROR: No viable tables matched specification.

GGSCI (jystdrac1 as ggs_admin@demo1) 4> add trandata test.t_baby   

Logging of supplemental redo data enabled for table TEST.T_BABY.
TRANDATA for scheduling columns has been added on table 'TEST.T_BABY'.
TRANDATA for instantiation CSN has been added on table 'TEST.T_BABY'.

注意上述命令3是因为结尾多写了";"，而OGG并不需要像SQL那样以";"结尾，所以多写了";"反而会报错。

2.3 源端配置extract和datapump进程

源端配置extract和datapump进程:

GGSCI (jystdrac1) 1> edit param extbaby
--Local Extract extbaby
--Author: Alfred Zhao
--
EXTRACT extbaby
SETENV(NLS_LANG=american_america.ZHS16GBK)
SETENV(ORACLE_SID=demo1)
USERID ggs_admin, PASSWORD ggs_admin
TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD oracle
EXTTRAIL ./dirdat/st
TABLE TEST.T_BABY;


GGSCI (jystdrac1) 2> edit param dpbaby
--Local datapump dpbaby
--Author: Alfred Zhao
--
EXTRACT dpbaby
PASSTHRU
RMTHOST 192.168.1.11, MGRPORT 7809
RMTTRAIL ./dirdat/tt
TABLE TEST.T_BABY;


--添加extbaby(注意这里RAC2个节点，所以指定threads 2)
GGSCI (jystdrac1) 3> add extract extbaby, tranlog, begin now, threads 2
GGSCI (jystdrac1) 4> add exttrail ./dirdat/st, extract extbaby, megabytes 50

--添加dpbaby
GGSCI (jystdrac1) 5> add extract dpbaby, exttrailsource ./dirdat/st, begin now
GGSCI (jystdrac1) 6> add rmttrail ./dirdat/tt, EXTRACT dpbaby, MEGABYTES 50

--启动extract和datapump进程
GGSCI (jystdrac1) 7> start *

确认抽取进程正常后，初始化数据做准备，备份当前的t_baby表：

[oracle@jystdrac1 ggs]$ /bin/sh /home/oracle/baby/backup_exp_t_baby.sh

Export: Release 11.2.0.4.0 - Production on Tue Feb 11 17:36:20 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Tes
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                         T_BABY        462 rows exported
Export terminated successfully without warnings.

导出文件：/public/backup/t_baby_20200211.dmp

将源端这个导出文件传输到目标端，给后续导入使用，我这里的/public目录是NAS，源端目标端都可以访问，所以无需拷贝。

3.目标端配置

3.1 初始化数据，导入目标端数据库

导入之前确认已创建用户：test

imp test/test file=/public/backup/t_baby_20200211.dmp full=y

[oracle@OEL-ASM dirdat]$ imp test/test file=/public/backup/t_baby_20200211.dmp full=y

Import: Release 11.2.0.3.0 - Production on Tue Feb 11 17:38:09 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
. importing TEST's objects into TEST
. importing TEST's objects into TEST
. . importing table                       "T_BABY"        462 rows imported
Import terminated successfully without warnings.

3.2 目标端配置checkpointtable

view params ./GLOBALS
checkpointtable ggt_admin.chkpt
dblogin userid ggt_admin, password ggt_admin
add checkpointtable ggt_admin.chkpt

3.3 目标端配置replicat进程

edit param repbaby
--Local datapump repbaby
--Author: Alfred Zhao
--
REPLICAT repbaby
SETENV(NLS_LANG=american_america.ZHS16GBK)
SETENV (ORACLE_SID=test)
USERID ggt_admin, PASSWORD ggt_admin
DISCARDFILE ./dirrpt/repbaby.dsc, PURGE
HandleCollisions
AssumeTargetDefs
Map test.*,Target test.*;

--添加repbaby进程
add replicat repbaby, exttrail ./dirdat/tt

--确认初始化数据完成后，开启repbaby进程
GGSCI (OEL-ASM) 4> start *

Sending START request to MANAGER ...
REPLICAT REPBABY starting


GGSCI (OEL-ASM) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REPBABY     00:00:00      00:01:48    

GGSCI (OEL-ASM) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REPBABY     00:00:00      00:00:00

4.实验中遇到的问题处理

4.1 extract进程extbaby启动不成功，报错OGG-02091

2020-02-11 16:34:28  ERROR   OGG-02091  Oracle GoldenGate Capture for Oracle, extbaby.prm:  Operation not supported because enable_goldengate_replication is not set to true.
2020-02-11 16:34:28  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extbaby.prm:  PROCESS ABENDING.

这个报错很明显，按要求修改这个参数即可：

alter system set enable_goldengate_replication=true scope=both;

4.2 extract进程extbaby启动不成功，报错OGG-00446

extbaby启动不成功，日志显示：

2020-02-11 16:36:55  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, extbaby.prm:  No valid log files for current redo sequence 859, thread 1, error retrieving redo file name for sequence 859, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2020-02-11 16:33:22.000000.
2020-02-11 16:36:55  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extbaby.prm:  PROCESS ABENDING.

这是因为RAC的redo日志在ASM中无法访问到，extbaby配置文件中加入ASM实例的访问配置，并配置好对应的tnsnames.ora即可：

TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD oracle

tnsnames.ora添加：

ASM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.61)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = +ASM)
      (SID = +ASM1)
    )
  )

4.3 extract进程extbaby启动不成功，依然报错OGG-00446，但内容有区别

具体表现为启动后，还是运行一会儿后abended，具体报错如下：

2020-02-11 16:58:34  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, extbaby.prm:  Could not find archived log for sequence 2157 thread 2 under default destinations SQL <SELECT  name    FROM v$archived_log   WHERE sequence# = :ora_seq_no AND         thread# = :ora_thread AND         resetlogs_id = :ora_resetlog_id AND         archived = 'YES' AND         deleted = 'NO'         AND standby_dest = 'NO'         order by name DESC>, error retrieving redo file name for sequence 2157, archived = 1, use_alternate = 0Not able to establish initial position for begin time 2020-02-11 16:33:22.000000.
2020-02-11 16:58:34  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extbaby.prm:  PROCESS ABENDING.

这里是因为实例2一直处于关闭状态，且历史归档文件已经不存在：

sys@DEMO> set lines 180
sys@DEMO> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ -------------------
         1          1        859   52428800        512          1 YES INACTIVE              32719197 2020-02-11 07:00:52     32755401 2020-02-11 17:00:53
         2          1        860   52428800        512          1 NO  CURRENT               32755401 2020-02-11 17:00:53   2.8147E+14
         3          2       2157   52428800        512          2 YES INACTIVE              31139538 2020-01-15 11:31:48     31139543 2020-01-15 11:31:49
         4          2       2156   52428800        512          2 YES INACTIVE              31115572 2020-01-15 11:29:39     31139538 2020-01-15 11:31:48

--实例2目前没有启动,且对应sequence 2157 thread 2的归档日志已经不存在：

RMAN> list archivelog sequence 2157 thread 2;

using target database control file instead of recovery catalog
specification does not match any archived log in the repository

RMAN> list archivelog sequence 859 thread 1;

List of Archived Log Copies for database with db_unique_name DEMO
=====================================================================

Key     Thrd Seq     S Low Time           
------- ---- ------- - -------------------
262     1    859     A 2020-02-11 07:00:52
        Name: +FRA/demo/archivelog/2020_02_11/thread_1_seq_859.421.1032109253


--尝试临时启动实例2

2020-02-11 17:15:25  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, extbaby.prm:  Could not find archived log for sequence 2157 thread 2 under default destinations SQL <SELECT  name    FROM v$archived_log   WHERE sequence# = :ora_seq_no AND         thread# = :ora_thread AND         resetlogs_id = :ora_resetlog_id AND         archived = 'YES' AND         deleted = 'NO'         AND standby_dest = 'NO'         order by name DESC>, error retrieving redo file name for sequence 2157, archived = 1, use_alternate = 0Not able to establish initial position for begin time 2020-02-11 16:33:22.000000.
2020-02-11 17:15:25  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extbaby.prm:  PROCESS ABENDING.

--切换日志后，再启动ogg进程：
sys@DEMO> alter system archive log current;

System altered.

sys@DEMO> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ -------------------
         1          1        861   52428800        512          1 NO  CURRENT               32759599 2020-02-11 17:17:18   2.8147E+14
         2          1        860   52428800        512          1 YES INACTIVE              32755401 2020-02-11 17:00:53     32759599 2020-02-11 17:17:18
         3          2       2159   52428800        512          2 NO  CURRENT               32759603 2020-02-11 17:17:18   2.8147E+14
         4          2       2158   52428800        512          2 YES INACTIVE              32756440 2020-02-11 17:12:36     32759603 2020-02-11 17:17:18


GGSCI (jystdrac1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     DPBABY      00:00:00      00:00:02    
EXTRACT     STOPPED     EXTBABY     00:00:00      00:44:42    


GGSCI (jystdrac1) 2> start ext*

Sending START request to MANAGER ...
EXTRACT EXTBABY starting


GGSCI (jystdrac1) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     DPBABY      00:00:00      00:00:00    
EXTRACT     RUNNING     EXTBABY     00:00:00      00:44:50    

--依然报错：sequence 2157 thread 2
2020-02-11 17:19:31  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, extbaby.prm:  Could not find archived log for sequence 2157 thread 2 under default destinations SQL <SELECT  name    FROM v$archived_log   WHERE sequence# = :ora_seq_no AND         thread# = :ora_thread AND         resetlogs_id = :ora_resetlog_id AND         archived = 'YES' AND         deleted = 'NO'         AND standby_dest = 'NO'         order by name DESC>, error retrieving redo file name for sequence 2157, archived = 1, use_alternate = 0Not able to establish initial position for begin time 2020-02-11 16:33:22.000000.
2020-02-11 17:19:31  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extbaby.prm:  PROCESS ABENDING.

只启动实例+切换日志不行？那考虑停止所有进程和MGR，删除检查点信息，重新添加：

[oracle@jystdrac1 ggs]$ cd dirchk/
[oracle@jystdrac1 dirchk]$ ls
DPBABY.cpe  EXTBABY.cpb  EXTBABY.cpe
[oracle@jystdrac1 dirchk]$ rm *
[oracle@jystdrac1 dirchk]$ ls
[oracle@jystdrac1 dirchk]$ pwd
/data/ggs/dirchk
[oracle@jystdrac1 dirchk]$ cd /data/ggs
[oracle@jystdrac1 ggs]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jun 30 2017 14:42:26
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.



GGSCI (jystdrac1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED                                           


GGSCI (jystdrac1) 2> start mgr
Manager started.


GGSCI (jystdrac1) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           


GGSCI (jystdrac1) 4> view param extbaby

--Local Extract extbaby
--Author: Alfred Zhao
--
EXTRACT extbaby
SETENV(NLS_LANG=american_america.ZHS16GBK)
SETENV(ORACLE_SID=demo1)
USERID ggs_admin, PASSWORD ggs_admin
TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD oracle
EXTTRAIL ./dirdat/st
TABLE TEST.T_BABY;


GGSCI (jystdrac1) 5> view param dpbaby

--Local datapump dpbaby
--Author: Alfred Zhao
--
EXTRACT dpbaby
PASSTHRU
RMTHOST 192.168.1.11, MGRPORT 7809
RMTTRAIL ./dirdat/tt
TABLE TEST.T_BABY;


GGSCI (jystdrac1) 6> add extract extbaby, tranlog, begin now, threads 2
add exttrail ./dirdat/st, extract extbaby, megabytes 50EXTRACT added.


GGSCI (jystdrac1) 7> 
EXTTRAIL added.

GGSCI (jystdrac1) 8> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     STOPPED     EXTBABY     00:00:00      00:00:03    


GGSCI (jystdrac1) 9> add extract dpbaby, exttrailsource ./dirdat/st, begin now
add rmttrail ./dirdat/tt, EXTRACT dpbaby, MEGABYTES 50EXTRACT added.


GGSCI (jystdrac1) 10> 
RMTTRAIL added.

GGSCI (jystdrac1) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     STOPPED     DPBABY      00:00:00      00:00:02    
EXTRACT     STOPPED     EXTBABY     00:00:00      00:00:10    


GGSCI (jystdrac1) 12> start *

Sending START request to MANAGER ...
EXTRACT DPBABY starting

Sending START request to MANAGER ...
EXTRACT EXTBABY starting


GGSCI (jystdrac1) 13> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     DPBABY      00:00:00      00:00:20    
EXTRACT     RUNNING     EXTBABY     00:00:01      00:00:00    


GGSCI (jystdrac1) 14> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     DPBABY      00:00:00      00:00:07    
EXTRACT     RUNNING     EXTBABY     00:00:00      00:00:00    


GGSCI (jystdrac1) 15> info extbaby

EXTRACT    EXTBABY   Last Started 2020-02-11 17:24   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:06 ago)
Process ID           7702
Log Read Checkpoint  Oracle Redo Logs
                     2020-02-11 17:25:08  Thread 1, Seqno 861, RBA 282624
                     SCN 0.32760678 (32760678)
Log Read Checkpoint  Oracle Redo Logs
                     2020-02-11 17:25:10  Thread 2, Seqno 2159, RBA 260096
                     SCN 0.32760681 (32760681)


GGSCI (jystdrac1) 16>

正常不再报错后，关闭实例2不会影响OGG同步（因为我测试环境节点2有其他测试需要，所以这里关闭节点2的oracle实例）。

4.4 测试源端DML操作，目标端REPBABY进程abended，报错OGG-00869、ORA-01841

测试源端DML操作，目标端REPBABY进程abended：

--target - ogg - log:
2020-02-11 17:56:03  INFO    OGG-03522  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  Setting session time zone to source database time zone 'GMT'.
2020-02-11 17:56:05  WARNING OGG-02760  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  ASSUMETARGETDEFS is ignored because trail file ./dirdat/tt000000000 contains table definitions.
2020-02-11 17:56:05  INFO    OGG-03506  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  The source database character set, as determined from the trail file, is zhs16gbk.
2020-02-11 17:56:05  INFO    OGG-06506  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  Wildcard MAP resolved (entry test.*): Map "TEST"."T_BABY",Target test."T_BABY".
2020-02-11 17:56:07  INFO    OGG-02756  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  The definition for table TEST.T_BABY is obtained from the trail file.
2020-02-11 17:56:07  INFO    OGG-06511  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  Using following columns in default map by name: ID, FEED_TIME, LABEL.
2020-02-11 17:56:07  INFO    OGG-06510  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  Using the following key columns for target table TEST.T_BABY: ID.
2020-02-11 17:56:07  INFO    OGG-03010  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  Performing implicit conversion of column data from character set zhs16gbk to we8mswin1252.
2020-02-11 17:56:07  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  OCI Error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 (status = 1841), SQL <INSERT INTO "TEST"."T_BABY" ("ID","FEED_TIME","LABEL") VALUES (:a0,:a1,:a2)>.
2020-02-11 17:56:07  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  Aborted grouped transaction on 'TEST.T_BABY', Database error 1841 (OCI Error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 (status = 1841), SQL <INSERT INTO "TEST"."T_BABY" ("ID","FEED_TIME","LABEL") VALUES (:a0,:a1,:a2)>).
2020-02-11 17:56:07  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  Repositioning to rba 1882 in seqno 0.
2020-02-11 17:56:07  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  SQL error 1841 mapping TEST.T_BABY to TEST.T_BABY OCI Error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 (status = 1841), SQL <INSERT INTO "TEST"."T_BABY" ("ID","FEED_TIME","LABEL") VALUES (:a0,:a1,:a2)>.
2020-02-11 17:56:07  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  Error mapping from TEST.T_BABY to TEST.T_BABY.
2020-02-11 17:56:07  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repbaby.prm:  PROCESS ABENDING.
2020-02-11 17:57:09  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.

开始尝试根据字符集设置变量，无效，最终采用修改目标端字符集的方式（这个目标端没有其他业务，所以可以修改字符集）

--开始尝试根据字符集设置变量，无效：
--setenv (NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252)

--修改字符集：
alter database character set zhs16gbk;
alter database character set internal_use zhs16gbk;

--修改目标端字符集实际步骤：
shutdown immediate;
startup mount exclusive
alter system enable restricted session;
alter database open;
alter database character set internal_use zhs16gbk;
select userenv('language') from dual;

再次启动目标端replicat进程repbaby成功，且正常同步：

[oracle@OEL-ASM ggs]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jun 30 2017 14:42:26
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.



GGSCI (OEL-ASM) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REPBABY     00:00:00      00:00:02    


GGSCI (OEL-ASM) 2> info repbaby

REPLICAT   REPBABY   Last Started 2020-02-12 07:27   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:06 ago)
Process ID           9260
Log Read Checkpoint  File ./dirdat/tt000000000
                     2020-02-12 07:12:13.691544  RBA 2664


GGSCI (OEL-ASM) 3> stats rep repbaby

Sending STATS request to REPLICAT REPBABY ...

Start of Statistics at 2020-02-12 07:30:56.

Replicating from TEST.T_BABY to TEST.T_BABY:

*** Total statistics since 2020-02-12 07:27:40 ***
        Total inserts                                      4.00
        Total updates                                      0.00
        Total deletes                                      1.00
        Total discards                                     0.00
        Total operations                                   5.00

*** Daily statistics since 2020-02-12 07:27:40 ***
        Total inserts                                      4.00
        Total updates                                      0.00
        Total deletes                                      1.00
        Total discards                                     0.00
        Total operations                                   5.00

*** Hourly statistics since 2020-02-12 07:27:40 ***
        Total inserts                                      4.00
        Total updates                                      0.00
        Total deletes                                      1.00
        Total discards                                     0.00
        Total operations                                   5.00

*** Latest statistics since 2020-02-12 07:27:40 ***
        Total inserts                                      4.00
        Total updates                                      0.00
        Total deletes                                      1.00
        Total discards                                     0.00
        Total operations                                   5.00

End of Statistics.


GGSCI (OEL-ASM) 4>

至此，OGG实验:数据表通过OGG配置同步已完成。

本文参与腾讯云自媒体分享计划，分享自作者个人站点/博客。

如有侵权请联系 cloudcommunity@tencent.com 删除

数据库