How to Downgrade from Database 11.2 to Previous Release (Includes 11.2.0.4 - 11.2.0.1)

(Doc ID 883335.1)

Last updated on OCTOBER 06, 2017

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.5 to 11.2.0.4 [Release 10.1 to 11.2]
Oracle Database - Enterprise Edition - Version 10.1.0.5 to 11.2.0.4 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Goal

Purpose:

This document is created for use as a guideline and checklist for downgrading a previously upgraded database from Oracle 11gR2 back to the previous release:  Oracle 10gR1, Oracle 10gR2, Oracle 11gR1.  It is also useful for downgrading from 11.2.0.4 to 11.2.0.1

 

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.  Depending on the versions involved, the upgrade process makes changes that are not reversible. The downgrade process allows users to open and access the database instance in the previous version. This is usually sufficient.

Additional, 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 process discussed in this article is a script based downgrade.  This article does not discuss the use of Export / Import, Data Pump or other methods to move data from one version to another.

Oracle binaries of the release/version to which you are downgrading should be available/installed on the server before you start the downgrade process.   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.

Please note the following:

  1. This process is only valid for databases upgraded using either the DBUA or manual upgrade process.  Databases that are moved from one version to another using process (like Export / Import, Data Pump, TTS, ... etc) cannot use this process.
  2. This process is intended to downgrade a database that was successfully upgraded to 11gR2.  It is not intended to back out from a failed upgrade.
  3. You can only downgrade to the release and patch level you upgraded from. For example, if you upgraded from Oracle 10gR1 (10.1.0.5) to Oracle 11gR2 (11.2), then you can not downgrade to Oracle 10gR2 (10.2).  You can only downgrade to Oracle 10gR1 (10.1.0.5)
  4. Downgrades to 9iR2 are not supported.  This is because in the upgrade process the compatible parameter is set to a minimum 10.1.0.  This prevents downgrades.  See <Note 388604.1> : ORA-00201 while downgrading from 10gR2 to 10gR1 or 9iR2 for additional information.
  5. 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. The steps to un-install and roll back patches are documented in the readme for the patch in question.  Failure to un-install and roll back patches can result in a failure to downgrade including dictionary objects that cannot be re-validated.

Example:  For an Exadata Bundle Patch, the procedure is to: 

Un-install the patch

                 Example:   $ opatch auto /u01/app/oracle/patches/14103267 -rollback

Roll back any SQL applied as part of the patch application:        

                 Example:   SQL> @rdbms/admin/catbundle_EXA_<database SID>_ROLLBACK.sql to rollback SQL changes. 

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms