I want use goldengate to migrate and upgrade non-ebs oracle 12c database from solaris to linux with zero downtime regardless of database size 15 TB. Is it possible?
Source database : - Oracle 11g (11.2.0.4)
Source OS : - Solaris 10
Target Database : - Oracle 12c (12.1.0.1)
Target OS : - Linux 6
Because what I knew is that for migration goldengate can be used for zero downtime but for upgradation of database downtime is required.
Can you please answer this? Also guide me the steps to achieve the same?
Also I have alternate approach as I am having another new server : -
1) On old server the database remain as it is without downtime.
2) On New server i will create a Clone.
3) I will upgrade the clone to 12c but users are still doing transactions on my old server db. So it will data which my clone will now.
4) then with the help of goldengate I will transform/migrate all data which was inserted/updated on old server db to clone.
5) At the end i will change the pointer to new server 12c db and shutdown/remove the old server db.
So i have done migration and upgradation with the help of Goldengate with zero downtime as Goldengate can be used to migrate/transform data across cross-plaforms.
Is this alternate approach correct if not Why?
Please do help me to understand the same.
Regards