Windows – How to Migrate Oracle 11g R2 (Windows) database to Oracle 12c R2 (Linux) db

linuxmigrationoracle-11g-r2oracle-12cwindows-server

I have a requirement to migrate Oracle 11g R2 database (Windows platform) to Oracle 12c R2 database (Red Hat Linux platform).

Is there any methods using RMAN to do it?

Any help will be appreciated.

Best Answer

Source:

RMAN> shutdown immediate
RMAN> startup mount
RMAN> backup database ...

Destination:

RMAN> startup nomount
RMAN> restore controlfile from ...
RMAN> alter database mount;
RMAN> restore database;
RMAN> alter database open resetlogs upgrade;

Then manually upgrade the database to 12.2:

Example of Manual Upgrade of Windows Non-CDB Oracle Database 11.2.0.3

Related Question