0

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.

1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.