GoldenGateoracle向mysql进行同步针对表同步.pdf

oracle

mysql

需积分: 31 32 浏览量更新于2023-03-16 评论收藏 1.71MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

小

颜

GoldenGate oracle向mysql 进行同步针对表同步

针对表同步 oracle向mysql 进行同步

oracle->mysql

实验前准备先删除以前的goldengate 删除安装目录即可

删除oracle gg

[root@kevin ~]# su - oracle

[oracle@kevin ~]$ cd /u01/goldengate/

[oracle@kevin goldengate]$ ls

112101 fbo_ggs_Linux_x64_ora11g_64bit.tar

[oracle@kevin goldengate]$ cd 112101/

[oracle@kevin 112101]$ rm -rf *

[oracle@kevin 112101]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 2 17:14:27 2016

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1570009088 bytes

Fixed Size 2213696 bytes

Variable Size 989857984 bytes

Database Buffers 570425344 bytes

Redo Buffers 7512064 bytes

Database mounted.

Database opened.

SQL> conn ggmaster/ggmaster

Connected.

SQL> select * from tab;

TNAME TABTYPE CLUSTERID

------------------------------ ------- ----------

CHKTAB TABLE

CHKTAB_LOX TABLE

SQL> drop table chktab purge;

Table dropped.

SQL> drop table chktab_lox purge;

Table dropped.

SQL>

删除mysql gg

[root@kevin ~]# cd /u01/mysql/

[

]

total 532132

-rw-r----- 1 94111 42424 426 Oct 15 2010 bcpfmt.tpl

-rw-r----- 1 94111 42424 1725 Oct 15 2010 bcrypt.txt

drwxr-x--- 2 94111 42424 4096 Apr 23 2012 cfg

-rw-r----- 1 94111 42424 761 Oct 15 2010 chkpt_mysql_create.sql

-rwxr-x--- 1 94111 42424 5811944 Apr 23 2012 cobgen

-rwxr-x--- 1 94111 42424 5526863 Apr 23 2012 convchk

-rw-r----- 1 94111 42424 159 Oct 15 2010 db2cntl.tpl

-rwxr-x--- 1 94111 42424 6110477 Apr 23 2012 ddlcob

-rwxr-x--- 1 94111 42424 13104805 Apr 23 2012 defgen

-rw-r----- 1 94111 42424 928 Oct 15 2010 demo_mysql_create.sql

-rw-r----- 1 94111 42424 795 Oct 15 2010 demo_mysql_insert.sql

-rw-r----- 1 94111 42424 1444 Oct 15 2010 demo_mysql_load.sql

-rw-r----- 1 94111 42424 2046 Oct 15 2010 demo_mysql_misc.sql

drwxrwxr-x 2 root root 4096 Nov 2 13:58 dirchk

drwxrwxr-x 2 root root 4096 Nov 1 13:14 dirdat

drwxrwxr-x 2 root root 4096 Nov 1 14:18 dirdef

drwxr-x--- 2 94111 42424 4096 Apr 23 2012 dirjar

drwxrwxr-x 2 root root 4096 Nov 1 13:14 dirout

drwxrwxr-x 2 root root 4096 Nov 2 16:07 dirpcs

drwxr-x--- 2 94111 42424 4096 Nov 2 13:56 dirprm

drwxrwxr-x 2 root root 4096 Nov 2 14:26 dirrpt

drwxrwxr-x 2 root root 4096 Nov 1 13:14 dirsql

drwxrwxr-x 2 root root 4096 Nov 2 14:26 dirtmp

-rwxr-x--- 1 94111 42424 6462555 Apr 23 2012 emsclnt

-rwxr-x--- 1 94111 42424 45443937 Apr 23 2012 extract

-rw-r----- 1 94111 42424 1968 Oct 15 2010 freeBSD.txt

-rwxr-x--- 1 94111 42424 6393411 Apr 23 2012 ggcmd

-rw-r----- 1 root root 3085 Nov 1 14:47 gglog-CHOUQU.dmp

-rw-r----- 1 root root 400 Nov 1 14:18 gglog-defgen.dmp

-rw-r----- 1 root root 1277 Nov 2 16:07 gglog-TONGBU.dmp

-rw-r----- 1 94111 42424 1257280 Apr 23 2012 ggMessage.dat

-rwxr-x--- 1 94111 42424 17842039 Apr 23 2012 ggsci

-rw-rw-rw- 1 root root 23202 Nov 2 16:07 ggserr.log

-rw-r--r-- 1 root root 313026560 Nov 1 11:33

ggs_Linux_x64_MySQL_64bit.tar

-rw-r----- 1 94111 42424 169753 Jan 31 2012 help.txt

-rwxr-x--- 1 94111 42424 406 Apr 23 2012 jagent.sh

-rwxr-x--- 1 94111 42424 327018 Apr 23 2012 keygen

drwxr-x--- 2 94111 42424 4096 Apr 23 2012 lib

-rwxr-x--- 1 94111 42424 113969 Apr 19 2012 libantlr3c.so

-rwxr-x--- 1 94111 42424 1829888 Apr 19 2012 libdb-5.2.so

-rwxr-x--- 1 94111 42424 7744194 Apr 23 2012 libgglog.so

-rwxr-x--- 1 94111 42424 2059347 Apr 23 2012 libggrepo.so

-rwxr-x--- 1 94111 42424 15581892 Apr 19 2012 libicudata.so.38

-rwxr-x--- 1 94111 42424 5359083 Apr 19 2012 libicui18n.so.38

-rwxr-x--- 1 94111 42424 4034679 Apr 19 2012 libicuuc.so.38

-rwxr-x--- 1 94111 42424 5323945 Apr 19 2012 libxerces-c.so.28

-rw-r----- 1 94111 42424 1668 Oct 15 2010 libxml2.txt

-rwxr-x--- 1 94111 42424 7058977 Apr 23 2012 logdump

-rwxr-x--- 1 94111 42424 14171232 Apr 23 2012 mgr

-rw-r----- 1 94111 42424 718 Oct 15 2010 mysql.txt

-rw-r----- 1 94111 42424 213535 Jan 18 2012 notices.txt

-rwxr-x--- 1 94111 42424 5014069 Apr 23 2012 oggerr

-rw-r----- 1 94111 42424 1272 Dec 28 2010 prvtclkm.plb

-rwxr-x--- 1 94111 42424 1015 Apr 23 2012 pw_agent_util.sh

-rwxr-x--- 1 94111 42424 35555972 Apr 23 2012 replicat

-rwxr-x--- 1 94111 42424 5034645 Apr 23 2012 retrace

-rwxr-x--- 1 94111 42424 706347 Apr 23 2012 reverse

-rwxr-x--- 1 94111 42424 13363807 Apr 23 2012 server

-rw-r----- 1 94111 42424 248 Oct 15 2010 sqlldr.tpl

-rw-r----- 1 94111 42424 759 Oct 15 2010 tcperrs

剩余11页未读，继续阅读

qq_26884781

粉丝: 0
资源: 2

会员权益专享

GoldenGate oracle向mysql 进行同步针对表同步.pdf

评论0

会员权益专享

最新资源

GoldenGate oracle向mysql 进行同步 针对表同步.pdf

评论0

深入理解otter.pdf

Goldengate OGG 12c Mysql2Mysql 搭建案例

mysql-oracle数据同步

Oracle GoldenGate中如何配置oracle表到oracle表到数据同步

oracle与redis数据同步

oracle数据库实时同步至mysql数据库

oracle goldengate 12.2.0.1 for oracle下载

Oracle TimesTen 如何与oracle database数据同步

Oracle GoldenGate 的常用命令

oracle跨ip同步

sql server向mysql同步数据

如何实时同步oracle数据库

oracle数据库同步工具

oracle数据库如何触发同步

oracle goldengategit 和 oracle goldengate版本

oracle迁移到mysql的详细方案

提供goldengate 支持MySQL 分布式 抽取案例

goldengate双向同步配置

oracle数据库迁移mysql

ORACLE中全量同步和增量同步的写法

会员权益专享

最新资源

GoldenGate oracle向mysql 进行同步针对表同步.pdf

提供goldengate 支持MySQL 分布式抽取案例