oracle goldengate 双向复制配置

最新推荐文章于 2024-05-14 09:23:05 发布
最新推荐文章于 2024-05-14 09:23:05 发布
阅读量202 收藏
点赞数
文章标签： 数据库 操作系统 网络
oracle goldengate bi-directional active-active configure
 
一、golden gate 软件安装，建立安装目录后，在该目录下解压即可。（在源端和目标端都执行）
注意：建议用oracle 用户安装，设置oralce用户的环境变量：
LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib:$ORACLE_GOLDENGATE:$ORACLE_HOME/lib
LD_LIBRARY_PATH 中必须有 $ORACLE_HOME/lib 才能执行./ggsci ，否则回报缺少动态库文件的错误：
但是这种情况下oracle 数据库运行没有问题。
[oracle@haozg goldengate]$ ./ggsci
./ggsci: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file:
No such file or directory
原因是：goldengate 在运行时需要oralce 的动态库文件。所以需要把oracle的动态库文件放到共享库中，
赋值给环境变量LD_LIBRARY_PATH，ogg 的官方文档是这样描述：
Make certain that the database libraries are added to the shared-library environment variables of the system。
--ogg官方文档上的安装步骤
Installing Oracle GoldenGate on Linux and UNIX
Follow these steps to install Oracle GoldenGate for Oracle on a Linux or UNIX system 。
Installing the Oracle GoldenGate files
1. Extract the Oracle GoldenGate mediapack.zip file to the system and directory where you
   want Oracle GoldenGate to be installed.
2. Run the command shell.
   ./ggsci
3、In GGSCI, issue the following command to create the Oracle GoldenGate working directories.
   CREATE SUBDIRS
4、Issue the following command to exit GGSCI.
   EXIT
  
  
二、创建goldengate 用户（在源端和目标端都执行）
说明：为goldengate软件创建数据库用户，为了不影响生产环境，此用户用来安装存放一些复制软件自身用到的procedure、table等，
      也就是搭建ddl复制环境用到的一些表，过程等。该用户需要有一定的权限。---ddl objects 都在这个用户下。
      Oracle GoldenGate schema   --ogg 官网上的称呼
注意：该用户在官网上也称之外复制用户：     replicate user
1、创建 ogg schema
SQL> create user ogg identified by ogg; 
User created.
2、对其授权
SQL> grant connect,resource,dba to ogg;
Grant succeeded.
SQL> GRANT EXECUTE ON utl_file TO ogg;
Grant succeeded.
SQL> !pwd   
/oracle/goldengate
===========配置思路是：先配置主端到灾备端的单向复制，然后再配置从灾备端到主端的单向复制，从而实现双向复制============
三  先执行从主端到灾备端的单向复制配置
------------------------------主端的配置---------------------------------------------------
---------------------------数据库层面的配置--------------------------------------------------
1、检查附加日志情况
Select
SUPPLEMENTAL_LOG_DATA_MIN
,SUPPLEMENTAL_LOG_DATA_PK
,SUPPLEMENTAL_LOG_DATA_UI
,SUPPLEMENTAL_LOG_DATA_FK
,SUPPLEMENTAL_LOG_DATA_ALL from v$database;
正确状态如下：
SUPPLEME SUP SUP SUP SUP
-------- --- --- --- ---
YES      NO  NO  NO  NO
2、增加数据库附加日志及回退
alter database add supplemental log data;
alter database add supplemental log data (primary key, unique,foreign key) columns;
---rollback
alter database drop supplemental log data (primary key, unique,foreign key) columns;
alter database drop supplemental log data;
3、开启数据库强制日志模式
alter database force logging;
------------------------------安装ddl 复制支持-----------------------------
4、执行marker_setup.sql 脚本。This script. installs support for the Oracle GoldenGate DDL marker system
SQL> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:ogg

Marker setup table script. complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGG
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
Script. complete.
SQL>
5、执行@ddl_setup.sql
SQL> @ddl_setup.sql
Oracle 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 Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:ogg
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...
Check complete.

Using OGG as a Oracle GoldenGate schema name.
Working, please wait ...
DDL replication setup script. complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGG
CLEAR_TRACE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
CREATE_TRACE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
TRACE_PUT_LINE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
INITIAL_SETUP STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDLVERSIONSPECIFIC PACKAGE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDLREPLICATION PACKAGE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDL IGNORE TABLE
-----------------------------------
OK
DDL IGNORE LOG TABLE
-----------------------------------
OK
DDLAUX  PACKAGE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDLAUX PACKAGE BODY STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
SYS.DDLCTXINFO  PACKAGE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
SYS.DDLCTXINFO  PACKAGE BODY STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDL HISTORY TABLE
-----------------------------------
OK
DDL HISTORY TABLE(1)
-----------------------------------
OK
DDL DUMP TABLES
-----------------------------------
OK
DDL DUMP COLUMNS
-----------------------------------
OK
DDL DUMP LOG GROUPS
-----------------------------------
OK
DDL DUMP PARTITIONS
-----------------------------------
OK
DDL DUMP PRIMARY KEYS
-----------------------------------
OK
DDL SEQUENCE
-----------------------------------
OK
GGS_TEMP_COLS
-----------------------------------
OK
GGS_TEMP_UK
-----------------------------------
OK
DDL TRIGGER CODE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDL TRIGGER INSTALL STATUS
-----------------------------------
OK
DDL TRIGGER RUNNING STATUS
----------------------------------------------------------------------
ENABLED
STAYMETADATA IN TRIGGER
----------------------------------------------------------------------
OFF
DDL TRIGGER SQL TRACING
----------------------------------------------------------------------
0
DDL TRIGGER TRACE LEVEL
----------------------------------------------------------------------
0
LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/oracle/diag/rdbms/ora11/ora11/trace/ggs_ddl_trace.log
Analyzing installation status...

STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components
Script. complete.
SQL>
6、执行role_setup.sql。
The script. drops and creates the role that is needed for DDL synchronization, and it grants DML permissions on
the Oracle GoldenGate DDL objects.
SQL> @role_setup.sql。
GGS Role setup script
This script. will drop and recreate the role GGS_GGSUSER_ROLE
To use a different role name, quit this script. and then edit the params.sql script. to change the gg_role parameter to the preferred name. (Do not run the 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:ogg
Wrote file role_setup_set.txt
PL/SQL procedure successfully completed.

Role setup script. complete
Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:
GRANT GGS_GGSUSER_ROLE TO
where is the user assigned to the GoldenGate processes.
SQL>
7、Grant the role that was created (default name is GGS_GGSUSER_ROLE  to all Oracle GoldenGate Extract users.
SQL> Grant GGS_GGSUSER_ROLE to ogg;
Grant succeeded.
SQL>

8、执行@ddl_enable.sql，Run the  ddl_enable.sql  script. to enable the DDL trigger.
   ddl triger 判断在有ddl发生时是否把ddl 发送给extract 进程。
SQL> @ddl_enable.sql
Trigger altered.
9、执行优化脚本。
To improve the performance of the DDL trigger, make the ddl_pin script. part of the database startup。
SQL> @ddl_pin ogg
PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.
SQL>
-------------------安装 sequence 复制支持-------------------------------------------
10、在主端和备端都执行sequence.sql
SQL> @sequence.sql
Please enter the name of a schema for the GoldenGate database objects:
ogg
Setting schema name to OGG
UPDATE_SEQUENCE STATUS:
Line/pos
--------------------
Error
-----------------------------------------------------------------
No errors
No errors

GETSEQFLUSH
Line/pos
--------------------
Error
-----------------------------------------------------------------
No errors
No errors

SEQTRACE
Line/pos
--------------------
Error
-----------------------------------------------------------------
No errors
No errors

REPLICATE_SEQUENCE STATUS:
Line/pos
--------------------
Error
-----------------------------------------------------------------
No errors
No errors

STATUS OF SEQUENCE SUPPORT
--------------------------------------------------------------
SUCCESSFUL installation of Oracle Sequence Replication support
SQL>
11、在主端执行下面的命令
GRANT EXECUTE on OGG.updateSequence TO OGG;
12、在备端端执行
GRANT EXECUTE on ogg.replicateSequence TO ogg;
13、在主端执行下面的命令
alter table sys.seq$ add supplemental log data (primary key) columns;

----------------------goldengate  参数配置----------------------------------------------
14、在主端配置globals 参数
GGSCI (haozg) 4> edit params ./globals
GGSCHEMA ogg
15、在主端配置管理进程 mgr
GGSCI (haozg) 1> edit params mgr
PORT 7839
DYNAMICPORTLIST  7840-7849
PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS, MINKEEPDAYS 7
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
--DDL
PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 7
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 7
-------------------参数说明----
DYNAMICPORTLIST： Specifies the ports that Collector can dynamically allocate.
PORT： Establishes the TCP/IP port number on which Manager listens for requests.
PURGEDDLHISTORY Purges rows from the Oracle DDL history table when they are no longer needed.

16、在主端配置 extract 进程
GGSCI (haozg) 1> edit params ext_test
EXTRACT ext_test
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
DBOPTIONS   ALLOWUNUSEDCOLUMN
USERID ogg, PASSWORD AACAAAAAAAAAAADAHBLDCCIIOIRFNEPB, ENCRYPTKEY default
TRANLOGOPTIONS EXCLUDEUSER ogg
--GETTRUNCATES
REPORTCOUNT EVERY 1 MINUTES, RATE
NUMFILES 5000
DISCARDFILE ./dirrpt/ext_test.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER AT 2:00
WARNLONGTRANS 2h, CHECKINTERVAL 3m
EXTTRAIL ./dirdat/st, MEGABYTES 200
DYNAMICRESOLUTION
TRANLOGOPTIONS CONVERTUCS2CLOBS
TRANLOGOPTIONS RAWDEVICEOFFSET 0
DDL &
INCLUDE MAPPED OBJTYPE 'table' &
INCLUDE MAPPED OBJTYPE 'index' &
INCLUDE MAPPED OBJTYPE 'SEQUENCE' &
EXCLUDE OPTYPE COMMENT &
EXCLUDE OBJNAME "HAOZG.TEST15"
DDLOPTIONS  NOCROSSRENAME  REPORT
TABLE     HAOZG.*;
SEQUENCE  HAOZG.*;

17、在主端配置投递进程
GGSCI (haozg) 2> edit params dp_test
EXTRACT dp_test
RMTHOST 192.168.1.101, MGRPORT 7839, COMPRESS
PASSTHRU
NUMFILES 5000
RMTTRAIL ./dirdat/st
DYNAMICRESOLUTION
TABLE      HAOZG.*;
SEQUENCE   HAOZG.*;
18、在主端添加抽取/投递进程与队列文件
GGSCI>add ext ext_test,tranlog ,begin now
GGSCI>add exttrail ./dirdat/st,ext ext_test,megabytes 200  -----备注：添加抽取进程，每个队文件大小为200m
GGSCI>add ext dp_test,exttrailsource ./dirdat/st           -----备注：添加投递进程，从某一个队列开始投
GGSCI>add rmttrail ./dirdat/st,ext dp_test,megabytes 200   -----备注：投递进程，每个队文件大小为200m

------------------------------------备端的配置--------------------------------------
19、 在备端配置GLOBALS
GGSCI (rac2) 1> edit params ./globals
GGSCHEMA ogg
CHECKPOINTTABLE ogg.oggchkpt
20、在备端添加检查表
GGSCI (rac2) 2> DBLOGIN USERID ogg, PASSWORD AACAAAAAAAAAAADAHBLDCCIIOIRFNEPB , ENCRYPTKEY default
Successfully logged into database.
GGSCI (rac2) 3> ADD CHECKPOINTTABLE ogg.oggchkpt
Successfully created checkpoint table ogg.oggchkpt.
GGSCI (rac2) 4>
21、备端配置mgr 管理进程
GGSCI (rac2) 1> edit params mgr
PORT 7839
DYNAMICPORTLIST 7840-7849
--AUTOSTART REPLICAT *
--AUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 1
PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS, MINKEEPDAYS 7
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
22、备端配置复制进程

GGSCI (rac2) 2> edit params rep_test
REPLICAT rep_test
SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
USERID ogg, PASSWORD AACAAAAAAAAAAADAHBLDCCIIOIRFNEPB ,ENCRYPTKEY default
REPORT AT 00:59
REPORTCOUNT EVERY 1 MINUTES, RATE
REPORTROLLOVER AT 02:00
REPERROR DEFAULT, ABEND
NUMFILES 5000
GROUPTRANSOPS 10000
--HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/repylqa.dsc, APPEND, MEGABYTES 200
DISCARDROLLOVER AT 02:00
GETTRUNCATES
ALLOWNOOPUPDATES
DDL include mapped &
EXCLUDE OBJNAME "HAOZG.TEST15"
DDLOPTIONS report
MAPEXCLUDE HAOZG.TEST15
MAP HAOZG.*,TARGET HAOZG.*;
23、添加复制进程rep_test
GGSCI (rac2) 1> ADD REPLICAT rep_test, EXTTRAIL ./dirdat/st , EXTSEQNO 0, EXTRBA 0 , CHECKPOINTTABLE ogg.oggchkpt
REPLICAT added.
-------到此为止 完成了从主端到灾备端的单向复制配置-------------------
-----下面是从备端到主端的单向复制配置，现在要保持思路清晰，主端成为备端，备端成为主端。
--------在主端做的配置，即原来的备端
---------------------------数据库层面的配置--------------------------------------------------
1、检查附加日志情况
Select
SUPPLEMENTAL_LOG_DATA_MIN
,SUPPLEMENTAL_LOG_DATA_PK
,SUPPLEMENTAL_LOG_DATA_UI
,SUPPLEMENTAL_LOG_DATA_FK
,SUPPLEMENTAL_LOG_DATA_ALL from v$database;
正确状态如下：
SUPPLEME SUP SUP SUP SUP
-------- --- --- --- ---
YES      NO  NO  NO  NO
2、增加数据库附加日志及回退
alter database add supplemental log data;
alter database add supplemental log data (primary key, unique,foreign key) columns;
---rollback
alter database drop supplemental log data (primary key, unique,foreign key) columns;
alter database drop supplemental log data;
3、开启数据库强制日志模式
alter database force logging;
------------------------------安装ddl 复制支持-----------------------------
4、执行marker_setup.sql 脚本。This script. installs support for the Oracle GoldenGate DDL marker system
SQL> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:ogg

Marker setup table script. complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGG
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
Script. complete.
SQL>
5、执行@ddl_setup.sql
SQL> @ddl_setup.sql
Oracle 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 Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:ogg
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...
Check complete.

Using OGG as a Oracle GoldenGate schema name.
Working, please wait ...
DDL replication setup script. complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGG
CLEAR_TRACE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
CREATE_TRACE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
TRACE_PUT_LINE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
INITIAL_SETUP STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDLVERSIONSPECIFIC PACKAGE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDLREPLICATION PACKAGE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDL IGNORE TABLE
-----------------------------------
OK
DDL IGNORE LOG TABLE
-----------------------------------
OK
DDLAUX  PACKAGE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDLAUX PACKAGE BODY STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
SYS.DDLCTXINFO  PACKAGE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
SYS.DDLCTXINFO  PACKAGE BODY STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDL HISTORY TABLE
-----------------------------------
OK
DDL HISTORY TABLE(1)
-----------------------------------
OK
DDL DUMP TABLES
-----------------------------------
OK
DDL DUMP COLUMNS
-----------------------------------
OK
DDL DUMP LOG GROUPS
-----------------------------------
OK
DDL DUMP PARTITIONS
-----------------------------------
OK
DDL DUMP PRIMARY KEYS
-----------------------------------
OK
DDL SEQUENCE
-----------------------------------
OK
GGS_TEMP_COLS
-----------------------------------
OK
GGS_TEMP_UK
-----------------------------------
OK
DDL TRIGGER CODE STATUS:
Line/pos             Error
-------------------- -----------------------------------------------------------------
No errors            No errors
DDL TRIGGER INSTALL STATUS
-----------------------------------
OK
DDL TRIGGER RUNNING STATUS
----------------------------------------------------------------------
ENABLED
STAYMETADATA IN TRIGGER
----------------------------------------------------------------------
OFF
DDL TRIGGER SQL TRACING
----------------------------------------------------------------------
0
DDL TRIGGER TRACE LEVEL
----------------------------------------------------------------------
0
LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/oracle/diag/rdbms/ora11/ora11/trace/ggs_ddl_trace.log
Analyzing installation status...

STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components
Script. complete.
SQL>
6、执行role_setup.sql。
The script. drops and creates the role that is needed for DDL synchronization, and it grants DML permissions on
the Oracle GoldenGate DDL objects.
SQL> @role_setup.sql。
GGS Role setup script
This script. will drop and recreate the role GGS_GGSUSER_ROLE
To use a different role name, quit this script. and then edit the params.sql script. to change the gg_role parameter to the preferred name. (Do not run the 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:ogg
Wrote file role_setup_set.txt
PL/SQL procedure successfully completed.

Role setup script. complete
Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:
GRANT GGS_GGSUSER_ROLE TO
where is the user assigned to the GoldenGate processes.
SQL>
7、Grant the role that was created (default name is GGS_GGSUSER_ROLE  to all Oracle GoldenGate Extract users.
SQL> Grant GGS_GGSUSER_ROLE to ogg;
Grant succeeded.
SQL>

8、执行@ddl_enable.sql，Run the  ddl_enable.sql  script. to enable the DDL trigger.
   ddl triger 判断在有ddl发生时是否把ddl 发送给extract 进程。
SQL> @ddl_enable.sql
Trigger altered.
9、执行优化脚本。
To improve the performance of the DDL trigger, make the ddl_pin script. part of the database startup。
SQL> @ddl_pin ogg
PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.
SQL>
-------------------安装 sequence 复制支持-------------------------------------------

10、在主端执行下面的命令
GRANT EXECUTE on OGG.updateSequence TO OGG;
11、在备端端执行
GRANT EXECUTE on ogg.replicateSequence TO ogg;
12、在主端执行下面的命令
alter table sys.seq$ add supplemental log data (primary key) columns;
----------------------goldengate  参数配置-------------------------------------
---主端的goldengate配置
13、在主端配置 extract 进程
GGSCI (rac2) 1> edit params ext_test
EXTRACT ext_test
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
DBOPTIONS   ALLOWUNUSEDCOLUMN
USERID ogg, PASSWORD AACAAAAAAAAAAADAHBLDCCIIOIRFNEPB, ENCRYPTKEY default
TRANLOGOPTIONS EXCLUDEUSER ogg
--GETTRUNCATES
REPORTCOUNT EVERY 1 MINUTES, RATE
NUMFILES 5000
DISCARDFILE ./dirrpt/ext_test.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER AT 2:00
WARNLONGTRANS 2h, CHECKINTERVAL 3m
EXTTRAIL ./dirdat/st, MEGABYTES 200
DYNAMICRESOLUTION
TRANLOGOPTIONS CONVERTUCS2CLOBS
TRANLOGOPTIONS RAWDEVICEOFFSET 0
DDL &
INCLUDE MAPPED OBJTYPE 'table' &
INCLUDE MAPPED OBJTYPE 'index' &
INCLUDE MAPPED OBJTYPE 'SEQUENCE' &
EXCLUDE OPTYPE COMMENT &
EXCLUDE OBJNAME "HAOZG.TEST15"
DDLOPTIONS  NOCROSSRENAME  REPORT
TABLE     HAOZG.*;
SEQUENCE  HAOZG.*;

14、在主端配置投递进程
GGSCI (rac2) 2> edit params dp_test
EXTRACT dp_test
RMTHOST 192.168.1.101, MGRPORT 7839, COMPRESS
PASSTHRU
NUMFILES 5000
RMTTRAIL ./dirdat/st
DYNAMICRESOLUTION
TABLE      HAOZG.*;
SEQUENCE   HAOZG.*;
15、在主端添加抽取/投递进程与队列文件
GGSCI>add ext ext_test,tranlog ,begin now
GGSCI>add exttrail ./dirdat/tt,ext ext_test,megabytes 200  -----备注：添加抽取进程，每个队文件大小为200m
GGSCI>add ext dp_test,exttrailsource ./dirdat/tt           -----备注：添加投递进程，从某一个队列开始投
GGSCI>add rmttrail ./dirdat/tt,ext dp_test,megabytes 200   -----备注：投递进程，每个队文件大小为200m
------------------------------灾备端的goldengate 配置
16、在备端添加检查表
GGSCI (haozg) 2> DBLOGIN USERID ogg, PASSWORD AACAAAAAAAAAAADAHBLDCCIIOIRFNEPB , ENCRYPTKEY default
Successfully logged into database.
GGSCI (haozg) 3> ADD CHECKPOINTTABLE ogg.oggchkpt
Successfully created checkpoint table ogg.oggchkpt.
GGSCI (haozg) 4>

17、备端配置复制进程
GGSCI (haozg) 3> edit params rep_test
REPLICAT rep_test
SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
USERID ogg, PASSWORD AACAAAAAAAAAAADAHBLDCCIIOIRFNEPB ,ENCRYPTKEY default
REPORT AT 00:59
REPORTCOUNT EVERY 1 MINUTES, RATE
REPORTROLLOVER AT 02:00
REPERROR DEFAULT, ABEND
NUMFILES 5000
GROUPTRANSOPS 10000
--HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/repylqa.dsc, APPEND, MEGABYTES 200
DISCARDROLLOVER AT 02:00
GETTRUNCATES
ALLOWNOOPUPDATES
DDL include mapped &
EXCLUDE OBJNAME "HAOZG.TEST15"
DDLOPTIONS report
MAPEXCLUDE HAZG.TEST15
MAP HAOZG.*,TARGET HAOZG.*;

18、备端添加复制进程rep_test
GGSCI (haozg) 1> ADD REPLICAT rep_test, EXTTRAIL ./dirdat/tt , EXTSEQNO 0, EXTRBA 0 , CHECKPOINTTABLE ogg.oggchkpt

到此为止 完成了从备端到主端的单向复制配置，也就完成了整个双活配置。

24、启动两边的进程查看进程的状态。
    start ext_test
    start dp_test
    start rep_test
   
    如果启动失败，用 view report ext_test/dp_test/rep_test 查看失败的原因。
   
GGSCI (haozg) 10> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                          
EXTRACT     RUNNING     DP_TEST     00:00:00      00:00:02   
EXTRACT     RUNNING     EXT_TEST    00:00:00      00:00:13   
REPLICAT    RUNNING     REP_TEST    00:00:00      00:00:01   
进程全都起来。
 
25、参数说明，见后续博客。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23062014/viewspace-741698/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23062014/viewspace-741698/

cixian3473
关注
GoldenGate的安装与配置(三)oracle——oracle单向复制（linux-windows）
热爱生活，努力工作
10-23 623
一.在目标库上安装（Win server2008）ogg软件,
oracle goldengate报错解决之OGG-00446、OGG-00529、OGG-00014
weixin_34025051的博客
11-08 2115
OGG测试：无法启动ext进程，报错OGG-00446报错日志【截取重要部分】2016-10-2816:51:40ERROROGG-00446Missingfilenameopeningcheckpointfile. 2016-10-2816:51:40ERROROGG-01668PROCESSABENDING.日志意思很明显：在打开...
Goldengate （DML DDL） 单向/双向复制最佳解决方案
12-12
　Oracle 业界领先的数据同步工具 -- Oracle Golden Gate。Oracle Golden Gate是经客户验证的业界最佳的数据同步工具，能够提供异构环境下数据的实时捕捉，变换和投递，支持异构数据库环境下的数据同步。该产品广泛应用于数据备份与容灾，数据库升级和移植，双业务中心，数据仓库实时数据供给等多种业务场景。
OGG(oracle goldengate)实现oracle到oracle数据DDL同步
weixin_41229271的博客
09-23 1382
注：本篇文章是在已经配置过DML同步或者源端数据库已经开启归档、添加了附加日志等基础上记录的，如未设置，请参考另外一篇：https://blog.csdn.net/weixin_41229271/article/details/101196319 然后再进行下面的步骤。 源端在ogg安装目录下登陆数据库 SQL> @marker_setup.sql Marker setup scr...
运行GoldenGate ddl_setup.sql脚本时报错*** Please move GOLDENGATE to its own tablespace
msdnchina的专栏@JiNan,ShanDong
12-19 5226
运行GoldenGate ddl_setup.sql脚本时报错*** Please move GOLDENGATE to its own tablespace
Oracle Goldengate 双向复制配置
09-05
一、双向复制节点2配置： 1）添加附加的redolog信息 DBLOGIN USERID ogg, PASSWORD Ogg ADD TRANDATA scott.* 2)配置extract
Oracle GoldenGate双向复制配置详解
实现GoldenGate双向复制的关键步骤包括用户配置、数据库端的 Extract 和 Replicat 配置，以及测试阶段。用户配置涉及到同步用户、源数据库用户和目标数据库用户的设定，这些用户需要有足够的权限访问和操作数据。 ...
Oracle Goldengate双向复制配置详解及步骤
- Goldengate的双向复制意味着数据从源端到目标端，以及目标端回写源端的实时同步。配置完成后，Goldengate将自动或根据设定进行数据传输。 整个过程涉及了Oracle数据库的基础配置、日志管理、Goldengate组件的...
Oracle GoldenGate 配置双向同步
最新发布
Ahern_的博客
05-14 1015
注意，数据导入目标端后，在启动replicat（aftercsn）进程必须指定SCN号，目的是从该SCN号开始应用抽取的事务日志。注意：21.3 需要注册进程至数据库，否则启动进程失败。GoldenGate版本：21.3。2、源端根据记录的SCN号导出数据。进程启动成功后即完成单向同步。最后，测试双向复制同步数据。1、记录当前数据库SCN。
Goldengate的安装与配置(配置rac到单实例的同步)
weiwang的专栏
05-06 5989
环境： 源端：11204的双节点rac 目标端：11204的单实例数据库 Goldengate安装包版本： 121210_fbo_ggs_Linux_x64_shiphome.zip   RAC上安装OGG： 1.      在rac两个节点创建ogg安装目录 mkdir /oracle/ogg 2.      设置环境变量 在用户参数文件中添加以下内容： export GG
Goldengate参数规范
weixin_34237596的博客
09-15 476
1.文档综述 1.1.文档说明 本文档规定了在实施Goldengate时,各个进程需要配置的参数. 该参数模板适合于Goldengate11.2.1.0版本； **注：本文档为Goldengate实施规范系列文档内容之一。在Goldengate的实施过程中，需要严格遵循系列实施规范。 **注：无主键，大事务，这些都是OGG支持有问题的，需要进行应用调整，否则即使按照规范执行，...
Oracle GoldenGate 安装配置全记录
曾经是个DBA
11-01 1429
1 安装OGG 1.1 上传OGG压缩包 解压压缩包   1.2 配置环境变量 .bash_profile中添加如下内容 export LD_LIBRARY_PATH=$ORACLE_HOME/lib   1.3 创建OGG工作目录 GGSCI (rac01) 3> create subdirs   Creating subdirectories under current
oraclevirtual的ubuntu18下的双向复制粘贴
R_Allison的博客
05-31 2112
设置虚拟机为“双向”共享粘贴给虚拟机安装一下增强功能。需要启动虚拟机，安装菜单项“设备”中的最后一项。常规高级里共享粘贴板已经选中双向，但还是不能复制粘贴，这时到虚拟机设置-存储-控制器SATA-勾选"使用主机输入输出(I/O)缓存"，再同样在存储-控制器SATA-点击***.vdi-勾选"固态驱动器"，重启虚拟机就可以了～存储-控制器SATA-点击***.vdi-勾选"固态驱动器"安装完增强功能...
Oracle goldengate 搭建配置（精简版）
ZZT_2009
03-21 459
【该文章主要面向Oracle goldengate初学者的搭建配置，文中删去了不需要的多余参数，让初学者一目了然一学就会】 ★实验环境 1。数据库版本 源端：11gR2 目标端：11gR2 2.操作系统版本 源端：RedHat 6.4 目标端；RedHat 6.4 ★关闭数据库的recyclebin（两节点） (10g必须，11g可选)同步DDL要求关闭10g中的回收站特性 SQL> ...
OGG参数详解
热门推荐
Super菜的专栏
06-16 1万+
http://blog.itpub.net/26442936/sid-172198-list-1/ http://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters.htm#GWURF394 Oracle GoldenGate sample parameter files  总结： 一直以来对oracle gol
oracle golden gate安装,【学习笔记】Oracle goldengate安装配置过程问题及解决办法
weixin_32083569的博客
04-05 376
【学习笔记】Oracle goldengate安装配置过程问题及解决办法时间:2016-12-11 18:54来源:Oracle研究中心作者:网络点击:次天萃荷净Oracle研究中心学习笔记：分享一篇关于Oracle数据库goldengate的文章，文章详细记录了goldengate的配置过程。本站文章除注明转载外，均为本站原创： 转载自love wife & love ...
(一)OGG的安装与配置,并实现单向DML复制操作
翔之天空的专栏
07-28 1490
实验目的：在两台虚机模拟同平台同版本上面安装和配置OGG，并实现简单的DML复制。 实验环境：64位系统 操作系统：rhel6.6-x86_64 数据库：oracle_11.2-x86-64 goldengate：for_11g_x64 实验步骤： 1、 配置源端和目标端ip： 源端： [root@oggsource ~]# cat /etc/hosts ...
oracle 数据库高可用之OGG的基础配置
heguanghuicn的博客
03-02 9649
前言：本文主要内容为当初刚开始接触OGG高可用架构时的部署，包含了我看到的一些比较好的文章的引用。目的都是为了让更多同学能更快的掌握相关知识，如果原创作者对此觉得损害了您的权益请留言。目录：理论、概念基础实验理论、概念，有助理解OGG的理解。学习必备。感谢原文作者，原文地址：飞机票理论、概念一. OGG 概述 OGG 全称Oracle Golden Gate。历史：Golden Gate公司于19...
OGG到OGGAdapter配置详情-从Oracle直接抽取成csv文件
dimawei2225的博客
11-01 932
Oracle Golden Gate是Oracle旗下一款支持异构平台之间高级复制技术，是Oracle力推一种HA高可用产品，简称“OGG”，可以实现Active-Active 双业务中心架构 1.1. 目的本文档描述OGG的相关配置和实际操作教程，旨在能够初步了解掌握OGG的原理和使用方法1.2. 定义、业务术语、缩略语Oracle Golden Gate有源端和目标端，源端捕...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值