OGG(oracle+GoldenGate)学习笔记

Total operations 5.00

*** Daily statistics since 2010-03-08 00:00:00 ***

No database operations have been performed.

*** Hourly statistics since 2010-03-08 15:00:00 ***

No database operations have been performed.

*** Latest statistics since 2010-03-05 09:51:51 ***

Total inserts 3.00 Total updates 0.00 Total deletes 0.00 Total truncates 2.00 Total discards 0.00 Total operations 5.00

Extracting from SAJET.SYS_EMP to SAJET.SYS_EMP:

*** Total statistics since 2010-03-05 09:51:51 ***

Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00

*** Daily statistics since 2010-03-08 00:00:00 ***

Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00

*** Hourly statistics since 2010-03-08 15:00:00 ***

Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00

*** Latest statistics since 2010-03-05 09:51:51 ***

Total inserts 2.00 Total updates 0.00

13

Total deletes 0.00 Total discards 0.00 Total operations 2.00

Extracting from SAJET.MLOG$_SYS_EMP to SAJET.MLOG$_SYS_EMP:

*** Total statistics since 2010-03-05 09:51:51 ***

Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00

*** Daily statistics since 2010-03-08 00:00:00 ***

Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00

*** Hourly statistics since 2010-03-08 15:00:00 ***

Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00

*** Latest statistics since 2010-03-05 09:51:51 ***

Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00

End of Statistics.

相信以上的内容大家都看的懂吧。

其他的DML操作在此省略。

14

4．GoldenGate Support DDL安装

1.选择一个Schema存放支持DDL的对象，本文选择GoldenGate 2.编辑Globals参数文件 3.关掉Oracle Recycle bin

On Oracle10gand up, system recycle bin must be disabled.

To turn off the recycle bin:

●Oracle10gRelease 2 and later: Set the RECYCLEBIN initialization parameter to OFF.

●Oracle10gRelease 1: Set the _RECYCLEBIN initialization parameter to FALSE.

4.在命令行，切换到GGS目录 5.运行SQLPLUS

6. run marker_setup.sql, enter GoldenGate schema(goldengate) 7. run ddl_setup.sql enter schema:goldengate

choose installation mode: INITIALSETUP

8. run role_setup.sql

9. grant role(GGS_GGSUSER_ROLE) to all GoldenGate Extract users; 10. run ddl_enable.sql

两端都安装完成.

具体如下：

GGSCI (PONY) 23> edit param globals 填入如下内容后保存

GGSCHEMA goldengate

D:\\ggs>sqlplus/ as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 3月 3 10:12:06 2010

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

连接到:

15

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> @marker_setup.sql

Marker setup script

You will be prompted for the name of a schema for the GoldenGate database objects. NOTE: The schema must be created prior to running this script. NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name:goldengate

Marker setup table script complete, running verification script...

Please enter the name of a schema for the GoldenGate database objects: Setting schema name to GOLDENGATE

MARKER TABLE

-------------------------------------------------------------- OK

MARKER SEQUENCE

-------------------------------------------------------------- OK

Script complete.

SQL> @ddl_setup.sql

GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...

You will be prompted for the name of a schema for the GoldenGate database object s.

NOTE: The schema must be created prior to running this script. NOTE: On Oracle 10g and up, system recycle bin must be disabled. NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name:goldengate

You will be prompted for the mode of installation.

To install or reinstall DDL replication, enter INITIALSETUP To upgrade DDL replication, enter NORMAL

16