Hello all!
I'm looking for information & advise on the best way to migrate from a hardware Oracle 19c Data Guard server pair to an Oracle 19c Cloud Data Guard server pair. Our configurations currently are:
HW_Primary, HW_Standby
======================
Currently Production DB
Cloud_Primary, Cloud_Standby
===========================
Contains a Training DB.
Currently is in use for server configuration and remote site connectivity testing.
My plan at the moment is to:
- Break connection between HW_Primary & HW_Standby.
- Break connection between Cloud_Primary & Cloud_Standby.
-Take a full backup of HW_Primary (DataPump or Level 0 Rman - preferences).
- Restore to Cloud_Primary .
- Bring up Cloud Primary for in-house data verification.
- Restore Cloud_Standby using Recover Standby database from service Cloud_Primary.
- Next would be backing up Cloud_Primary.
(Side question: Is there a way to back up the Cloud_Standby while Dataguard is running?)
- And finally - Reverification of the data by remote sites.
I'm hoping this makes sense and will work. Please let me know what you think and feel free to make suggestions for improvement to this plan.
Thanks in Advance!
Have a terrific day!
John