配置GoldenGate同步DDL语句

配置GoldenGate同步DDL语句(1)

在配置Goldengate同步DDL语句前，要求在数据库内完成一系列的预安装先题步骤；其中包括建立合适的Goldengate用户，如:

create user maclean identified by maclean;

grant dba to maclean;

/* 之后maclean用户将用以配置extract和pump */

之后我们需要执行一系列同步DLL语句要用到的GoldenGate脚本，这些脚本存放在GG的安

装目录下:

[maclean@rh2 gg]$ pwd

/home/maclean/gg

[maclean@rh2 gg]$ ls -l dd*.sql

-r--r--r-- 1 maclean oinstall 1059 2010-03-12 ddl_cleartrace.sql

-r--r--r-- 1 maclean oinstall 4189 2010-03-12 ddl_ddl2file.sql

-r--r--r-- 1 maclean oinstall 746 2010-03-12 ddl_disable.sql

-r--r--r-- 1 maclean oinstall 692 2010-03-12 ddl_enable.sql

-r--r--r-- 1 maclean oinstall 388 2010-03-12 ddl_nopurgeRecyclebin.sql

-r--r--r-- 1 maclean oinstall 12424 2010-05-21 ddl_ora10.sql

-r--r--r-- 1 maclean oinstall 3863 2010-05-21 ddl_ora10upCommon.sql

-r--r--r-- 1 maclean oinstall 11064 2010-03-12 ddl_ora11.sql

-r--r--r-- 1 maclean oinstall 12365 2010-03-12 ddl_ora9.sql

-r--r--r-- 1 maclean oinstall 1026 2010-03-12 ddl_pin.sql

-r--r--r-- 1 maclean oinstall 1227 2010-03-12 ddl_purgeRecyclebin.sql

-r--r--r-- 1 maclean oinstall 3686 2010-05-13 ddl_remove.sql

-r--r--r-- 1 maclean oinstall 425 2009-06-29 ddl_session1.sql

-r--r--r-- 1 maclean oinstall 1053 2009-06-23 ddl_session.sql

-r-xr-xr-x 1 maclean oinstall 228606 06-29 13:48 ddl_setup.sql

-r--r--r-- 1 maclean oinstall 8872 2010-03-12 ddl_status.sql

-r--r--r-- 1 maclean oinstall 2506 2010-03-12 ddl_staymetadata_off.sql

-r--r--r-- 1 maclean oinstall 2501 2010-03-12 ddl_staymetadata_on.sql

-r--r--r-- 1 maclean oinstall 2955 2010-03-12 ddl_tracelevel.sql

-r--r--r-- 1 maclean oinstall 2543 2010-03-12 ddl_trace_off.sql

-r--r--r-- 1 maclean oinstall 2862 2010-03-12 ddl_trace_on.sql

/* 执行goldengate ddl同步安装脚本要求以SYSDBA身份登录 */

[maclean@rh2 gg]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 6 18:01:46 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system set recyclebin=off;

System altered.

/* 同步DDL要求我们关闭10g中的回收站特性 */

SQL> @marker_setup

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:maclean

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

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

Setting schema name to MACLEAN

MARKER TABLE

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

OK

MARKER SEQUENCE

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

OK

Script complete.

/* 以SYSDBA 登陆数据库并执行当前GG安装目录下的market_setup脚本，该脚本用以建立一个DDL 标记表