Java知识分享网 - 轻松学习从此开始!    

Java知识分享网

Java1234官方群25:java1234官方群25
Java1234官方群25:838462530
           Java最新职位

GIT视频教程(结合github,码云)免费领取

SpringBoot打造全栈在线教育平台实战课程

毕设代做论文包查重联系人QQ:1982956321毕设大神

66套java实战课程无套路领取

Java1234 VIP课程

领取微信扫码登录Java实现视频教程

Java1234至尊VIP(特价活动)

GoldenGate19.1 Oracle单向dml配置全过程 PDF 下载


分享到:
时间:2020-10-17 09:36来源:http://www.java1234.com 作者:转载  侵权举报
GoldenGate19.1 Oracle单向dml配置全过程 PDF 下载
失效链接处理
GoldenGate19.1 Oracle单向dml配置全过程 PDF 下载


 
本站整理下载:
提取码:oklp 
 
 
相关截图:
 
主要内容:

创建测试⽤户及测试数据
创建 OGG ⽤户,并赋权(Source & Target 步
骤⼀样)
配置数据库⽇志
Credential store配置
SQL> create tablespace tb_ogg datafile size 10m ;
SQL> create user scutech identified by dingjia default tablespace tb_ogg;
User created.
SQL> grant dba to scutech;
Grant succeeded.
$ sqlplus scutech/dingjia
SQL> create table tb (id int not null, name char(10), primary key(id));
Table created.
SQL> create user ogg identified by dingjia default tablespace tb_ogg; 
SQL> grant dba to ogg;
SQL> alter database add supplemental log data;
Database altered.
SQL> alter database force logging;
Database altered.
SQL> set linesize 200;
SQL> select log_mode,supplemental_log_data_min,force_logging from v$database;
LOG_MODE SUPPLEMENTAL_LOG FORCE_LOGGING
------------------------ ---------------- -------------------------------------
-----------------------------------------
ARCHIVELOG YES YES
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> alter system set enable_goldengate_replication=true;
System altered.
GGSCI (oledb.scutech) 18> create wallet
Created wallet.
Opened wallet.
GGSCI (oledb.scutech) 19> ADD MASTERKEY
2020-10-14T06:15:17Z INFO OGG-06142 Created version 1 of master key
'OGG_DEFAULT_MASTERKEY' in Oracle Wallet.
GGSCI (oledb.scutech) 20> INFO MASTERKEY
Masterkey Name: OGG_DEFAULT_MASTERKEY
Version Creation Date Status
1 2020-10-14T14:15:17.000+08:00 Current
GGSCI (oledb.scutech) 21> INFO MASTERKEy version 1 
Masterkey Name: OGG_DEFAULT_MASTERKEY
Version Creation Date Status
1 2020-10-14T14:15:17.000+08:00 Current
GGSCI (oledb.scutech) 22>
开启表级别⽇志,追加对象为⽤户scutech下所有表
GGSCI (oledb.scutech) 54> DBLOGIN USERID ogg password dingjia;
Successfully logged into database.
GGSCI (oledb.scutech as [email protected]) 55> ADD SCHEMATRANDATA scutech
2020-10-14 19:00:57 INFO OGG-01788 SCHEMATRANDATA has been added on schema
"scutech".
2020-10-14 19:00:57 INFO OGG-01976 SCHEMATRANDATA for scheduling columns
has been added on schema "scutech".
2020-10-14 19:00:57 INFO OGG-10154 Schema level PREPARECSN set to mode
NOWAIT on schema "scutech".
2020-10-14 19:01:00 INFO OGG-10471 ***** Oracle Goldengate support
information on table SCUTECH.TA *****
Oracle Goldengate support native capture on table SCUTECH.TA.
Oracle Goldengate marked following column as key columns on table SCUTECH.TA: A
No unique key is defined for table SCUTECH.TA.
GGSCI (oledb.scutech as [email protected]) 56> info SCHEMATRANDATA scutech
2020-10-14 19:01:23 INFO OGG-06480 Schema level supplemental logging,
excluding non-validated keys, is enabled on schema "SCUTECH".
2020-10-14 19:01:23 INFO OGG-01980 Schema level supplemental logging is
enabled on schema "SCUTECH" for all scheduling columns.
2020-10-14 19:01:23 INFO OGG-10462 Schema "SCUTECH" have 1 prepared tables
for instantiation.
GGSCI (oledb.scutech as [email protected]) 57> info trandata scutech.*
2020-10-14 19:01:43 INFO OGG-06480 Schema level supplemental logging,
excluding non-validated keys, is enabled on schema "SCUTECH".
2020-10-14 19:01:43 INFO OGG-01980 Schema level supplemental logging is
enabled on schema "SCUTECH" for all scheduling columns.
2020-10-14 19:01:43 INFO OGG-10471 ***** Oracle Goldengate support
information on table SCUTECH.TA *****
Oracle Goldengate support native capture on table SCUTECH.TA.
Oracle Goldengate marked following column as key columns on table SCUTECH.TA: A
No unique key is defined for table SCUTECH.TA.
Logging of supplemental redo log data is enabled for table SCUTECH.TA.
配置 Source 端 MGR 进程
配置全局⽂件
全局⽂件 GLOBALS 要⼤写,必须放在 Golden Gate 根⽬彔下,否则其会默认将配置⽂件创建在
Golden Gate 根⽬彔下的 dirprm ⼦⽬彔中,在全局⽂件中添加 GGSCHEMA参数,这个 ggschema 就
是要抽取的数据库schema。
配置 MGR 参数⽂件
参数说明: Port:指定 MGR 进程通信端⼝ Dynamicportlist:MGR 进程为 Source 和 Target 端劢态通
信指定端⼝ Autorestart Extract:⾃劢重启 Extract 进程组,每两分钟尝试重启所有 Extract 进程,重试
5 次,每隔 5分钟清零⼀次
注意:参数配置完成后,需要重启 MGR 进程后⽣效
配置源数据抽取进程(Extract)
编辑配置⽂件 edit params ext1
参数说明:
 Extract Ext1:表示此为 Extract 进程,当前 Group 为 Ext1 
 Setenv:设置环境发量字符集
 Userid和password:表示登陆数据库使⽤的账号和密码
 Exttrail:指定本地 Trail ⽂件地址
Columns supplementally logged for table SCUTECH.TA: "A".
Prepared CSN for table SCUTECH.TA: 1968044

 

------分隔线----------------------------
锋哥公众号


锋哥微信


关注公众号
【Java资料站】
回复 666
获取 
66套java
从菜鸡到大神
项目实战课程