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.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
RMAN> shutdown immediate RMAN> startup mount RMAN> backup database ...
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: