Oracle Golden Gate Replication Step By Step

I have done 2000 table replication with goldengate or sql server replication tool for dwh databases in many clients.

Oracle golden gate replication step by step.

For non rac database active passive step 0 hardware and o s configuration. Switch the database from noarchivelog mode to archivelog mode. Runs on all servers. Vijay agrawal principal software engineer.

Step by step installation of oracle golden gate one way replication. Oracle 12c configure step by step goldengate bidirectional method description oracle goldengate introduce bidirectional replication is also called as active active replication. Now we assume that the gg is installed and we have two servers on which oracle databases are running the gg manager process is up and running on both these servers as gg is installed on both these servers the tcp ip network connectivity open from source server to target server s manager port and basic understanding of gg replication flow. Enabling oracle database to support golden gate root hostname bin sqlplus sys as sysdba.

The replication concurrently captures data from two or more databases to synchronize the data. Source system goldengate extract group capture the changes information from either redo log files or archivelog and forward oracle goldengate trails to the remote system. Oracle 18c configure step by step goldengate unidirectional method. Oracle 12c configure step by step goldengate unidirectional method description in oracle goldengate unidirectional configuration allows data workflow in one direction from source to target only.

Step 3 preparing source database for replication. I am founder of sysdbasoft it and it tutorial and certified expert about oracle sql server database goldengate exadata machine oracle database appliance administrator with 10 years experience i have oca ocp oce rac expert certificates i have worked 100 banking insurance finance telco and etc. Download 12c golden gate software 5. This document describes how to install oracle 12c golden gate and how to configure the replication.

Clients as a consultant insource or outsource i have done 200. Install 12 1 0 2 database in both source and target servers 3. Step 2 gg software installation. Install linux servers both source and target 2.