Hello experts,
We are planning to change target/replicate side host platform of Goldengate and target DB (Solaris to Linux) and also we will upgrade GG from 12.1.2.1.0 to 19.1.0.0.4.Right now in source side we have 19c db and GG setup with version 19.1.0.0.
and target side 12.1.0.2 db with 12.1.2.1.0.
Since there is no change in source side so we have to consider minimal downtime for source side.I have thought like below.Please comment and suggest if you think differently.
Since there is no change in extract path I will not touch any parameter file in extract process but will change parameter file fro pump process.
- Install 19c Goldengate binary in in new Linux platform with only manager process running
- Delete existing pump process in source solaris host
- Update pump process parameter file with correct remote host,mgr port and trail file path in source
- Add extract pump process with correct extttrailsource in source
- Add remote trail with correct path
- Now all changes from source db will be extracted and pumped to remote trail file in remote Linux host where 19c Goldengate is running.
- Complete db migration to Linux host
- Now configure replicate process in Linux host like below
ADD replicat group_name BEGIN , EXTSEQNO sequence_number/timestamp
Please comment/suggest on these steps.
Regards
Dhritiman Deb