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

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