Skip to Main Content
  • Questions
  • Data Guard between the Oracle versions 12C and 19C

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Rajan.

Asked: January 19, 2023 - 8:41 pm UTC

Last updated: January 23, 2023 - 7:13 am UTC

Version: Oracle 12C

Viewed 100+ times

You Asked

We have an application running on Oracle version 12C which has a data guard to sync it with the Disastrous recovery DB running on the same Oracle version 12C. I would like to know if I can use another one more data guard to migrate the data from this DB running on Oracle version 12C to the Oracle DB setup on Oracle version 19C?

We plan to do this:

1. Take a live backup of the current primary DB running on the Oracle version 12C
2. Import it on the new DB setup on the Oracle version 19C
3. On completion of import, add another data guard on the primary DB to sync it with the new DB
4. Stop Primary DB and connect the application to the New DB

Please Note: Apart from the Data guard part we have tested exporting the DB from Oracle version 12C, importing the DB setup on Oracle version 19C, and connecting the application to the new DB, and it works fine.

The purpose of this exercise is to reduce application downtime.

Thank you!

Warm Regards,
Rajan

and Connor said...

The best way to reduce application downtime would what we call "Transient Logical Standby" which gives a tiny amount of downtime just during switch over.

Check out this video by the upgrade/availability team

https://www.youtube.com/watch?v=MHQ3MhqHXbg&t=2584s

with accompanying slides here

https://dohdatabase.files.wordpress.com/2021/10/emea10_zerodowntimeoperations.pdf