![]() ![]() The steps to un-install and roll back patches are documented in the readme for the patch in question.įailure to un-install and roll back patches can result in a failure to downgrade including dictionary objects that cannot be re-validated. If there are any patches applied on the source database running from the upgraded home, they need to be rolled back before beginning the downgrade process. This is because in the upgrade process the compatible parameter is set to a minimum 11.0.0. Downgrade can be done only to Direct upgrade versionĮven though direct upgrade is possible for 10.2.0.5, downgrade is not applicable to 10.2.0.5. Downgrade is possible to these versions except 10.2.0.5.įor example, if you upgraded from Oracle 11.1.0.6 to Oracle 12c (12.1.0) by applying intermediate patch 11.1.0.7, then you can not downgrade to Oracle 11.1.0.6. It is not intended to back out from a failed upgrade. You can only downgrade to the release and patch level you upgraded from.ĭirect upgrade is possible for release 10.2.0.5, 11.1.0.7, or release 11.2.0.2 or higher. This process is intended to downgrade a database that was successfully and upgraded to 12c. If you have uninstalled the Oracle executable's to which you want to downgrade, please re-install the oracle binaries to the correct version/patch level for the downgrade. Oracle binaries of the release/version to which you are downgrading should be available/installed on the server before you start the downgrade process. This article does not discuss the use of Export/Import, Data Pump or other methods to move data from one version to another. ![]() The process discussed in this article is a script based downgrade. ![]() This is usually sufficient.Īdditional corrective actions (such as de-install / re-install or re-upgrade to current patchset levels) may be needed to settle left-over issues after a downgrade. If the goal is to have the instance back EXACTLY as it was pre-upgrade then other processes including a recovery to just before the upgrade should be used. ![]() The downgrade process allows users to open and access the database instance in the previous version. Depending on the versions involved, the upgrade process makes changes that are not reversible. An important note is that when downgrading a database instance from the current version to the version prior to the upgrade, the database IS NOT returned to the same state as it was pre-upgrade. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |