I have upgraded the Oracle database to 12cR2, now I want to downgrade it to 12cR1.Is this possible?What are the conditions?
Can we downgrade oracle database form 12cR2 to 12cR1
oracle-12c
Related Question
- Oracle – Creating an Oracle 11.2-Compatible Database in Oracle 12.2.0.1
- Oracle – Prerequisites for Oracle 11g and 12c on Same OL7 Server
- Patching after upgrade (windows 11gr2 -> 12cR2)
- Oracle 12cR2 RMAN – ORA-01547, ORA-01194, RMAN-06054
- Oracle 12cR1 – How to Fix RMAN-11003, ORA-00354, ORA-00353 Corrupt Redo Log
- Oracle 12cR1 – Duplicate Database Without Resetlogs
Best Answer
You can downgrade both major releases and patchset releases, based on the original Oracle Database release from which the database was upgraded. Major release downgrades are supported back to Oracle Database 11g Release 2 (11.2.0.2) and subsequent 11.2 releases, and Oracle Database 11g Release 1 (11.1.0.7). Patchset downgrades are supported back to Oracle Database release 11.2 patchsets, except release 11.2.0.1.
This link provides a summary of releases supported for downgrading.
Also, check this link for compatibility.