#12.1.0.2 to 12.1.0.1

[sandeep2363]

Downgrading the Oracle Database Non-CDB or CDB

Downgrading the Oracle Database Non-CDB or CDB

Downgrade the Oracle Database

In Oracle You have option to downgrade the Oracle database. Suppose you upgraded the Oracle database from 11g to 12c database now you want to downgrade. but if you change the compatibility parameter of your oracle database from 11.2.0 to 12.1.0 then you cannot able to downgrade. only method is logical backup expdp or impdp.

If your database compatibility is same…

[sandeep2363]

Upgrade Matrix for 18c & 12c Oracle Database

Upgrade Matrix for 18c & 12c Oracle Database

Upgrade Matrix for Oracle Database

Upgrade to 18c or 18.1 Version

Source Database Destination Database 12.2.0.1 18.1 12.1.0.1/12.1.0.2 18.1 11.2.0.3/11.2.0.4 18.1

Upgrade to 12c Release 2

Source Database Destination Database 12.1.0.1/12.1.0.2 12.2 11.2.0.3/11.2.0.4 12.2

Indirect upgrade for 12.2 Version

Source Database Path 11.2.0.1/11.1.0.6/10.2.0.2…

[sandeep2363]

Downgrade unplug and plug the Pluggable Oracle Database

Downgrade unplug and plug the Pluggable Oracle Database

Downgrade unplug and plug the Pluggable Oracle Database in lower version

You can downgrade the PDB database from upper version to lower version.

1. Downgrade the PDB database 2. Unplug from upper version 3. Plug it in lower version

Steps as follows: Example you are downgrade the PDB from 12.1.0.2 to 12.1.0.1 Version of Oracle.

Downgrade the PDB

1. Start up the PDB database(12.1.0.2) in DOWNGRADE…