Skip to main content
Database Administrators

Return to Question

Lowered the size of headings, they were disproportionate. Removed thanks, geeting and signature
Source Link
edit approved Mar 10 at 19:15
Rohit Gupta
edit approved Mar 10 at 19:15
Rohit Gupta
  • 1.8k
  • 7
  • 17
  • 20

I'm looking for information & adviseadvice 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

HW_Primary, HW_Standby

Currently Production DB

Cloud_Primary, Cloud_Standby

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

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

I'm looking for information & advice 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.

edited tags
Link
P_J
P_J
  • 1
  • 1
Source Link
P_J
P_J
  • 1
  • 1

Migration of Data Guard HW Servers to Cloud Servers

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