Oracle itself publishes comprehensive advice on different database
upgrade/migration options:
https://mikedietrichde.com/slides/
And tools to automate this process:
https://www.oracle.com/database/technologies/rac/zdm.html
Migrating using GG - it is quite a labour intensive process to prepare and
you need to have good knowledge about how the application works - it is not
for everyone/everything.
On Tue, Nov 17, 2020 at 12:05 AM Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Hi Everyone
I had 160 Tb Database in 12.2 and had to upgrade to 19c. Can you please
suggest the best option that can help to update with small downtime and
also option to rollback for any failure without going for big Restore that
can take day for the restore. Some details for the database and option that
can be used are
1. 12.2 is CDB with one PDB that has to be upgraded
2. ASM storage has additional 200 Tb available to be used for this
upgrade purpose ,if required for any option
3. It is Exadata with two node
4. Environment also has Dataguard on another Data Center with same
hardware like primary
5. Golden Gate license is available for any option that can save
downtime
Thanks for your time and suggestion
Sanjay