Oracle 18c configure step by step goldengate unidirectional method.
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.
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.
Install linux servers both source and target 2.
Step by step installation of oracle golden gate one way replication.
Enabling oracle database to support golden gate root hostname bin sqlplus sys as sysdba.
And replication group apply.
Switch the database from noarchivelog mode to archivelog mode.
Step 1 database pre requisites.
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.
Oracle 12c configure step by step goldengate bidirectional method description oracle goldengate introduce bidirectional replication is also called as active active replication.
Install 12 1 0 2 database in both source and target servers 3.
An active active replication is used for high availability zero downtime migration.
Download 12c golden gate software 5.
The replication concurrently captures data from two or more databases to synchronize the data.
Clients as a consultant insource or outsource i have done 200.
For non rac database active passive step 0 hardware and o s configuration.
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.
Step 2 gg software installation.
Vijay agrawal principal software engineer.
Runs on all servers.