Using OGG, one-way data synchronization between two Oracle databases

Configuration: source database 100.100.100.21 Instance name dbsid2 target database 100.100.100.41 Instance name db1 lab goal: source database in

Configuration: source database 100.100.100.21 Instance name dbsid2 target database 100.100.100.41 Instance name db1 lab goal: source database in

Configuration: source database 100.100.100.21 Instance name dbsid2

Target database 100.100.100.41 Instance name db1

Tutorial objective: to synchronize the scott user emp table in the source database to the test table in the target database scott

The installation package is the ogg1121020.fbo_ggs_linux_x64_ora10g_64bit.zip file.

Decompress the package, and then decompress tar-xvf fbo_ggs_Linux_x64_ora10g_64bit.tar-C/Oracle/ogg/

Data synchronization between Oracle GoldenGate databases on Heterogeneous OS

GoldenGate synchronizes Oracle Data to GreenPlum

1. source database (dbsid2) Configuration:

(1) user permission: grant dba to scott

(2) Open the archive Mode

(3) additional logs:
Alter database add supplemental log data;

Alter database force logging;

(4) Add the db1 information of the target database to tnsnames. ora.

2. target database (db1) Configuration:

(1) scott creates an empty table test with the same table structure as emp.

(2) Open the archive Mode

(3) additional logs:

Alter database add supplemental log data;

Alter database force logging;

(4) add the information of the source database (dbsid2) to tnsnames. ora.

3. Install the source database server goldengate

(1) decompress the package to the/oracle/ogg target

(2) Run./ggsci

(3) create a subdirectory: GGSCI (host2) 1> create subdirs

Creating subdirectories under current directory/oracle/ogg

Parameter files/oracle/ogg/dirprm: already exists

Report files/oracle/ogg/dirrpt: created

Checkpoint files/oracle/ogg/dirchk: created

Process status files/oracle/ogg/dirpcs: created

SQL script files/oracle/ogg/dirsql: created

Database definitions files/oracle/ogg/dirdef: created

Extract data files/oracle/ogg/dirdat: created

(4) configure the Port parameters for character Management

GGSCI (host2) 6> edit params mgr

Input: PORT 7809 and save

Check input:

GGSCI (host2) 7> view params mgr

PORT 7809

(5) Start mgr:

GGSCI (host2) 8> start mgr

MGR is already running.

GGSCI (host2) 9> info mgr

Manager is running (IP port host2.7809 ).

4. Install goldengate on the target database server (same as the source database server)

(1) decompress the package to the/oracle/ogg target

(2) Run./ggsci

(3) create a subdirectory: GGSCI (host2) 1> create subdirs

Creating subdirectories under current directory/oracle/ogg

Parameter files/oracle/ogg/dirprm: already exists

Report files/oracle/ogg/dirrpt: created

Checkpoint files/oracle/ogg/dirchk: created

Process status files/oracle/ogg/dirpcs: created

SQL script files/oracle/ogg/dirsql: created

Database definitions files/oracle/ogg/dirdef: created

Extract data files/oracle/ogg/dirdat: created

(4) configure the Port parameters for character Management

GGSCI (host2) 6> edit params mgr

Input: PORT 7809 and save

Check input:

GGSCI (host2) 7> view params mgr

PORT 7809

(4) Start mgr:

GGSCI (host2) 8> start mgr

MGR is already running.

GGSCI (host2) 9> info mgr

Manager is running (IP port host2.7809 ).

5. Configure the source database server (dbsid2) Transfer Process extract

(1) Add a process named source1

GGSCI (host2) 19> add extract source1, sourceistable

EXTRACT added.

(3) modify the source1 Parameter

GGSCI (host2) 20> edit params source1

Add and save

Extract source1

Setenv (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)

Userid scott, password tiger