| 失效链接处理 |
|
GoldenGate19.1 Oracle单向dml配置全过程 PDF 下载
本站整理下载：
相关截图：
主要内容：
创建测试⽤户及测试数据
创建 OGG ⽤户，并赋权(Source & Target 步
骤⼀样)
配置数据库⽇志
Credential store配置
[oracle@ogg19 ogg19]$
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 ogg@dbogg) 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 ogg@dbogg) 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 ogg@dbogg) 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
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
