Oracle goldengate 11g one-way DDL configuration in combat

In the serious study of goldengate enterprise-level operation, the focus is on the understanding of the Ogg several processes, combined with the understanding of the principle, in the whole experiment nearly two days, after repeated configuration four times, finally configured successfully. This article after many times to configure successful practice, there are many details need to improve.

Directory

================================

I. Environment preparation and installation of Goldengate

1. Database Preparation

2. Download the Ogg software and unzip the installation

3. Prepare OGG Environment variables

4. Configure logging mode

5. Create Goldengate user account

6. Install goldengate Software

7. Configuration source, target database consistent

Second, goldengate DML synchronization source-side configuration

1. Source Mgr Process

2. Configure the Extract Process group

3. Configure the pump process group

Third, goldengate DML synchronization target-side configuration

1. Target-side MGR Process

2. Add a checklist

3. Configure target-side Peplicat process Group

4. Can view checkpoint status

5. DML Configuration Test

Iv. goldengate DDL Synchronization Configuration

1. Source-side support for DDL replication run scripts

2. Modifying params files for source-side extract processes

3. Modify the params file for the target-side replicat process

4. Test

=======================================

Goldengate several important process introduction:

1. Manager management processes Open at both ends, monitor and restart other processes, allocate data to store and report errors and events;

2, the extract process from the log to crawl and transfer to the target-side transaction data;

3. The Server collector process accepts data at Target (accepted) and writes trail files;

4, Replicat process reading trail file, and applied to the Traget database;

5, Trail file GG own capture information file, is an OS file, stored in the./dirdat/, named after X00000, n order 1,2,3 ... This file is automatically deleted with the configurable parameters.

I. Environment preparation and installation of Goldengate

1. Database Preparation

1) Source Server

IP Address: 192.168.14.150

Database: 10.2.0.5 bit

Sid:orcl

Operating system version: Oracle 5.4 bit

Ogg version: Fbo_ggs_linux_x64_ora10g_64bit.tar

Note: The prerequisite is that the database has been ready for installation.

2) Target server

IP Address: 192.168.14.151

Database: 10.2.0.5 bit

Sid:slave

Operating system version: Oracle 5.4 bit

Ogg version: Fbo_ggs_linux_x64_ora10g_64bit.tar

Note: The prerequisite is that the database has been ready for installation.

2. Download the Ogg software and unzip the installation

1) Source Server

Mkdir-p/u01/app/oracle/ogg

Unzip Fbo_ggs_linux_x64_ora10g_64bit.zip

TAR-XVF fbo_ggs_linux_x64_ora10g_64bit.tar-c/u01/app/oracle/ogg/

Chown-r Oracle:oinstall/u01/app/oracle/ogg

2 The target server has to be configured

Mkdir-p/u01/app/oracle/ogg

Unzip Fbo_ggs_linux_x64_ora10g_64bit.zip

TAR-XVF fbo_ggs_linux_x64_ora10g_64bit.tar-c/u01/app/oracle/ogg/

Chown-r Oracle:oinstall/u01/app/oracle/ogg

3. Prepare OGG Environment variables

#源服务器, and target servers are configured

$ vi/home/oracle/.bash_profile

Add the following line:

Export ggate= $ORACLE _base/ogg

Active environment variable

Source/home/oracle/.bash_profile

4. Configure logging mode

# source server, target server not configured (not bidirectional)

1) View the regulation and log mode

Sqlplus/as SYSDBA

Select log_mode,supplemental_log_data_min,force_logging from V$database;

2) configured as the Regulation mode

Shutdown immediate;

startup Mount;

ALTER DATABASE Archivelog;

ALTER DATABASE open;

Alter system set log_archive_dest_1= ' location=/u01/archive ' Scope=both;

3 Configure logging mode (open mandatory and supplemental log mode)

ALTER DATABASE add supplemental log data;

ALTER DATABASE force logging;

4 View Configuration results:

Sql> select log_mode,supplemental_log_data_min,force_logging from V$database;

Log_mode Suppleme for

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

Archivelog Yes Yes

5. Create Goldengate user account

1) Source Server

Su-oracle

Sqlplus/nolog

Conn/as Sysdba;

Create tablespace tbs_ogg datafile '/u01/app/oracle/oradata/orcl/tbs_ogg.dbf ' size 10m autoextend on next 10m;

Create user ogg identified by ogg default tablespace tbs_ogg temporary tablespace TEMP Quota Unlimited on tbs_ogg;

Grant Connect,resource to Ogg;

Grant create session,alter session to Ogg;

Grant Select any Dictionary,select any table to Ogg;

Grant alter any table to OGG;

Grant Flashback any table to Ogg;

Grant execute on Dbms_flashback to Ogg;

2) Target server

Su-oracle

Sqlplus/nolog

Conn/as Sysdba;

Create tablespace tbs_ogg datafile '/u01/app/oracle/oradata/orcl/tbs_ogg.dbf ' size 10m autoextend on next 10m;

Create user ogg identified by ogg default tablespace tbs_ogg temporary tablespace TEMP Quota Unlimited on tbs_ogg;

Grant Connect,resource to Ogg;

Grant create session,alter session to Ogg;

Grant Select any Dictionary,select any table to Ogg;

Grant alter any table to OGG;

Grant Flashback any table to Ogg;

Grant execute on Dbms_flashback to Ogg;

Grant insert any table to OGG;

Grant Delete any table to Ogg;

Grant update any table to Ogg;

6. Install goldengate Software

(1) Source server, and target server are configured

Su-oracle

Cd/u01/app/oracle/ogg

./ggsci

Ggsci (test) 1> Create Subdirs

Creating subdirectories under current Directory/u01/app/oracle/ogg

Parameter files/u01/app/oracle/ogg/dirprm:created

files/u01/app/oracle/ogg/dirrpt:created

Checkpoint files/u01/app/oracle/ogg/dirchk:created

Process Status files/u01/app/oracle/ogg/dirpcs:created

SQL Script files/u01/app/oracle/ogg/dirsql:created

Database Definitions files/u01/app/oracle/ogg/dirdef:created

Extract Data files/u01/app/oracle/ogg/dirdat:created

Temporary files/u01/app/oracle/ogg/dirtmp:created

Veridata files/u01/app/oracle/ogg/dirver:created

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/