GoldenGate performs two-way Oracle-Oracle replication without using a Data Pump

Configure the database environment, goldengate users, and install goldengate. For details, refer to the configuration required to complete two-way Oracle-Oracle replication without using the Data Pump: -- Here I only configure to synchronize the test1 table of the test user.
1. Configure the master database: ##### configure Extract
Perform the following operations in sequence:
Add extract ext1, tranlog, begin now
Add exttrail/u01/ogg/dirdat/lt, extract ext1

Edit params ext1
In the edit window that appears, write the following: ---- Here, users created for OGG are used to log on, and check the path.
Extract ext1
Userid ogg, password ogg
Rmthost 192.168.1.213, mgrport 7809
Rmttrail/u01/ogg/dirdat/lt
Table test .*;
##### Configure Replicat
Edit params./GLOBAL
Enter the following two lines in the editing window:
GGSCHEMA ogg
CHECKPOINTTABLE ogg. checkpoint

Dblogin userid ogg, password ogg
Add checkpointtable ogg. checkpoint
Add replicat rep2, exttrail/u01/ogg/dirdat/at, checkpointtable ogg. checkpoint

Edit params rep2
In the pop-up editing window, enter: --- here, only the test1 table of the test user is set to be synchronized. Here, the user and table name are created in the next test.
You can use the handlecollisions parameter to prevent the receiving process from being suspended because the data in the table to be synchronized between the master database and the target database is inconsistent.
Replicat rep2
Handlecollisions
ASSUMETARGETDEFS
Userid ogg, password ogg
Discardfile/u01/ogg/dirdat/rep2_discard.txt, append, megabytes 10
Map test. test1, target test. test1;

The process after configuration is completed is as follows: -- note that the Process status here is after startup. -- It is recommended that the master database and target database be started after the process is configured.
GGSCI (bys001.oel.com) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
Extract running EXT1 00:00:00 00:00:00
Replicat running REP2 00:00:00 00:00:02

2. Configure the target database ##### configure Replicat
Edit params./GLOBAL
Enter the following two lines in the editing window:
GGSCHEMA ogg
CHECKPOINTTABLE ogg. checkpoint
Run the following commands one by one:
Dblogin userid ogg, password ogg
Add checkpointtable ogg. checkpoint
Add replicat rep1, exttrail/u01/ogg/dirdat/lt, checkpointtable ogg. checkpoint

Edit params rep1
In the pop-up editing window, enter the following: --- Here I only set the table test1 for synchronizing the test user -- here the user and table name are created in the next test.
Replicat rep1
Handlecollisions
ASSUMETARGETDEFS
Userid ogg, password ogg
Discardfile/u01/ogg/dirdat/rep1_discard.txt, append, megabytes 10
Map test. test1, target test. test1;

##### Configure Extract
Run the following commands in sequence:
Add extract ext2, tranlog, begin now
Add exttrail/u01/ogg/dirdat/at, extract ext2

Edit params ext2
Write Data in the open edit window:
Extract ext2
Tranlogoptions excludeuser ogg
Userid ogg, password ogg
Rmthost 192.168.1.211, mgrport 7809
Rmttrail/u01/ogg/dirdat/
Table test .*;
The process after configuration is completed is as follows: -- note that the Process status here is after startup.
GGSCI (bys2.oel.com) 32> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
Extract running EXT2 00:00:00 00:00:07
Replicat running REP1 00:00:00

For more details, please continue to read the highlights on the next page:

 

Management OGG-HA in RAC Environment

Configure OGG synchronization in RAC Environment

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

1 2 Next Page