0

We have a plan to make a copy of our PRD environment into our QA environment to get update data for testing by means of transporting the PRD DBF files over into our QA system.

However there is a discrepancy between the Oracle versions on both systems, on our PRD the Oracle database is 11.2.0.4 whereas in our QA environment Oracle database is newer at 12.2.0.1.

Would the QA environment having a more recent number be able to read DBF data files generated from an older version?

We will be moving all the control files along with the data files too.

Any advice from someone who've pulled such a stun before much appreciated :)

  • Sure you can, but the first thing you will need to do is upgrading the database from 11.2.0.4 to 12.2.0.1. – Balazs Papp Mar 12 at 10:40
  • So you want to replace your QA database by a copy of the PRD database and this copy should be migrated to 12c? – miracle173 Mar 13 at 1:09
  • @miracle173 yes, we are currently testing out 12.2.0.1 in QA now but out of the blue we also need to have the data in QA refreshed with Production data. – wshyang Mar 13 at 1:10
1

I assume that you will eventually upgrade production to 12.2. If it were me, I would have this scripted. Drop the development database, change /etc/oratab file on the development database to be 11.2.0.4 if you are using Linux/Unix, otherwise drop recreate the windows service using oradim. Clone from prod to development as 11.2.0.4. Do a silent upgrade of the development database using dbca, and be ready to repeat as you get closer to the migration date. When you practice the upgrade procedure enough to work out the bugs, and have tested the performance enough to know that you won't have performance issues in production, you are ready to do the upgrade in prod.

There are some automatic tuning parameters in 12.2 that you may need to disable, depending on how your application performs.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.