MOVING TO ORACLE 12c

migrationoracleoracle-11g-r2oracle-12crman

I have an rman backup of 11.2.0.2. Also I have installed 12c on a separate server. Can I move my backup to 12c. if yes?
Please guide me how to do it?
Appreciate your comments and answer.

Best Answer

Restore the database as you would normally do it.

But at the end, instead of:

alter database open resetlogs;

Open the database with:

alter database open resetlogs upgrade;

Then upgrade the database to the new release. Instructions can be found at:

Manually Upgrading a Non-CDB Oracle Database

Note that the above documentation is for version 12.1.

Direct upgrade from 11.2.0.2 to 12.2 is not supported, you need an extra upgrade step to 11.2.0.3 or 11.2.0.4 or 12.1 before upgrading to 12.2.