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