首页 » GoldenGate » GoldenGate 小测试initial load,extract change

GoldenGate 小测试initial load,extract change

模拟一种主库不停机,做个备库并initial load,并同步改变数据

流程
安装配置GOLDEN GATE
源机启用本地Extract 进程抽取变化生成本地trail文件
源机exp
do something (DML)
目标机imp
目标机配置OGG,启用mgr
源机配置Extract data-pump 传trail 到目标机
目标机replicat 应用trail

一,配置OGG环境,安装就是解压

[root@dbsource oracle]# chown oracle.oinstall fbo_ggs_Linux_x86_ora10g_32bit.tar 

[oracle@dbsource u01]$ cd $ORACLE_BASE
[oracle@dbsource oracle]$ mkdir oggsoft
[oracle@dbsource oracle]$ cd oggsoft/
[oracle@dbsource oggsoft]$ ls
[oracle@dbsource oggsoft]$ pwd
/u01/app/oracle/oggsoft
[oracle@dbsource oggsoft]$ echo "export OGG_HOME=/u01/app/oracle/oggsoft" >> ~/.bash_profile
[oracle@dbsource oggsoft]$ . ~/.bash_profile
[oracle@dbsource oggsoft]$ echo $OGG_HOME
/u01/app/oracle/oggsoft
[oracle@dbsource ~]$ tar -xvf fbo_ggs_Linux_x86_ora10g_32bit.tar  -C /u01/app/oracle/oggsoft


note:安装个支持方向键工具
[root@dbsource Server]# rpm -ivh libtermcap-devel-2.0.8-46.1.i386.rpm 
[root@dbsource Server]# rpm -ivh readline-devel-5.1-3.el5.i386.rpm 
[root@dbsource ~]# cd rlwrap-0.37
[root@dbsource rlwrap-0.37]# ./configure
make
make install
[oracle@dbsource oggsoft]$ echo alias ggsci=\"rlwrap \.\/ggsci\" >> ~/.bash_profile
[oracle@dbsource oggsoft]$ echo alias sqlplus=\"rlwrap sqlplus\" >> ~/.bash_profile          
[oracle@dbsource oggsoft]$ echo alias ora=\"sqlplus \/ as sysdba\" >> ~/.bash_profile  
[oracle@dbsource oggsoft]$ . ~/.bash_profile 


--cd $OGG_HOME

切到OGG安装目录开始配置OGG
[oracle@dbsource oggsoft]$ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x86, 32bit (optimized), Oracle 10g on Apr 23 2012 07:06:02

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



GGSCI (dbsource) 1> create subdirs

Creating subdirectories under current directory /u01/app/oracle/oggsoft

Parameter files                /u01/app/oracle/oggsoft/dirprm: already exists
Report files                   /u01/app/oracle/oggsoft/dirrpt: created
Checkpoint files               /u01/app/oracle/oggsoft/dirchk: created
Process status files           /u01/app/oracle/oggsoft/dirpcs: created
SQL script files               /u01/app/oracle/oggsoft/dirsql: created
Database definitions files     /u01/app/oracle/oggsoft/dirdef: created
Extract data files             /u01/app/oracle/oggsoft/dirdat: created
Temporary files                /u01/app/oracle/oggsoft/dirtmp: created
Stdout files                   /u01/app/oracle/oggsoft/dirout: created

GGSCI (dbsource) 1> edit params mgr
port 8000

GGSCI (dbsource) 2> start mgr
Manager started.


GGSCI (dbsource) 3> info mgr
Manager is running (IP port dbsource.8000)

也可以直接vi  dirprm目录下的创建文件,开启extract,replicat前必须先启动mgr,负责管理ER


在源库构建一个schema

sqlplus system/oracle
SQL> create user anbob identified by anbob;
SQL> grant connect,resource to anbob;
SQL> create table anbob.obj as select * from dba_objects ;
SQL> create table anbob.tabs as select * from dba_tables ;
SQL> create table anbob.segs as select * from dba_segments ;


增加数据库级附加日志
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

为了区分,我创建了三个表,只有tabs有索引,obj、tabs表有表级日志
conn anbob/anbob
SQL> create unique index un_idx_tabs on tabs(owner,table_name);
Index created.

add table level log logging
GGSCI (dbsource) 1> dblogin userid system password oracle
Successfully logged into database.

GGSCI (dbsource) 2> add trandata anbob.obj
2012-07-22 22:21:33  WARNING OGG-00869  No unique key is defined for table 'OBJ'. 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 ANBOB.OBJ.

GGSCI (dbsource) 3> add trandata anbob.tabs

Logging of supplemental redo data enabled for table ANBOB.TABS.

查看表级日志

SQL> select * from dba_log_groups;

OWNER      LOG_GROUP_NAME                 TABLE_NAME LOG_GROUP_TYPE      ALWAYS      GENERATED
---------- ------------------------------ ---------- ------------------- ----------- --------------
ANBOB      GGS_51353                      OBJ        USER LOG GROUP      ALWAYS      USER NAME
ANBOB      GGS_51354                      TABS       USER LOG GROUP      ALWAYS      USER NAME


开始配置抽取进程eanbob1,对用户密码加密
GGSCI (dbsource) 5> encrypt password oracle encryptkey default
Using default key...

Encrypted password:  AACAAAAAAAAAAAGAIFAAUDVHCFUGFIYF
Algorithm used:  BLOWFISH


GGSCI (dbsource) 4> edit params eanbob1
extract eanbob1
--------------------------------
-- local extract for anbob schema
---------------------------------
setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )
userid system, password "AACAAAAAAAAAAAGAIFAAUDVHCFUGFIYF", encryptkey default

ReportCount Every 30 Minutes, Rate
Report at 01:00
ReportRollover at 01:15
DiscardFile dirrpt/eanbob1.dsc, Append
DiscardRollover at 02:00 ON SUNDAY
exttrail dirdat/l1
---note: two-character local Extract trail-file name
table anbob.*;
---note: table parameter must end with ';'

OGG参数名字意图很明显,比如ReportRollover,DiscardRollover就是防止报告文件和未应用记录文件太大而定时分卷。


GGSCI (dbsource) 5> add extract eanbob1, tranlog, begin now
EXTRACT added.

配置extract进程应用上面的配置文件,从现在起捕捉变化


GGSCI (dbsource) 7> add exttrail dirdat/l1, extract eanbob1, megabytes 100
EXTTRAIL added.

指派eanbob1进程在本地生成trail文件,限制大小为100mb,默认10M,取决于事务大小频繁生成新文件会影响性能

GGSCI (dbsource) 8> start extract eanbob1
Sending START request to MANAGER ...
EXTRACT EANBOB1 starting

启动本地extract进程 
GGSCI (dbsource) 10> info eanbob1

EXTRACT    EANBOB1   Last Started 2012-07-30 22:08   Status RUNNING
Checkpoint Lag       00:01:16 (updated 00:00:02 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2012-07-30 22:06:57  Seqno 11, RBA 8688640
                     SCN 0.0 (0)



用ORACLE自己的工具做INITIAL LOAD,比如EXP,EXPDP 等,也可以用OGG做INITIAL LOAD,这里用EXP
[oracle@dbsource ~]$ exp anbob/anbob file=expanbob.dmp           
Export: Release 10.2.0.1.0 - Production on Mon Jul 30 22:16:47 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ANBOB 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ANBOB 
About to export ANBOB's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ANBOB's tables via Conventional Path ...
. . exporting table                            OBJ      49745 rows exported
. . exporting table                           SEGS       4116 rows exported
. . exporting table                           TABS       1522 rows exported
. exporting synonyms
...

[oracle@dbsource ~]$ scp expanbob.dmp dbtarget:~
oracle@dbtarget's password: 
expanbob.dmp                                   100% 6264KB   6.1MB/s   00:01  


[oracle@dbtarget ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@dbtarget ~]$ imp anbob/anbob file=expanbob.dmp        

Import: Release 10.2.0.1.0 - Production on Mon Jul 30 22:53:30 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing ANBOB's objects into ANBOB
. . importing table                          "OBJ"      49745 rows imported
. . importing table                         "SEGS"       4116 rows imported
. . importing table                         "TABS"       1522 rows imported
Import terminated successfully without warnings.

三 ,在initial load的过程中源库并未关闭,我们是为了减少down机时间,但这样就会有可能在源库中发生DML 事务
SQL> select object_name from obj where object_id=10;
OBJECT_NAME
--------------------------------------------------------------------------------
c_user#

SQL> update obj set object_name='c_user' where object_id=10;
1 row updated.
SQL> commit;

SQL> insert into tabs (owner,table_name,tablespace_name) values('anbob','ggtest','users');
1 row created.

SQL> commit;

SQL> delete from segs where owner='SYSMAN';
760 rows deleted.

SQL> commit;

GGSCI (dbsource) 3> stats ext eanbob1

Sending STATS request to EXTRACT EANBOB1 ...

Start of Statistics at 2012-07-30 23:01:49.

Output to dirdat/l1:

Extracting from ANBOB.OBJ to ANBOB.OBJ:

*** Total statistics since 2012-07-30 22:56:33 ***
        Total inserts                                      0.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Daily statistics since 2012-07-30 22:56:33 ***
        Total inserts                                      0.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Hourly statistics since 2012-07-30 23:00:00 ***

        No database operations have been performed.

*** Latest statistics since 2012-07-30 22:56:33 ***
        Total inserts                                      0.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

Extracting from ANBOB.TABS to ANBOB.TABS:

*** Total statistics since 2012-07-30 22:56:33 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Daily statistics since 2012-07-30 22:56:33 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Hourly statistics since 2012-07-30 23:00:00 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Latest statistics since 2012-07-30 22:56:33 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

Extracting from ANBOB.SEGS to ANBOB.SEGS:

*** Total statistics since 2012-07-30 22:56:33 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

*** Daily statistics since 2012-07-30 22:56:33 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

*** Hourly statistics since 2012-07-30 23:00:00 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

*** Latest statistics since 2012-07-30 22:56:33 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

End of Statistics.
GGSCI (dbsource) 4> view report eanbob1

注意没有索引时会用表中的所有列
Wildcard TABLE resolved (entry anbob.*):
  table "ANBOB"."OBJ";

2012-07-30 22:56:33  WARNING OGG-00869  No unique key is defined for table 'OBJ'. All viable columns will be used to represent the key, but
 may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Using the following key columns for source table ANBOB.OBJ: OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CRE
ATED, LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY, GENERATED, SECONDARY.

Wildcard TABLE resolved (entry anbob.*):
  table "ANBOB"."TABS";
Using the following key columns for source table ANBOB.TABS: OWNER, TABLE_NAME.

[oracle@dbsource oggsoft]$ ll dirdat
total 244
-rw-rw-rw- 1 oracle oinstall 242082 Jul 30 23:00 l1000000

目标机配置mgr进程
GGSCI (dbtarget) 1> edit params mgr
port 8000
purgeoldextracts dirdat/*, usecheckpoints, minkeepdays 2

这里有个要说明的地方,最后一行就是为了防止trail文件无限增加,而自动清理已应用的trail文件,最小保留已应用后的两天

GGSCI (dbtarget) 1> start mgr
GGSCI (dbtarget) 1> info mgr
Manager is running (IP port dbtarget.8000).



源机配置data-pump extract 开始传送TRAIL文件
GGSCI (dbsource) 2> edit params pbanbob1
extract pbanbob1
--------------------------------------
-- data pump extract for anbob schema
--------------------------------------
passthru

rmtHost dbtarget, mgrport 8000
rmtTrail dirdat/l2
table anbob.*;

GGSCI (dbsource) 3> add extract pbanbob1, exttrailsource dirdat/l1
EXTRACT added.

GGSCI (dbsource) 4> add rmttrail dirdat/l2, extract pbanbob1, megabytes 100
RMTTRAIL added.


GGSCI (dbsource) 2> start ext pbanbob1

Sending START request to MANAGER ...
EXTRACT PBANBOB1 starting


GGSCI (dbsource) 3> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EANBOB1     00:00:00      00:00:00    
EXTRACT     RUNNING     PBANBOB1    00:00:00      00:18:38    


开始发现pbanbob1并没有传送,没关系,可以重新传送
GGSCI (dbsource) 42>stop ext pbanbob1

GGSCI (dbsource) 42> alter extract pbanbob1, exttrailsource dirdat/l1,begin 2012-07-30 22:06
EXTRACT altered.

GGSCI (dbsource) 43> start ext pbanbob1

Sending START request to MANAGER ...
EXTRACT PBANBOB1 starting   

GGSCI (dbsource) 46> stats ext pbanbob1

Sending STATS request to EXTRACT PBANBOB1 ...

Start of Statistics at 2012-07-31 22:17:24.

Output to dirdat/l2:

Extracting from ANBOB.OBJ to ANBOB.OBJ:

*** Total statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      0.00
        Total updates                                      2.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Daily statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      0.00
        Total updates                                      2.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Hourly statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      0.00
        Total updates                                      2.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Latest statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      0.00
        Total updates                                      2.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

Extracting from ANBOB.TABS to ANBOB.TABS:

*** Total statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Daily statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Hourly statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Latest statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

Extracting from ANBOB.SEGS to ANBOB.SEGS:

*** Total statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

*** Daily statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

*** Hourly statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

*** Latest statistics since 2012-07-31 22:17:12 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

End of Statistics.

GGSCI (dbsource) 9> view report pbanbob1
 
...

2012-07-31 22:17:12  INFO    OGG-01055  Recovery initialization completed for target file dirdat/l2000002, at RBA 1192.

2012-07-31 22:17:12  INFO    OGG-01478  Output file dirdat/l2 is using format RELEASE 11.2.

2012-07-31 22:17:12  INFO    OGG-01026  Rolling over remote file dirdat/l2000003.

2012-07-31 22:17:12  INFO    OGG-01053  Recovery completed for target file dirdat/l2000003, at RBA 1171.

2012-07-31 22:17:12  INFO    OGG-01057  Recovery completed for all targets.
....


去目标机器上验证一下文件
[oracle@dbtarget ogg11]$ ll dirdat
total 256
-rw-rw-rw- 1 oracle oinstall   1107 Jul 31 22:12 l2000000
-rw-rw-rw- 1 oracle oinstall   1212 Jul 31 22:14 l2000001
-rw-rw-rw- 1 oracle oinstall   1192 Jul 31 22:17 l2000002
-rw-rw-rw- 1 oracle oinstall 242854 Jul 31 22:17 l2000003


已成功传到目标机器dbatrget,也可以用strings OS Utilities 查看一下文件内容,前提是没有加密的话,trail文件可以加密,方法是抽取extract参数文件加ENCRYPTTRAIL,传送extract参数加

DECRYPTTRAIL,ENCRYPTTRAIL,应用replicat进程加DECRYPTTRAIL

五,配置replicat开始应用trail文件

GGSCI (dbtarget) 1> edit params ranbob1

replicat ranbob1
--------------------------------
-- replicat for anbob schema
-------------------------------
SETENV (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
userid system, password "AACAAAAAAAAAAAGAIFAAUDVHCFUGFIYF", encryptkey default

handlecollisions
AssumeTargetDefs
ReportCount Every 30 Minutes, Rate
Report at 01:00
ReportRollover at 01:15
DiscardFile dirrpt/ranbob1.dsc, Append
DiscardRollover at 02:00 ON SUNDAY
Map anbob.*, Target anbob.* ;

应用trail参数handlecollisions,表时让OGG自动处理冲突的记录,当update,delete的记录不存在时忽略,insert数据已存在时update



GGSCI (dbtarget) 10> add replicat ranbob1, exttrail dirdat/l2  CHECKPOINTTABLE system.chkpt
REPLICAT added.

GGSCI (dbtarget) 13> dblogin userid system password oracle
Successfully logged into database.

GGSCI (dbtarget) 15> add checkpointtable system.chkpt

Successfully created checkpoint table system.chkpt.


GGSCI (dbtarget) 5> info checkpointtable system.chkpt

Checkpoint table system.chkpt created 2012-07-31 00:07:03.

SQL> desc system.chkpt
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP_NAME                                NOT NULL VARCHAR2(8)
 GROUP_KEY                                 NOT NULL NUMBER(19)
 SEQNO                                              NUMBER(10)
 RBA                                       NOT NULL NUMBER(19)
 AUDIT_TS                                           VARCHAR2(29)
 CREATE_TS                                 NOT NULL DATE
 LAST_UPDATE_TS                            NOT NULL DATE
 CURRENT_DIR                               NOT NULL VARCHAR2(255)
 LOG_CSN                                            VARCHAR2(129)
 LOG_XID                                            VARCHAR2(129)
 LOG_CMPLT_CSN                                      VARCHAR2(129)
 LOG_CMPLT_XIDS                                     VARCHAR2(2000)
 VERSION                                            NUMBER(3)

SQL> select * from system.chkpt;

no rows selected

GGSCI (dbtarget) 2> start replicat ranbob1

Sending START request to MANAGER ...
REPLICAT RANBOB1 starting

GGSCI (dbtarget) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     RANBOB1     00:00:00      00:00:06    

sys@ANBOBS> select group_name,seqno,rba,last_update_ts,log_csn,log_cmplt_csn,current_dir from system.chkpt;

GROUP_NA      SEQNO        RBA LAST_UPDATE_TS      LOG_CSN    LOG_CMPLT_CSN        CURRENT_DIR
-------- ---------- ---------- ------------------- ---------- -------------------- ------------------------------
RANBOB1           3     242854 2012-07-31 22:49:50 564765     564765               /u01/app/oracle/ogg11

GGSCI (dbtarget) 1> stats replicat ranbob1

Sending STATS request to REPLICAT RANBOB1 ...

Start of Statistics at 2012-07-31 23:12:07.

Replicating from ANBOB.OBJ to ANBOB.OBJ:

*** Total statistics since 2012-07-31 22:49:48 ***
        Total inserts                                      0.00
        Total updates                                      2.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Daily statistics since 2012-07-31 22:49:48 ***
        Total inserts                                      0.00
        Total updates                                      2.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Hourly statistics since 2012-07-31 23:00:00 ***

        No database operations have been performed.

*** Latest statistics since 2012-07-31 22:49:48 ***
        Total inserts                                      0.00
        Total updates                                      2.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

Replicating from ANBOB.TABS to ANBOB.TABS:

*** Total statistics since 2012-07-31 22:49:48 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Daily statistics since 2012-07-31 22:49:48 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

*** Hourly statistics since 2012-07-31 23:00:00 ***

        No database operations have been performed.

*** Latest statistics since 2012-07-31 22:49:48 ***
        Total inserts                                      1.00
        Total updates                                      0.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   1.00

Replicating from ANBOB.SEGS to ANBOB.SEGS:

*** Total statistics since 2012-07-31 22:49:48 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

*** Daily statistics since 2012-07-31 22:49:48 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

*** Hourly statistics since 2012-07-31 23:00:00 ***

        No database operations have been performed.

*** Latest statistics since 2012-07-31 22:49:48 ***
        Total inserts                                      0.00
        Total updates                                      0.00
        Total deletes                                    760.00
        Total discards                                     0.00
        Total operations                                 760.00

End of Statistics.

GGSCI (dbtarget) 3> info replicat ranbob1, detail

REPLICAT   RANBOB1   Last Started 2012-07-31 22:49   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint  File dirdat/l2000003
                     2012-07-31 22:03:09.902105  RBA 242854

  Extract Source                          Begin             End             

  dirdat/l2000003                         * Initialized *   2012-07-31 22:03
  dirdat/l2000000                         * Initialized *   First Record    
  dirdat/l2000000                         * Initialized *   First Record    


Current directory    /u01/app/oracle/ogg11

Report file          /u01/app/oracle/ogg11/dirrpt/RANBOB1.rpt
Parameter file       /u01/app/oracle/ogg11/dirprm/ranbob1.prm
Checkpoint file      /u01/app/oracle/ogg11/dirchk/RANBOB1.cpr
Checkpoint table     system.chkpt
Process file         /u01/app/oracle/ogg11/dirpcs/RANBOB1.pcr
Stdout file          /u01/app/oracle/ogg11/dirout/RANBOB1.out
Error log            /u01/app/oracle/ogg11/ggserr.log

在源端验证一下数据库记录
anbob@ANBOBS> select object_name from obj where object_id=10
  2  ;

OBJECT_NAME
-------------------------------------------------------------
c_user

anbob@ANBOBS> select owner,tablespace_name from tabs where table_name='ggtest';

OWNER                          TABLESPACE_NAME
------------------------------ ------------------------------
anbob                          users

anbob@ANBOBS> select count(*) from  segs where owner='SYSMAN'
  2  ;

  COUNT(*)
----------
         0

应用没有问题,已同步了exp后发生的变化

测试一下适时应用会有多长时间的延时
23:26:32 anbob@prod>update obj set object_name='anbob'||10 where owner='SCOTT';

6 rows updated.

Elapsed: 00:00:00.02
23:27:24 anbob@prod>COMMIT;

Commit complete.

Elapsed: 00:00:00.00
23:27:27 anbob@prod>


23:27:32 anbob@ANBOBS> SELECT OBJECT_NAME FROM OBJ WHERE owner='SCOTT';

OBJECT_NAME
-------------------------------
anbob10
anbob10
anbob10
anbob10
anbob10
anbob10

6 rows selected.

23:27:34 anbob@ANBOBS> 

看到 23:27:27 在源库做的提交有6条数据,在目标库23:27:34秒同步成功,用了有6秒时间,OGG是以CSN为顺序,也就是COMMIT 的事务,当然优化的余地要不然OGG就不说是压秒级了。

打赏

对不起,这篇文章暂时关闭评论。