RMAN Cross-Platform Database Migration: Windows to Linux

  • Creates controlfiles and opens the database with resetlogs option
  • Creates temporary tablespace
  • Brings the database down, starts it using the upgrade mode and run utlirp.sql.This script recompiles all PL/SQL objects in the format required by the target database platform.
  • Runs the utlrp.sql file which recompiles all PL/SQL objects with invalid status.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
MiCORE Solutions

MiCORE Solutions

1 Follower

MiCoreSolutions helps you design, develop, implement, and monitor databases for your business & help you to make the most of your ROI.