My Oracle Support Banner

How to Downgrade Oracle Database 12c Release 1 (12.1) to Previous Versions (Doc ID 1516622.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.



This document is created for use as a guideline and checklist for downgrading a previously upgraded database from Oracle 12c back to the previous release:,

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.

This process is intended to downgrade a database that was successfully and upgraded to 12c.  It is not intended to back out from a failed upgrade. You can only downgrade to the release and patch level you upgraded from.

Direct upgrade is possible for release,, or release or higher. Downgrade is possible to these versions except

For example, if you upgraded from Oracle to Oracle 12c (12.1.0) by applying intermediate patch, then you can not downgrade to Oracle   Downgrade can be done only to Direct upgrade version


Even though direct upgrade is possible for, downgrade is not applicable to

This is because in the upgrade process the compatible parameter is set to a minimum 11.0.0.  This prevents downgrade to  The possible downgrade versions are,, or higher

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.



To view full details, sign in with your My Oracle Support account.

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

In this Document
 Pre-downgrade steps
 Downgrade steps for the database
 Post Downgrade Steps:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.