Build a one-way replication test environment from Oracle to Oracle

Set up a one-way replication test environment from Oracle to Oracle, configure a management process on the Source side, add an Extract process, and add a local queue path

Set up a one-way replication test environment from Oracle to Oracle, configure a management process on the Source side, add an Extract process, and add a local queue path

Test environment:

OS: RedHat 5.4 64bit

DB: Oracle 11.2.0.3 64bit

The following is a typical GoldenGate Configuration:

In
In

GoldenGate unidirectional table DML Synchronization

Oracle GoldenGate series: restoration principles of Extract processes

Oracle GoldenGate installation Configuration

OGG-01004 OGG-1296 error for Oracle goldengate

Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations

Build a GoldenGate bidirectional replication environment from Oracle to Oracle

[Root @ gg2 ~] # Uname-

Linux gg2 2.6.18-164. el5xen #1 SMP Tue Aug18 15:59:52 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

[Root @ gg2 ~] # Cat/etc/redhat-release

Red Hat Enterprise Linux Server release 5.4 (Tikanga)

SQL> select * from v $ version whererownum = 1;

BANNER

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

Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0-64bit Production

1.2 install GG

[Root @ gg2 ~] # Su-oracle

Gg2:/home/oracle> mkdir/u01/ggate

Gg2:/home/oracle> cd/u01

Gg2:/u01> ls

App ggate

Fbo_ggs_Linux_x64_ora11g_64bit.tar OGG_WinUnix_Rel_Notes_11.1.1.1.0.pdf

Fbo_ggs_Linux_x64_ora11g_64bit.zip README.txt

Gg2:/u01> tar xvffbo_ggs_Linux_x64_ora11g_64bit.tar-C/u01/ggate

1.3 add Environment Variables

Add the following content to the/home/oracle/. bash_profile file:

Export PATH =/u01/ggate: $ PATH

ExportLD_LIBRARY_PATH =/u01/ggate: $ LD_LIBRARY_PATH

Export GGATE =/u01/ggate

Gg2:/home/oracle> source/home/oracle/. bash_profile

Gg1:/u01/ggate> ggsci

Oracle GoldenGate Command Interpreter forOracle

Version 11.1.1.1OGGCORE _ 11.1.1 _ PLATFORMS_110421.2040

Linux, x64, 64bit (optimized), Oracle 11gon Apr 21 2011 22:42:14

Copyright (C) 1995,201 1, Oracle and/or itsaffiliates. All rights reserved.

GGSCI (gg1) 1> create subdirs

Creating subdirectories under currentdirectory/u01/ggate

Parameter files/u01/ggate/dirprm: created

Report files/u01/ggate/dirrpt: created

Checkpoint files/u01/ggate/dirchk: created

Process status files/u01/ggate/dirpcs: created

SQL script files/u01/ggate/dirsql: created

Database definitions files/u01/ggate/dirdef: created

Extract data files/u01/ggate/dirdat: created

Temporary files/u01/ggate/dirtmp: created

Encrypted data files/u01/ggate/dirver: created

Encrypted data Lock files/u01/ggate/dirver/lock: created

Upload data Out-Of-Sync files/u01/ggate/dirver/oos: created

Export data Out-Of-Sync XML files/u01/ggate/dirver/oosxml: created

Invalid Data Parameter files/u01/ggate/dirver/params: created

Invalid Data Report files/u01/ggate/dirver/report: created

Upload data Status files/u01/ggate/dirver/status: created

Export data Trace files/u01/ggate/dirver/trace: created

Stdout files/u01/ggate/dirout: created

GGSCI (gg1) 2>

GoldenGate captures the source database redo logs for analysis and applies the obtained data to the target database for data synchronization. Therefore, the source database must be in archive mode, and additional logs and forced logs must be enabled.

2.1 archive mode, additional logs, and forced logs

-- View

SQL> select log_mode, supplemental_log_data_min, force_logging from v $ database;

LOG_MODE SUPPLEME

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

ARCHIVELOG NO

-- Modify

(

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog;

SQL> alter database open;

(

SQL> alterdatabase force logging;

(

SQL> alterdatabase add supplemental log data;

If yes