How to Downgrade a Single Pluggable Oracle Database ( PDB ) to previous release (Doc ID 2172185.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2 BETA1 and later
Information in this document applies to any platform.

Goal

Purpose :

To downgrade one PDB without downgrading the whole CDB
  a. To unplug a PDB from a release 12.1.0.2 CDB, downgrade it, and then plug it in to a release 12.1.0.1 CDB

  b. To unplug a PDB from a release 12.2 CDB, downgrade it, and then plug it in to a release 12.1.0.2 CDB

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 the downgrade is performed should be available/installed on the server before starting 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 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.

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