The example upgrade #3 was a migration-style upgrade from 10.2 to 11.1.0.7. A migration is different type from an import\/export upgrade. It changes a lower version database into a higher version database. If you decide you want to go back to the previous version, depending on what\u2019s happened since you migrated, you\u2019ll have to do take certain actions. They might be relatively simple or they could involve restoring the whole database from backup. This upgrade type is also referred to as an \u201cin place\u201d upgrade, as it operates on your actual current database.<\/p>\n
The main good things about migration upgrades are that you don\u2019t have to make room for two databases during the upgrade process, and that the process can run relatively quickly. The main not-good things about migration upgrades are that retreating back to the previous state of your database could be tricky and will take some time, and that, in my opinion, it takes more painstaking work to prepare for a migration upgrade than an import\/export upgrade.<\/p>\n
Overall, example upgrade #3 went smoothly.<\/p>\n
Only a couple of weird things happened with this upgrade. A couple of materialized views were invalid because of some SQL that was valid in 10g but not 11g. We didn\u2019t see the actual SQL, but we heard from the application administrator that 11g was complaining about a selected column not being uniquely identified.<\/p>\n
Also, the STATSPACK package was invalid and wouldn\u2019t recompile, and I ended up dropping and recreating it; Oracle tech support didn\u2019t seem to have a better idea. If the client had cared about their STATSPACK snapshot history, I might have been in some trouble \u2013 I didn\u2019t research if the format is the same in 10g as 11g.<\/p>\n
Application performance was about the same as before the upgrade.<\/p>\n","protected":false},"excerpt":{"rendered":"
The example upgrade #3 was a migration-style upgrade from 10.2 to 11.1.0.7. A migration is different type from an import\/export upgrade. It changes a lower version database into a higher version database. If you decide you want to go back to the previous version, depending on what\u2019s happened since you migrated, you\u2019ll have to do […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"_links":{"self":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/81"}],"collection":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=81"}],"version-history":[{"count":2,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/81\/revisions"}],"predecessor-version":[{"id":266,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/81\/revisions\/266"}],"wp:attachment":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=81"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=81"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}