Use the Streams Pool Advisor for versions under 19c

Streams Pool Advisor

For versions 19c or higher use the new utl_rpadv

Not sure about if this can be used for versions earlier.....will check it out soon this is a much longer line as a test this is a test this is a test this is a test

UTL_RPADV

Enable DDL Replication Old Method

Conflict Detect and Resolve

664 Errors in GoldenGate

Multi-Tenant Environment GoldenGate

Snapshot too old GoldenGate

Identify v$transactions

 

Identify any in-flight transactions prior to starting extract and export for GoldenGate

TRN4845 - Oracle GoldenGate Auto Conflict Detection and Resolution for Active-Active_1568575500368001GJNU

Setup includes

VM Hub setup can be used

Either VirtualBox and/or VMWare can be used

Setup the hub according to MRC standards with software installs as well as client installs

Links to scripts and other posts will be here soon......

Ensure the timezone is correct between the servers otherwise the testing will not complete

Ensure the supplemental logging is complete

The setup includes 12.3.0.1 GoldenGate (and patches) installed on the hub server to talk to the 11g (11.2.0.3.0) database

11g Client Download

it also includes 19c GG setup to talk to the 19c database

Extracts are setup in the 12c GG home to talk to 11g and share a common trail file location

Make sure the mrcenv file being used allows for setup of the environment for both 12c GG and 19c GG

mrchost_mrcenv can be used for both environments

Once completed with this setup make a snap like I did in order to make the config easy to propagate

Feb 5th 2020

Veridata Data Sheet

Ready for Action?

LET'S GO!
Copyright 2024 IT Remote dot com
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram