OGG（11G）RAC--＞单实例 搭建--同构同版本（数据泵初始化）

一、环境介绍

二、GoldenGate安装（源端+目标端）

1、创建OGG安装目录（RAC采用共享盘挂载目录）

源端

--划分磁盘主分区 fdisk /dev/sdd --查看主分区 lsblk --格式化主分区 mkfs.ext4 /dev/sdd1 --新建/ogg目录（双节点） mkdir -p /ogg chown -R oracle:oinstall /ogg chmod 775 /ogg --挂载主分区到/ogg目录 mount /dev/sdd1 /ogg --配置开机自动挂载 vim /etc/fstab /dev/sdd1 /ogg ext4 defaults 0 0 --生效 mount -a

目标端

mkdir -p /ogg chown -R oracle:oinstall /ogg chmod 775 /ogg

2、修改OGG操作系统用户环境变量（所有RAC节点均配置）

如需配置 alias ggsci='rlwrap ggsci’ 可参考：

https://blog.csdn.net/m0_50546016/article/details/112525017

cat<> /home/oracle/.bash_profile ################ogg profile add######################### export OGG_HOME=/ogg export PATH=$ORACLE_HOME/bin:$PATH:$OGG_HOME export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$OGG_HOME:/lib:/usr/lib alias ggsci='rlwrap ggsci' EOF

3、上传OGG安装介质并解压

chown -R oracle:oinstall /soft/ su - oracle -c "tar -xvf /soft/fbo_ggs_Linux_x64_ora11g_64bit.tar -C /ogg"

4、建立OGG表空间及用户，给用户授权

源端

SQL> show parameter db_create NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string +DATA db_create_online_log_dest_1 string db_create_online_log_dest_2 string db_create_online_log_dest_3 string db_create_online_log_dest_4 string db_create_online_log_dest_5 string SQL> create tablespace ogg_data datafile size 1024M; Tablespace created. SQL> create user ogg identified by ogg default tablespace ogg_data; User created. SQL> grant connect,resource,dba,create table,create sequence to ogg; Grant succeeded.

目标端

create tablespace ogg_data datafile '/oradata/ora11g/ogg01.dbf' size 1024M; create user ogg identified by ogg default tablespace ogg_data; grant connect,resource,dba,create table,create sequence to ogg;

5、配置数据库参数

附加日志

alter database add SUPPLEMENTAL log data;

强制日志

alter database force logging;

检查是否开启

select NAME,OPEN_MODE,FORCE_LOGGING,SUPPLEMENTAL_LOG_DATA_MIN from v$database;

开启归档日志模式

源端

--设置归档路径 su - oracle sqlplus / as sysdba alter system set log_archive_dest_1='location=+DATA'; --关闭数据库实例 srvctl stop database -d orcl -o immediate --开启数据库实例orcl1到mount状态 srvctl start instance -d orcl -i orcl1 -o mount --开启归档 sqlplus / as sysdba alter database archivelog; --开启实例orcl1 alter database open; --开启数据库实例orcl2 srvctl start instance -d orcl -i orcl2 --查看归档路径 archive log list; alter system switch logfile;

目标端

mkdir /archivelog chown -R oracle:oinstall /archivelog/ su - oracle sqlplus / as sysdba alter system set log_archive_dest_1='location=/archivelog'; shutdown immediate startup mount alter database archivelog; alter database open; archive log list; alter system switch logfile;

关闭回收站

alter system set recyclebin=off scope=spfile;

解锁scott用户

SQL> alter user scott account unlock; User altered. SQL> alter user scott identified by scott; User altered.

6 、TNS配置（所有RAC节点均配置）

加入对ASM的动态注册，具体配置根据环境决定。

注意：RAC所有节点都要配置

--所有节点都要配置 cat <> /u01/app/11.2.0/grid/network/admin/listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = +ASM) (ORACLE_HOME=/u01/app/11.2.0/grid) (SID_NAME = +ASM1) ) ) EOF --重启监听 srvctl stop listener --查看监听服务 lsnrctl stat lsnrctl services --测试连接 sqlplus sys/oracle@192.168.1.40/+ASM as sysdba sqlplus sys/oracle@192.168.1.41/+ASM as sysdba --oracle下配置TNS ##节点一配置 cat <> /u01/app/oracle/product/11.2.0/db/network/admin/tnsnames.ora +ASM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.40)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = +ASM) ) ) EOF ##节点二配置 cat <> /u01/app/oracle/product/11.2.0/db/network/admin/tnsnames.ora +ASM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.41)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = +ASM) ) ) EOF --TNS测试连接 sqlplus sys/oracle@+ASM as sysdba

7、GGSCI初始化目录

cd /ogg ggsci GGSCI (s11g) 1> create subdirs

三、GoldenGate配置

1、配置mgr进程（源端+目标端）

GGSCI (s11g) 1> edit params mgr GGSCI (s11g) 2> view params mgr port 7809 GGSCI (s11g) 3> start mgr Manager started. GGSCI (s11g) 4> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING GGSCI (s11g) 6> sh netstat -ntpl|grep 7809 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp 0 0 :::7809 :::* LISTEN 5760/./mgr GGSCI (s11g) 7> sh ps -ef|grep mgr root 14 2 0 09:59 ? 00:00:00 [async/mgr] postfix 1683 1676 0 09:59 ? 00:00:00 qmgr -l -t fifo -u oracle 5760 5752 0 11:52 ? 00:00:00 ./mgr PARAMFILE /ogg/dirprm/mgr.prm REPORTFILE /ogg/dirrpt/MGR.rpt PROCESSID MGR PORT 7809 oracle 5852 5752 0 12:15 pts/0 00:00:00 sh -c ps -ef|grep mgr oracle 5854 5852 0 12:15 pts/0 00:00:00 grep mgr

2、添加表级trandata（源端）

GGSCI (p11g01) 121> add trandata scott.* 2021-03-27 23:08:32 WARNING OGG-00869 No unique key is defined for table 'BONUS'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key. Logging of supplemental redo data enabled for table SCOTT.BONUS. Logging of supplemental redo data enabled for table SCOTT.DEPT. Logging of supplemental redo log data is already enabled for table SCOTT.EMP. 2021-03-27 23:08:34 WARNING OGG-00869 No unique key is defined for table 'SALGRADE'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key. Logging of supplemental redo data enabled for table SCOTT.SALGRADE. GGSCI (p11g01) 122> info trandata scott.* Logging of supplemental redo log data is enabled for table SCOTT.BONUS. Columns supplementally logged for table SCOTT.BONUS: ENAME, JOB, SAL, COMM. Logging of supplemental redo log data is enabled for table SCOTT.DEPT. Columns supplementally logged for table SCOTT.DEPT: DEPTNO. Logging of supplemental redo log data is enabled for table SCOTT.EMP. Columns supplementally logged for table SCOTT.EMP: EMPNO. Logging of supplemental redo log data is enabled for table SCOTT.SALGRADE. Columns supplementally logged for table SCOTT.SALGRADE: GRADE, LOSAL, HISAL.

3、配置extract抽取进程（源端）

GGSCI (p11g01) 11> add extract ext1,tranlog,begin now,threads 2 EXTRACT added. GGSCI (p11g01) 12> add exttrail /ogg/dirdat/et,extract ext1 EXTTRAIL added. GGSCI (p11g01) 13> edit param ext1 GGSCI (p11g01) 14> view param ext1 EXTRACT ext1 SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8") --此处数据库字符集设为一致 USERID ogg, PASSWORD ogg TRANLOGOPTIONS ASMUSER sys@+ASM,ASMPASSWORD oracle THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000 EXTTRAIL /ogg/dirdat/et DYNAMICRESOLUTION --DDL INCLUDE ALL TABLE scott.* GGSCI (p11g01) 15> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EXT1 00:00:00 00:02:07

4、配置pump传输进程（源端）

GGSCI (p11g01) 16> add extract pump1,exttrailsource /ogg/dirdat/et,begin now EXTRACT added. GGSCI (p11g01) 17> add rmttrail /ogg/dirdat/et,extract pump1 RMTTRAIL added. GGSCI (p11g01) 18> edit param pump1 GGSCI (p11g01) 19> view param pump1 EXTRACT pump1 RMTHOST 192.168.1.38, MGRPORT 7809 RMTTRAIL /ogg/dirdat/et PASSTHRU DYNAMICRESOLUTION TABLE scott.*; GGSCI (p11g01) 20> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EXT1 00:00:00 00:07:18 EXTRACT STOPPED PUMP1 00:00:00 00:01:40

5、添加GLOBALS参数文件，创新检查点表（源端+目标端）

GGSCI (p11g01) 21> edit params ./GLOBALS GGSCI (p11g01) 22> view param /ogg/GLOBALS GGSCHEMA ogg checkpointtable ogg.checkpoint GGSCI (p11g01) 23> add checkpointtable ogg.checkpoint Successfully created checkpoint table ogg.checkpoint.

6、配置replicat复制进程（目标端）

GGSCI (p11g) 10> add replicat rep1,exttrail /ogg/dirdat/et,checkpointtable ogg.checkpoint REPLICAT added. GGSCI (p11g) 11> edit param rep1 GGSCI (p11g) 12> view param rep1 REPLICAT rep1 setenv (ORACLE_SID=ora11g) SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db") USERID ogg,PASSWORD ogg ASSUMETARGETDEFS HANDLECOLLISIONS REPERROR (DEFAULT, DISCARD) DDLERROR DEFAULT DISCARD DDLOPTIONS REPORT DISCARDFILE /ogg/dirrpt/repr1.dsc,append,megabytes 100 MAP scott.*, TARGET scott.*;

四、数据初始化（EXPDP）

1、启动源端的EXTRACT进程

GGSCI (p11g01) 59> start ext1 Sending START request to MANAGER ... EXTRACT EXT1 starting GGSCI (p11g01) 101> start pump1 Sending START request to MANAGER ... EXTRACT PUMP1 starting GGSCI (p11g01) 105> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:00 EXTRACT RUNNING PUMP1 00:00:00 00:00:05

2、查看数据库中所有事务的开始时间

查看数据库中所有事务的开始时间，直到其大于抽取进程的启动时间再开始备份数 据库，因为GoldenGate 的只获取在Extract 启动以后的交易变化，在Extract 启动之 前开始而在Extract 启动以后才完成的交易GoldenGate 将会忽略这些交易，这些被忽 略的交易数据就会丢失。所以需要等数据库中所以的交易都在Extract 启动之后开始 的才能开始备份数据库。通过gv$transaction 视图来查看数据库中的交易： SQL> select * from gv$transaction; no rows selected 这里是测试环境没有事物，可以进行后面的备份了。

3、EXPDP 备份源端数据库

--当所有在Extract 启动之前的开始的交易都完成后，我们就可以使用expdp 备份生产端的数据库了。备份数据库的过程中一定要密切监控Extract 进程的状态，保证其一直正常运行： GGSCI (p11g01) 107> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:05 EXTRACT RUNNING PUMP1 00:00:00 00:00:08

源端查询当前数据库SCN

SQL> select current_scn from v$database; CURRENT_SCN ----------- 1147075

创建导出目录

mkdir /backup chown -R oracle:oinstall /backup/ SQL> create or replace directory dump_dir as '/backup'; Directory created.

备份源端数据库

expdp system/oracle directory=dump_dir dumpfile=scott.dmp logfile=scott.log schemas=scott flashback_scn= 1147075 Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . exported "SCOTT"."DEPT" 5.929 KB 4 rows . . exported "SCOTT"."EMP" 8.562 KB 14 rows . . exported "SCOTT"."SALGRADE" 5.859 KB 5 rows . . exported "SCOTT"."BONUS" 0 KB 0 rows

将备份文件传到目标端

scp /backup/* 192.168.1.38:/backup oracle@192.168.1.38's password: scott.dmp 100% 256KB 256.0KB/s 00:01 scott.log 100% 1871 1.8KB/s 00:00

目标端IMPDP 初始化数据

[oracle@p11g backup]$ impdp system/oracle directory=dump_dir dumpfile= scott.dmp logfile=imp_scott.log table_exists_action=replace SCHEMAS=scott Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "SCOTT"."DEPT" 5.929 KB 4 rows . . imported "SCOTT"."EMP" 8.562 KB 14 rows . . imported "SCOTT"."SALGRADE" 5.859 KB 5 rows . . imported "SCOTT"."BONUS" 0 KB 0 rows

用SCN 启动Replicat

GGSCI (p11g) 13> start rep1, aftercsn 1147075 Sending START request to MANAGER ... REPLICAT REP1 starting GGSCI (p11g) 14> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REP1 00:00:00 00:00:02

五、检查同步是否正常

1、DML测试

--测试前数据比对：源端目标端数据一致 SQL> conn scott/scott Connected. SQL> set line222 SQL> set pagesize100 SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 7566 JONES MANAGER 7839 02-APR-81 2975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 10 14 rows selected. --源端insert insert into emp (empno,ename,job) values (9874,'LUCIFER','DBA'); --源端update update emp set ename='ECHO' where empno=7934; --源端delete delete from emp where empno=7369; commit; --比对源端目标端数据，已同步 SCOTT@ora11g>/ EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- -------- 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 7566 JONES MANAGER 7839 02-APR-81 2975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 ECHO CLERK 7782 23-JAN-82 1300 10 9874 LUCIFER DBA 14 rows selected. --查看抽取进程记录 GGSCI (p11g01) 111> stats ext1 Sending STATS request to EXTRACT EXT1 ... Start of Statistics at 2021-03-27 22:57:05. Output to /ogg/dirdat/et: Extracting from SCOTT.EMP to SCOTT.EMP: *** Total statistics since 2021-03-27 22:49:41 *** Total inserts 1.00 Total updates 1.00 Total deletes 1.00 Total discards 0.00 Total operations 3.00 --查看传输进程 GGSCI (p11g01) 112> stats pump1 Sending STATS request to EXTRACT PUMP1 ... Start of Statistics at 2021-03-27 22:58:14. Output to /ogg/dirdat/et: Extracting from SCOTT.EMP to SCOTT.EMP: *** Total statistics since 2021-03-27 22:49:41 *** Total inserts 1.00 Total updates 1.00 Total deletes 1.00 Total discards 0.00 Total operations 3.00 --查看复制进程 GGSCI (p11g) 21> stats rep1 Sending STATS request to REPLICAT REP1 ... Start of Statistics at 2021-03-27 22:58:41. Replicating from SCOTT.EMP to SCOTT.EMP: *** Total statistics since 2021-03-27 22:49:46 *** Total inserts 1.00 Total updates 1.00 Total deletes 1.00 Total discards 0.00 Total operations 3.00

开启DDL

在源端执行与DDL同步相关的SQL脚本

切记@marker_setup.sql 一定要在cd $OGG_HOME目录下执行否则会卡主。执行脚本时要输入ogg管理用户，本实例是ogg。 cd /ogg sqlplus / as sysdba grant execute on utl_file to ogg; @marker_setup.sql @ddl_setup.sql @role_setup.sql grant GGS_GGSUSER_ROLE to ogg; @ddl_enable.sql @ddl_pin ogg

源端extract 配置

GGSCI (p11g01) 114> edit param ext1 GGSCI (p11g01) 115> view param ext1 EXTRACT ext1 SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8") --此处数据库字符集设为一致 USERID ogg, PASSWORD ogg TRANLOGOPTIONS ASMUSER sys@+ASM,ASMPASSWORD oracle THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000 EXTTRAIL /ogg/dirdat/et DYNAMICRESOLUTION DDL INCLUDE ALL TABLE scott.*; GGSCI (p11g01) 116> stop ext1 Sending STOP request to EXTRACT EXT1 ... Request processed. GGSCI (p11g01) 117> start ext1 Sending START request to MANAGER ... EXTRACT EXT1 starting GGSCI (p11g01) 118> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:05 EXTRACT RUNNING PUMP1 00:00:00 00:00:08

目标端replicat 配置

GGSCI (p11g) 23> edit param rep1 GGSCI (p11g) 24> view param rep1 REPLICAT rep1 setenv (ORACLE_SID=ora11g) SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db") USERID ogg,PASSWORD ogg ASSUMETARGETDEFS HANDLECOLLISIONS REPERROR (DEFAULT, DISCARD) DDLERROR DEFAULT DISCARD DDLOPTIONS REPORT DISCARDFILE /ogg/dirrpt/repr1.dsc,append,megabytes 100 MAP scott.*, TARGET scott.*; ddl include all ddlerror default ignore retryop maxretries 3 retrydelay 5 GGSCI (p11g) 25> stop rep1 Sending STOP request to REPLICAT REP1 ... Request processed. GGSCI (p11g) 26> start rep1 Sending START request to MANAGER ... REPLICAT REP1 starting GGSCI (p11g) 27> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REP1 00:00:00 00:00:00

DDL测试

--源端创建表 SQL> create table lucifer(id number not null,name varchar2(20)); Table created. SQL> alter table lucifer add primary key(id); Table altered. --增加trandata GGSCI (p11g01) 130> add trandata scott.lucifer Logging of supplemental redo data enabled for table SCOTT.LUCIFER. GGSCI (p11g01) 131> info trandata scott.lucifer Logging of supplemental redo log data is enabled for table SCOTT.LUCIFER. Columns supplementally logged for table SCOTT.LUCIFER: ID. --目标端查看 SYS@ora11g>conn scott/scott Connected. SCOTT@ora11g>select table_name from user_tables; TABLE_NAME ------------------------------ LUCIFER SALGRADE BONUS EMP DEPT SCOTT@ora11g>desc lucifer Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER NAME VARCHAR2(20)

六、测试RAC共享盘切换

假设节点一由于各种原因down机了，我们可以通过节点二mount ogg共享盘，切换到节点二进行同步

1、节点一停止所有进程

GGSCI (p11g01) 134> stop ext1 Sending STOP request to EXTRACT EXT1 ... Request processed. GGSCI (p11g01) 135> stop pump1 Sending STOP request to EXTRACT PUMP1 ... Request processed. GGSCI (p11g01) 136> GGSCI (p11g01) 136> GGSCI (p11g01) 136> stop mgr Manager process is required by other GGS processes. Are you sure you want to stop it (y/n)? y Sending STOP request to MANAGER ... Request processed. Manager stopped. GGSCI (p11g01) 137> GGSCI (p11g01) 137> GGSCI (p11g01) 137> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER STOPPED EXTRACT STOPPED EXT1 00:00:00 00:00:19 EXTRACT STOPPED PUMP1 00:00:00 00:00:15

2、节点二mount ogg共享盘

[root@p11g02 ~]# mount /ogg [root@p11g02 ~]# df -Th Filesystem Type Size Used Avail Use% Mounted on /dev/mapper/vg_p11g02-lv_root ext4 50G 12G 35G 26% / tmpfs tmpfs 2.0G 536M 1.5G 28% /dev/shm /dev/sda1 ext4 477M 42M 410M 10% /boot /dev/mapper/vg_p11g02-lv_home ext4 45G 53M 43G 1% /home /dev/sdd1 ext4 9.8G 251M 9.0G 3% /ogg

3、开启所有进程

[oracle@p11g02 ~]$ cd /ogg [oracle@p11g02 ogg]$ ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21 Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved. GGSCI (p11g02) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER STOPPED EXTRACT ABENDED EXT1 00:00:00 00:00:04 EXTRACT ABENDED PUMP1 00:00:00 00:00:09 GGSCI (p11g02) 2> GGSCI (p11g02) 2> GGSCI (p11g02) 2> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER STOPPED EXTRACT ABENDED EXT1 00:00:00 00:00:39 EXTRACT ABENDED PUMP1 00:00:00 00:00:45 GGSCI (p11g02) 3> start mgr Manager started. GGSCI (p11g02) 4> start ext1 Sending START request to MANAGER ... EXTRACT EXT1 starting GGSCI (p11g02) 5> start pump1 Sending START request to MANAGER ... EXTRACT PUMP1 starting GGSCI (p11g02) 6> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT1 00:00:01 00:00:04 EXTRACT RUNNING PUMP1 00:00:00 00:00:58

4、测试同步

源端

SQL> select * from lucifer; no rows selected SQL> insert into lucifer(id,name) values (1,'lucifer'); 1 row created. SQL> insert into lucifer(id,name) values (2,'echo'); 1 row created. SQL> commit; Commit complete. SQL> create table echo(id number primary key,name varchar2(20)); Table created. SQL> select * from lucifer; ID NAME ---------- -------------------- 1 lucifer 2 echo SQL> desc echo Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER NAME VARCHAR2(20)

源端增加trandata scott.echo

GGSCI (p11g02) 12> dblogin userid ogg,password ogg Successfully logged into database. GGSCI (p11g02) 13> add trandata scott.echo Logging of supplemental redo data enabled for table SCOTT.ECHO. GGSCI (p11g02) 14> info trandata scott.echo Logging of supplemental redo log data is enabled for table SCOTT.ECHO. Columns supplementally logged for table SCOTT.ECHO: ID.

目标端已同步

SCOTT@ora11g>select * from lucifer; ID NAME ---------- -------------------- 1 lucifer 2 echo SCOTT@ora11g>desc echo Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER NAME VARCHAR2(20)

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。