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 10K+ times! This question is

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

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.