C 复制oracle 表结构,Oracle 19C OGG基础运维-06增加复制表

最新推荐文章于 2021-04-08 14:36:08 发布
最新推荐文章于 2021-04-08 14:36:08 发布
阅读量206 收藏
点赞数
文章标签： C 复制oracle 表结构

Oracle 19C OGG基础运维-06增加复制表

场景一：源端extract进程和目标端replicat进程参数文件中通过*来匹配所有表。

场景二：源端extract进程和目标端replicat进程参数文件中没有通过*来匹配所有表，而是指定了固定的表。

场景一：源端extract进程和目标端replicat进程参数文件中通过*来匹配所有表。

例如：

源端：

extract进程

GGSCI (cjcos01) 16> edit params ext_01

GGSCI (cjcos01) 18> view param ext_01

extract ext_01

userid c##ogg@cjcdb,password oracle

GETUPDATEBEFORES

GETTRUNCATES

BR BRINTERVAL 2H

CACHEMGR CACHESIZE 500MB

WARNLONGTRANS 2H,CHECKINTERVAL 5M

NUMFILES 4000

EOFDELAYCSECS 10

LOGALLSUPCOLS

TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 200, parallelism 2)

discardfile ./dirrpt/jcms.dsc,append, megabytes 200

exttrail ./dirdat/ex

DDL INCLUDE ALL

DDLOPTIONS ADDTRANDATA, REPORT

TABLE cjcpdb.cjc.*;

---TABLE cjcpdb.cjc.emp;

---TABLE cjcpdb.cjc.dept;

---TABLE cjcpdb.cjc.bonus;

---TABLE cjcpdb.cjc.salgrade;

---TABLE cjcpdb.cjc.dummy;

pump投递进程

GGSCI (cjcos01) 20> edit param pump_01

GGSCI (cjcos01) 21> view param pump_01

extract pump_01

dynamicresolution

setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

userid c##ogg@cjcdb,password oracle

rmthost 192.168.31.100,mgrport 7809,compress

rmttrail ./dirdat/dp

TABLE cjcpdb.cjc.*;

---TABLE cjcpdb.cjc.emp;

---TABLE cjcpdb.cjc.dept;

---TABLE cjcpdb.cjc.bonus;

---TABLE cjcpdb.cjc.salgrade;

---TABLE cjcpdb.cjc.dummy;

进程状态

GGSCI (cjcos01) 25> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXT_01      06:16:15      00:02:21

EXTRACT     RUNNING     PUMP_01     00:00:00      00:00:02

目标端：

replicat进程

GGSCI (cjcos02) 8> edit param rep_01

GGSCI (cjcos02) 9> view param rep_01

replicat rep_01

setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

userid ogg@chenpdb,password oracle

assumetargetdefs

reperror default,discard

discardfile ./dirrpt/replzl.dsc,append,megabytes 50

DDL INCLUDE MAPPED

DDLOPTIONS REPORT

MAP cjcpdb.cjc.*, TARGET chenpdb.chen.*;

---MAP cjcpdb.cjc.emp, TARGET chenpdb.chen.emp;

---MAP cjcpdb.cjc.dept, TARGET chenpdb.chen.dept;

---MAP cjcpdb.cjc.bonus, TARGET chenpdb.chen.bonus;

---MAP cjcpdb.cjc.salgrade, TARGET chenpdb.chen.salgrade;

---MAP cjcpdb.cjc.dummy, TARGET chenpdb.chen.dummy;

进程状态

GGSCI (cjcos02) 12> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    RUNNING     REP_01      00:00:00      00:21:01

增加复制表操作：

源端在复制用户下创建新表后，只要符合*匹配的所有条件，都会自动复制，无需修改配置文件。

需要执行以下步骤：

例如 在源端创建了新表t1:

SQL> conn cjc/cjc@cjcpdb

SQL> create table t1 (id number,cname varchar2(100));

SQL> select tname from tab;

TNAME

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

DEPT

EMP

BONUS

SALGRADE

DUMMY

DEPT_BAK

T1

7 rows selected.

源端：

1 为新增的表添加附加日志

GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 29> dblogin userid c##ogg@cjcpdb password oracle

Successfully logged into database CJCPDB.

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 30> info trandata cjcpdb.cjc.t1

2020-04-10 20:38:15  INFO    OGG-10471  ***** Oracle Goldengate support information on table CJC.T1 *****

Oracle Goldengate support native capture on table CJC.T1.

Oracle Goldengate marked following column as key columns on table CJC.T1: ID, CNAME

No unique key is defined for table CJC.T1.

Logging of supplemental redo log data is disabled for table CJCPDB.CJC.T1.

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 31> add trandata cjcpdb.cjc.t1

2020-04-10 20:38:43  WARNING OGG-06439  No unique key is defined for table T1. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2020-04-10 20:38:43  INFO    OGG-15130  No key found for table CJCPDB.CJC.T1.  All viable columns will be logged.

2020-04-10 20:38:46  INFO    OGG-15132  Logging of supplemental redo data enabled for table CJCPDB.CJC.T1.

2020-04-10 20:38:46  INFO    OGG-15133  TRANDATA for scheduling columns has been added on table CJCPDB.CJC.T1.

2020-04-10 20:38:47  INFO    OGG-15135  TRANDATA for instantiation CSN has been added on table CJCPDB.CJC.T1.

2020-04-10 20:38:48  INFO    OGG-10471  ***** Oracle Goldengate support information on table CJC.T1 *****

Oracle Goldengate support native capture on table CJC.T1.

Oracle Goldengate marked following column as key columns on table CJC.T1: ID, CNAME

No unique key is defined for table CJC.T1.

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 35> info trandata cjcpdb.cjc.t1

2020-04-10 20:41:51  INFO    OGG-10471  ***** Oracle Goldengate support information on table CJC.T1 *****

Oracle Goldengate support native capture on table CJC.T1.

Oracle Goldengate marked following column as key columns on table CJC.T1: ID, CNAME

No unique key is defined for table CJC.T1.

Logging of supplemental redo log data is enabled for table CJCPDB.CJC.T1.

Columns supplementally logged for table CJCPDB.CJC.T1: "CNAME", "ID".

Prepared CSN for table CJCPDB.CJC.T1: 3644902

目标端：

2 t1表数据已经同步

SQL> conn chen/chen@chenpdb

SQL> select tname from tab;

TNAME

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

DUMMY

SALGRADE

BONUS

EMP

DEPT

T1

6 rows selected.

3 检查目标端新表上是否有外键、trigger、check约束等。

禁用外键、trigger、check约束

4 同步日志如下

SQL> create table t1 (id number,cname varchar2(100));

源端：

2020-04-10T20:31:43.623+0800  INFO    OGG-01487  Oracle GoldenGate Capture for Oracle, ext_01.prm:  DDL found, operation [create table t1 (id number,cname varchar2(100)) (size 47)], start SCN [3642918], commit SCN [3642934] instance [ (1)], DDL seqno [0], marker seqno [0].

2020-04-10T20:31:43.661+0800  INFO    OGG-10451  Oracle GoldenGate Capture for Oracle, ext_01.prm:  DDL operation included [INCLUDE ALL], optype [CREATE], objtype [TABLE], catalog "CJCPDB", objowner "CJC", objname "T1".

2020-04-10T20:31:43.854+0800  INFO    OGG-00497  Oracle GoldenGate Capture for Oracle, ext_01.prm:  Writing DDL operation to extract trail file.

目标端：

2020-04-10T20:31:49.044+0800  INFO    OGG-00482  Oracle GoldenGate Delivery for Oracle, rep_01.prm:  DDL found, operation [create table t1 (id number,cname varchar2(100)) (size 47)].

2020-04-10T20:31:49.317+0800  INFO    OGG-00489  Oracle GoldenGate Delivery for Oracle, rep_01.prm:  DDL is of mapped scope, after mapping new operation [create table "CHEN"."T1" (id number,cname varchar2(100)) (size 56)].

2020-04-10T20:31:49.317+0800  INFO    OGG-10451  Oracle GoldenGate Delivery for Oracle, rep_01.prm:  DDL operation included [INCLUDE MAPPED], optype [CREATE], objtype [TABLE], catalog "CJCPDB", objowner "CHEN", objname "T1".

2020-04-10T20:31:49.590+0800  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, rep_01.prm:  Setting current schema for DDL operation to CHEN.

2020-04-10T20:31:49.590+0800  INFO    OGG-00484  Oracle GoldenGate Delivery for Oracle, rep_01.prm:  Executing DDL operation.

2020-04-10T20:31:50.609+0800  INFO    OGG-00483  Oracle GoldenGate Delivery for Oracle, rep_01.prm:  DDL operation successful.

2020-04-10T20:31:50.614+0800  INFO    OGG-01408  Oracle GoldenGate Delivery for Oracle, rep_01.prm:  Restoring current schema for DDL operation to OGG.

5 测试表无主键并且超过32列，是否出现错误显示无法附加日志的情况?

结论：本次测试，创建33列表，可以正常附加日志。

例：创建t2表，还有33列

create table t2

(col1 number,col2 number,col3 number,col4 number,col5 number,col6 number,col7 number,col8 number,col9 number,col10 number,

col11 number,col12 number,col13 number,col14 number,col15 number,col16 number,col17 number,col18 number,col19 number,col20 number,

col21 number,col22 number,col23 number,col24 number,col25 number,col26 number,col27 number,col28 number,col29 number,col30 number,

col31 number,col32 number,col33 number);

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 32> info trandata cjcpdb.cjc.t2

2020-04-10 20:40:20  INFO    OGG-10471  ***** Oracle Goldengate support information on table CJC.T2 *****

Oracle Goldengate support native capture on table CJC.T2.

Oracle Goldengate marked following column as key columns on table CJC.T2: COL1, COL2, COL3, COL4, COL5, COL6, COL7, COL8, COL9, COL10, COL11, COL12, COL13, COL14, COL15, COL16, COL17, COL18, COL19, COL20, COL21, COL22, COL23, COL24, COL25, COL26, COL27, COL28, COL29, COL30, COL31, COL32, COL33

No unique key is defined for table CJC.T2.

Logging of supplemental redo log data is disabled for table CJCPDB.CJC.T2.

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 36> add trandata cjcpdb.cjc.t2

2020-04-10 20:42:19  WARNING OGG-06439  No unique key is defined for table T2. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2020-04-10 20:42:19  INFO    OGG-15130  No key found for table CJCPDB.CJC.T2.  All viable columns will be logged.

2020-04-10 20:42:19  WARNING OGG-01387  Table CJCPDB.CJC.T2 has no valid key columns, added unconditional supplemental log group for all table columns.

2020-04-10 20:42:19  INFO    OGG-15132  Logging of supplemental redo data enabled for table CJCPDB.CJC.T2.

2020-04-10 20:42:19  INFO    OGG-15133  TRANDATA for scheduling columns has been added on table CJCPDB.CJC.T2.

2020-04-10 20:42:19  INFO    OGG-15135  TRANDATA for instantiation CSN has been added on table CJCPDB.CJC.T2.

2020-04-10 20:42:19  INFO    OGG-10471  ***** Oracle Goldengate support information on table CJC.T2 *****

Oracle Goldengate support native capture on table CJC.T2.

Oracle Goldengate marked following column as key columns on table CJC.T2: COL1, COL2, COL3, COL4, COL5, COL6, COL7, COL8, COL9, COL10, COL11, COL12, COL13, COL14, COL15, COL16, COL17, COL18, COL19, COL20, COL21, COL22, COL23, COL24, COL25, COL26, COL27, COL28, COL29, COL30, COL31, COL32, COL33

No unique key is defined for table CJC.T2.

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 37> info trandata cjcpdb.cjc.t2

2020-04-10 20:42:43  INFO    OGG-10471  ***** Oracle Goldengate support information on table CJC.T2 *****

Oracle Goldengate support native capture on table CJC.T2.

Oracle Goldengate marked following column as key columns on table CJC.T2: COL1, COL2, COL3, COL4, COL5, COL6, COL7, COL8, COL9, COL10, COL11, COL12, COL13, COL14, COL15, COL16, COL17, COL18, COL19, COL20, COL21, COL22, COL23, COL24, COL25, COL26, COL27, COL28, COL29, COL30, COL31, COL32, COL33

No unique key is defined for table CJC.T2.

Logging of supplemental redo log data is enabled for table CJCPDB.CJC.T2.

All columns supplementally logged for table CJCPDB.CJC.T2.

Prepared CSN for table CJCPDB.CJC.T2: 3645152

场景二：源端extract进程和目标端replicat进程参数文件中没有通过*来匹配所有表，而是指定了固定的表。

例如：

源端

：

extract进程

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 41> edit param ext_01

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 42> view param ext_01

extract ext_01

userid c##ogg@cjcdb,password oracle

GETUPDATEBEFORES

GETTRUNCATES

BR BRINTERVAL 2H

CACHEMGR CACHESIZE 500MB

WARNLONGTRANS 2H,CHECKINTERVAL 5M

NUMFILES 4000

EOFDELAYCSECS 10

LOGALLSUPCOLS

TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 200, parallelism 2)

discardfile ./dirrpt/jcms.dsc,append, megabytes 200

exttrail ./dirdat/ex

DDL INCLUDE ALL

DDLOPTIONS ADDTRANDATA, REPORT

---TABLE cjcpdb.cjc.*;

TABLE cjcpdb.cjc.emp;

TABLE cjcpdb.cjc.dept;

TABLE cjcpdb.cjc.bonus;

TABLE cjcpdb.cjc.salgrade;

TABLE cjcpdb.cjc.dummy;

pump进程

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 43> edit param pump_01

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 44> view param pump_01

extract pump_01

dynamicresolution

setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

userid c##ogg@cjcdb,password oracle

rmthost 192.168.31.100,mgrport 7809,compress

rmttrail ./dirdat/dp

---TABLE cjcpdb.cjc.*;

TABLE cjcpdb.cjc.emp;

TABLE cjcpdb.cjc.dept;

TABLE cjcpdb.cjc.bonus;

TABLE cjcpdb.cjc.salgrade;

TABLE cjcpdb.cjc.dummy;

进程状态：

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 48> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXT_01      00:00:01      00:00:00

EXTRACT     RUNNING     PUMP_01     00:00:00      00:00:02

目标端：

replicat进程

GGSCI (cjcos02) 26> edit param rep_01

GGSCI (cjcos02) 27> view param rep_01

replicat rep_01

setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

userid ogg@chenpdb,password oracle

assumetargetdefs

reperror default,discard

discardfile ./dirrpt/replzl.dsc,append,megabytes 50

DDL INCLUDE MAPPED

DDLOPTIONS REPORT

DDLERROR 942 IGNORE

---MAP cjcpdb.cjc.*, TARGET chenpdb.chen.*;

MAP cjcpdb.cjc.emp, TARGET chenpdb.chen.emp;

MAP cjcpdb.cjc.dept, TARGET chenpdb.chen.dept;

MAP cjcpdb.cjc.bonus, TARGET chenpdb.chen.bonus;

MAP cjcpdb.cjc.salgrade, TARGET chenpdb.chen.salgrade;

MAP cjcpdb.cjc.dummy, TARGET chenpdb.chen.dummy;

进程状态

GGSCI (cjcos02) 30> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    RUNNING     REP_01      00:00:00      00:00:02

增加复制表操作：

1 源端数据库添加测试表

SQL> create table t1 as select * from dept;

源端：

SQL> select tname from tab;

TNAME

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

DEPT

EMP

BONUS

SALGRADE

DUMMY

T1

6 rows selected.

2 对新加表添加补充日志

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 63> info trandata cjcpdb.cjc.t1

2020-04-10 22:53:11  INFO    OGG-10471  ***** Oracle Goldengate support information on table CJC.T1 *****

Oracle Goldengate support native capture on table CJC.T1.

Oracle Goldengate marked following column as key columns on table CJC.T1: DEPTNO, DNAME, LOC

No unique key is defined for table CJC.T1.

Logging of supplemental redo log data is disabled for table CJCPDB.CJC.T1.

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 64> add trandata cjcpdb.cjc.t1

2020-04-10 22:53:16  WARNING OGG-06439  No unique key is defined for table T1. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2020-04-10 22:53:16  INFO    OGG-15130  No key found for table CJCPDB.CJC.T1.  All viable columns will be logged.

2020-04-10 22:53:20  INFO    OGG-15132  Logging of supplemental redo data enabled for table CJCPDB.CJC.T1.

2020-04-10 22:53:20  INFO    OGG-15133  TRANDATA for scheduling columns has been added on table CJCPDB.CJC.T1.

2020-04-10 22:53:22  INFO    OGG-15135  TRANDATA for instantiation CSN has been added on table CJCPDB.CJC.T1.

2020-04-10 22:53:23  INFO    OGG-10471  ***** Oracle Goldengate support information on table CJC.T1 *****

Oracle Goldengate support native capture on table CJC.T1.

Oracle Goldengate marked following column as key columns on table CJC.T1: DEPTNO, DNAME, LOC

No unique key is defined for table CJC.T1.

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 65> info trandata cjcpdb.cjc.t1

2020-04-10 22:53:25  INFO    OGG-10471  ***** Oracle Goldengate support information on table CJC.T1 *****

Oracle Goldengate support native capture on table CJC.T1.

Oracle Goldengate marked following column as key columns on table CJC.T1: DEPTNO, DNAME, LOC

No unique key is defined for table CJC.T1.

Logging of supplemental redo log data is enabled for table CJCPDB.CJC.T1.

Columns supplementally logged for table CJCPDB.CJC.T1: "DEPTNO", "DNAME", "LOC".

Prepared CSN for table CJCPDB.CJC.T1: 3695914

目标端：表还没有同步

SQL> select tname from tab;

TNAME

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

DUMMY

SALGRADE

BONUS

EMP

DEPT

3 目标端：T1表数据初始化

源端：

SQL> select dbms_flashback.get_system_change_number from dual;

GET_SYSTEM_CHANGE_NUMBER

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

3658620

[oracle@cjcos01 ogg]$ expdp cjc/cjc@cjcpdb DIRECTORY=expdp_dir DUMPFILE=cjc_t1.dmp logfile=cjc_expdp_t1.log

tables=cjc.t1 flashback_scn=3658620

[oracle@cjcos01 ogg]$ cd /backup/

[oracle@cjcos01 backup]$ scp cjc_t1.dmp 192.168.31.100:/backup

目标端：

[oracle@cjcos02 ogg]$ impdp chen/chen@chenpdb DIRECTORY=expdp_dir DUMPFILE=cjc_t1.dmp logfile=cjc_impdp_t1.log

remap_schema=cjc:chen remap_tablespace=cjctbs:chentbs table_exists_action=REPLACE

4 添加源端extract进程参数和目标端replicat进程参数。

例如：

源端：

extract进程

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 50> edit param ext_01

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 51> view param ext_01

extract ext_01

userid c##ogg@cjcdb,password oracle

GETUPDATEBEFORES

GETTRUNCATES

BR BRINTERVAL 2H

CACHEMGR CACHESIZE 500MB

WARNLONGTRANS 2H,CHECKINTERVAL 5M

NUMFILES 4000

EOFDELAYCSECS 10

LOGALLSUPCOLS

TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 200, parallelism 2)

discardfile ./dirrpt/jcms.dsc,append, megabytes 200

exttrail ./dirdat/ex

DDL INCLUDE ALL

DDLOPTIONS ADDTRANDATA, REPORT

---TABLE cjcpdb.cjc.*;

TABLE cjcpdb.cjc.emp;

TABLE cjcpdb.cjc.dept;

TABLE cjcpdb.cjc.bonus;

TABLE cjcpdb.cjc.salgrade;

TABLE cjcpdb.cjc.dummy;

TABLE cjcpdb.cjc.t1;

pump进程

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 53> edit param pump_01

GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 54> view param pump_01

extract pump_01

dynamicresolution

setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

userid c##ogg@cjcdb,password oracle

rmthost 192.168.31.100,mgrport 7809,compress

rmttrail ./dirdat/dp

---TABLE cjcpdb.cjc.*;

TABLE cjcpdb.cjc.emp;

TABLE cjcpdb.cjc.dept;

TABLE cjcpdb.cjc.bonus;

TABLE cjcpdb.cjc.salgrade;

TABLE cjcpdb.cjc.dummy;

TABLE cjcpdb.cjc.t1;

目标端添加：

replicat进程

GGSCI (cjcos02) 31> edit param rep_01

GGSCI (cjcos02) 32> view param rep_01

replicat rep_01

setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

userid ogg@chenpdb,password oracle

assumetargetdefs

reperror default,discard

discardfile ./dirrpt/replzl.dsc,append,megabytes 50

DDL INCLUDE MAPPED

DDLOPTIONS REPORT

DDLERROR 942 IGNORE

---MAP cjcpdb.cjc.*, TARGET chenpdb.chen.*;

MAP cjcpdb.cjc.emp, TARGET chenpdb.chen.emp;

MAP cjcpdb.cjc.dept, TARGET chenpdb.chen.dept;

MAP cjcpdb.cjc.bonus, TARGET chenpdb.chen.bonus;

MAP cjcpdb.cjc.salgrade, TARGET chenpdb.chen.salgrade;

MAP cjcpdb.cjc.dummy, TARGET chenpdb.chen.dummy;

MAP cjcpdb.cjc.t1, TARGET chenpdb.chen.t1;

5 检查目标端新表上是否有外键、trigger、check约束等。

禁用外键、trigger、check约束

6 重启进程，使参数生效

源端：

stop pump_01

stop ext_01

start pump_01

start ext_01

目标端：

stop rep_01

start replicat rep_01,aftercsn 3658620

7 查看同步数据

源端：

SQL> select * from t1;

DEPTNO DNAME   LOC

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

10 ACCOUNTING   NEW YORK

20 RESEARCH   DALLAS

30 SALES   CHICAGO

40 OPERATIONS   BOSTON

50 DBA   DUNHUA

60 CJC   DAPUCHAI

90 CH   CCC

目标端：t1表数据已同步

SQL> select * from t1;

DEPTNO DNAME   LOC

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

10 ACCOUNTING   NEW YORK

20 RESEARCH   DALLAS

30 SALES   CHICAGO

40 OPERATIONS   BOSTON

50 DBA   DUNHUA

60 CJC   DAPUCHAI

90 CH   CCC

欢迎关注我的微信公众号"IT小Chen"，共同学习，共同成长！！！

大师的菜
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
08-25
oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
Oracle19c配置OGG进行单用户数据同步测试
君子不怨天的博客
05-10 2520
19c单实例配置GoldenGate 并进行用户数据同步测试 当前数据使用的是经典模式配置GoldenGate 进行数据同步，关于容器数据库配置GoldenGate 请参阅： Configuring Oracle GoldenGate in a Multitenant Container Database (Doc ID 2031069.1) 一、数据库操作 1、开启数据库附加日志 开启的最小附加日志和强制日志 SQL> alter database add supplemental log da
oracle 19c ogg,Oracle 19C OGG基础运维-07减少复制表
weixin_42394206的博客
04-08 254
Oracle 19C OGG基础运维-07减少复制表场景一：源端extract进程和目标端replicat进程参数文件中通过*来匹配所有表。场景二：源端extract进程和目标端replicat进程参数文件中没有通过*来匹配所有表，而是指定了固定的表。场景一：源端extract进程和目标端replicat进程参数文件中通过*来匹配所有表。例如：源端：extract进程GGSCI (cjcos01 ...
GoldenGate复制3：异构跨平台跨版本支持DDL的oracle复制
DATA
07-28 3473
GoldenGate复制3：异构跨平台跨版本支持DDL的oracle复制   一．说明： 1.    本次要完成的OGG复制的特点 1)      异构平台：linux到windows 2)      跨版本：11.2.0.1到10.2.01 3)      支持DDL 4)      同数据：oracle到oracle 5)      不同字符集 6)      不同的sche
为Oracle配置DDL复制
cssg91583的博客
01-27 111
环境：Oracle Linux 5.8/Windows Server 2003 + Oracle 11.2.0.4 + GoldenGate 11.2 DDL复制原理：源库中建立全库级的Trigger捕捉DDL到中间表，E...
DB创建SCOTT用户
yhj20041128001的专栏
04-14 237
Rem Copyright (c) 1990 by Oracle Corporation Rem NAME REM UTLSAMPL.SQL Rem FUNCTION Rem NOTES Rem MODIFIED Rem gdudey 06/28/95 - Modified for desktop seed database Rem g...
Oracle 19c 19.1.0.4+ogg搭建完美手册
08-13
Oracle 19c 19.1.0.4+ogg搭建完美手册
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法.pdf
07-16
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法
Oracle19c-Windows客户端
04-26
Oracle19c-Windows客户端
Oracle 19C+13.4EMCC-oem部署和配置（含脚本）
04-17
Oracle 19C+13.4EMCC部署和配置 1 一、安装oracle19C数据库 1 1、 安装oracle19C软件 1 2、 创建PDB 1 3、 设置随机启动 1 4、 修改logfile大小 2 二、利用EM模板创建pdb 3 1. 上传dbca模板并设置解压 3 2. DBCA建库...
对oracle数据库中emp表的操作
09-19
基于eclipse 和oracle对数据库中表的操作 ,其中有日期插件
oracle GOLDENGATE配置
09-06
Oracle goldengate详细配置参数详解，goldengate作为Oracle数据库容灾产品、其功能强大、容易控制理解.GoldenGate公司的领先技术就是逐渐为大家所知的交易数据管理Transactional Data Management (TDM)，可以在异构的IT基础结构之间实现大量数据的秒一级的数据捕捉、转换和投递。GoldenGate可以支持几乎所有常用操作系统和数据库平台
goldengate故障处理一例（续）
04-28 324
在之前的一篇文章中提到的现象，详见：http://space.itpub.net/25618347/viewspace-722335，昨天观察下来，没有再发生，问题基本上定位是内存不足的原因，看来以后得更加小心才行！ 附上截图...
goldengate ddl mysql_配置GoldenGate同步DDL语句(3)
weixin_42717586的博客
02-23 180
在配置GoldenGate同步DDL语句(2)中我们针对多种DDL语句在GoldenGate环境中的同步进行了测试，但在默认情况下replicat在复制DDL语句失败时不会在replicat report或者ggserr.log等日志文件中产生该DDL失败的具体信息，这就会导致我们在发现DDL同步有error的情况下无法了解失败的原因。之后又去翻官方的文档，在中找到了DDLOPTIONS参数:Us...
ogg replicat OGG-00869 OCI Error ORA-01407 OGG-01154 SQL error 1407
weixin_34356138的博客
03-15 652
replicat进程报错，信息如下：2014-03-15 13:31:29 WARNING OGG-00869 OCI Error ORA-01407: cannot update ("ERP"."TB_GOS_ACCOUNT_O_LOTINVEN"."INVBALQTY") to NULL (status = 1407). UPDATE "ERP"."TB_GO...
18c ogg oracle-oracle安装手册
liuzhilong的博客
03-03 4649
目 录 第一章 概述 1.1 实验内容 第二章 实验内容 2.1 前言 2.2 软件安装 2.2.1 软件下载 2.2.2 解压介质 2.3 数据库准备 2.3.1 数据库环境准备 2.3.2 创建ogg管理用户 2.4 ogg配置 2.4...
2021数学建模美赛C题代码.zip
04-24
最全的数学建模美赛C题和代码、大量刷题题库、逻辑清晰易于学习
这是一个保存Springboot+MyBaits项目的仓库.zip
最新发布
04-24
springboot框架 一、Spring Boot基础应用 Spring Boot特征 概念： 约定优于配置，简单来说就是你所期待的配置与约定的配置一致，那么就可以不做任何配置，约定不符合期待时才需要对约定进行替换配置。 特征： 1. SpringBoot Starter：他将常用的依赖分组进行了整合，将其合并到一个依赖中，这样就可以一次性添加到项目的Maven或Gradle构建中。 2,使编码变得简单，SpringBoot采用 JavaConfig的方式对Spring进行配置，并且提供了大量的注解，极大的提高了工作效率，比如@Configuration和@bean注解结合，基于@Configuration完成类扫描，基于@bean注解把返回值注入IOC容器。 3.自动配置：SpringBoot的自动配置特性利用了Spring对条件化配置的支持，合理地推测应用所需的bean并自动化配置他们。 4.使部署变得简单，SpringBoot内置了三种Servlet容器，Tomcat，Jetty,undertow.我们只需要一个Java的运行环境就可以跑SpringBoot的项目了
课设&大作业-毕业设计精品课程网站，采用的技术是 SSM 框架和 Shiro.zip
04-24
【资源说明】【毕业设计】 1、该资源内项目代码都是经过测试运行成功，功能正常的情况下才上传的，请放心下载使用。 2、适用人群：主要针对计算机相关专业(如计科、信息安全、数据科学与大数据技术、人工智能、通信、物联网、数学、电子信息等)的同学或企业员工下载使用，具有较高的学习借鉴价值。 3、不仅适合小白学习实战练习，也可作为大作业、课程设计、毕设项目、初期项目立项演示等，欢迎下载，互相学习，共同进步！
oracle19c连接报错ora-28040
06-07
1. 使用管理员帐户登录Oracle数据库。 2. 运行以下命令以解锁用户帐户：ALTER USER username ACCOUNT UNLOCK; 3. 如果需要，重置用户密码：ALTER USER username IDENTIFIED BY new_password; 请注意，如果您不是...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值