做oracle的同构的ogg实验

Oracle同构 ogg实验


源端：
[oracle@ora11ogg1 11.2.0]$ ./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 11g on Apr 23 2012 08:09:25


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






GGSCI (ora11ogg1) 1> info all


Program     Status      Group       Lag at Chkpt  Time Since Chkpt


MANAGER     STOPPED                                           
EXTRACT     STOPPED     EINISS      00:00:00      22:32:54    




GGSCI (ora11ogg1) 2> start mgr


Manager started.




GGSCI (ora11ogg1) 3> start extract *


Sending START request to MANAGER ...
EXTRACT EINISS starting




GGSCI (ora11ogg1) 4> view params mgr


PORT 7809




GGSCI (ora11ogg1) 5> view params einiss


extract einiss


setenv(oracle_sid=orcl1,nls_lang=AMERICAN_AMERICA.ZHS16GBK)


userid ogg,password ogg
rmthost 192.168.56.122,mgrport 7809


rmttrail /u01/ggs/11.2.0/dirdat/lt






table scott.test1;




GGSCI (ora11ogg1) 6> 








目标端：
Last login: Thu Dec 26 19:21:10 2013 from 192.168.56.1
[root@ora11ogg2 ~]# su - oracle
[oracle@ora11ogg2 ~]$ cd /u01/ggs/11.2.0/
[oracle@ora11ogg2 11.2.0]$ ./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 11g on Apr 23 2012 08:09:25


Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved
GGSCI (ora11ogg2) 1> info all


Program     Status      Group       Lag at Chkpt  Time Since Chkpt


MANAGER     STOPPED                                           
REPLICAT    STOPPED     REP1        00:00:00      22:43:09    




GGSCI (ora11ogg2) 2> start mgr


Manager started.




GGSCI (ora11ogg2) 3> start replicat rep1


Sending START request to MANAGER ...
REPLICAT REP1 starting




GGSCI (ora11ogg2) 4> view params mgr


port 7809




GGSCI (ora11ogg2) 5> view params rep1


replicat rep1




setenv(oracle_sid=orcl1,nls_lang=AMERICAN_AMERICA.ZHS16GBK)


userid ogg,password ogg


discardfile /u01/ggs/11.2.0/dirrpt/rep1.dsc, append, megabytes 10


handlecollisions


assumetargetdefs




map scott.test1, target scott.test1;


















在源端数据库上insert 
Last login: Wed Dec 25 20:00:27 2013 from 192.168.56.1
[root@ora11ogg1 ~]# su - oracle
[oracle@ora11ogg1 ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 26 19:17:22 2013


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


Connected to an idle instance.


SQL> startup
ORACLE instance started.


Total System Global Area  422670336 bytes
Fixed Size                  1336960 bytes
Variable Size             301992320 bytes
Database Buffers          113246208 bytes
Redo Buffers                6094848 bytes
Database mounted.
Database opened.
SQL> 


     conn 
Enter user-name: 
ERROR:
ORA-01017: invalid username/password; logon denied




Warning: You are no longer connected to ORACLE.
SQL> conn scott/tiger
Connected.
SQL> select count(*) from test1;


  COUNT(*)
----------
        27


SQL> insert into test1(empno,ename) values(100,'test1');


1 row created.


SQL> commit;


Commit complete.


SQL> !
[oracle@ora11ogg1 ~]$ echo $ORACLE_SID
orcl1
[oracle@ora11ogg1 ~]$ hostname
ora11ogg1
[oracle@ora11ogg1 ~]$ 








目标端实现了数据的复制：
[oracle@ora11ogg2 ~]$ 
[oracle@ora11ogg2 ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 26 19:42:18 2013


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




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> conn scott/tiger
Connected.
SQL> select count(*) from test1;


  COUNT(*)
----------
        27


SQL> select count(*) from test1;


  COUNT(*)
----------
        28


SQL> select empno,ename from test1;


     EMPNO ENAME
---------- ----------
      1121 11
       109 df
       126 oggok
       100 test1
      7369 SMITH
      7499 ALLEN
      7521 WARD
      7566 JONES
      7654 MARTIN
      7698 BLAKE
      7782 CLARK


     EMPNO ENAME
---------- ----------
      7788 SCOTT
      7839 KING
      7844 TURNER
      7876 ADAMS
      7900 JAMES
      7902 FORD
      7934 MILLER
       110 fffi121
         8 fffi121
      1008 fffi121
         1 firsto


     EMPNO ENAME
---------- ----------
       101 firsto
        11 sdfsd
      1212 dfdeee
      1001 sdfdf
       211 dfd
       112 121


28 rows selected.


SQL> !
[oracle@ora11ogg2 ~]$ echo $ORACLE_SID
ogg2
[oracle@ora11ogg2 ~]$ hostname
ora11ogg2
[oracle@ora11ogg2 ~]$ 






通过本次实验，达到了OGG数据复制的功能，当然这只是最简单的功能，下次进行复杂些的实验。以上！