Sample Header Ad - 728x90

Upgrade Oracle DB from 12C to 19C with minimum downtime

0 votes
1 answer
1231 views
We are planning to apply the below steps --> 1. Export Live DB setup on the Oracle version 12C 2. Import on the new DB setup on version 19C 3. At this point, V12, and V19 schema structures will be exactly the same (till here we tested and it works fine) 4. Add a new data guard in the DB running on Oracle v12 to point to the upgrade DB setup on version 19C 5. **Once the data guard is ready and DB import completes, we point the data guard to the upgrade DB and wait for sync complete** Can you please review and confirm if this is achievable? At this time we plan to use Data guard and if it is not possible then we will use the golden gate.
Asked by rajan dawra (1 rep)
Jan 23, 2023, 02:59 AM
Last activity: Jun 18, 2023, 01:02 PM