This post describes the procedure required to migrate a database from Windows to Linux using the RMAN Convert Database command.
Both Windows and Linux platforms have the same endian format, which makes possible to transfer the whole database, making the migration process very straightforward and simple.
To migrate between platforms that have a different endian format, Cross Platform Transportable Tablespaces (XTTS) needs to be used instead.
List of Steps Needed to Complete the Migration
The migration process is simple, but as it has several steps it is convenient to be familiar with them before running it.
1. Check platform compatibility between source and target OS
2. Start the database in read only mode
3. Check database readiness for transport from Windows to Linux using DBMS_TDB.CHECK_DB
4. Check if there are any external objects
5. Execute the Rman Convert database command
6. Copy converted datafiles, generated Transport Script and Parameter File to Linux
7. Edit the init.ora for the new database
8. Edit the Transport Script and Parameter File changing the windows paths to Linux Paths
9. Execute the Transport Script
10.Change the Database ID
11.Check database integrity
For a detailed step by step guide please check this document : Database Migration From Windows to Linux Using RMAN
Comments (5)
Hi Alejandro,
just wanted to add that in 11g you can do it with only 1-minute downtime, regardless of database size.
What's the secret? you can use data guard physical standby between windows and linux in 11g.
So, set up a linux standby for your 11g windows deployment and make sure it is up to date. When you are ready to migrate - just do a switchover!
that will be fantastic...
Ofir
Posted by Ofir | October 18, 2008 6:06 AM
Posted on October 18, 2008 06:06
Hi, Alejandro,
It is possible to perform this same procedure of Linux for Windows?
Anderson Rodrigo Farias
Posted by Anderson Rodrigo Farias | October 22, 2008 5:54 AM
Posted on October 22, 2008 05:54
i want process of the megration from windows to unix clearly with syntax.
Posted by somesh | October 29, 2008 1:41 AM
Posted on October 29, 2008 01:41
is there any document that describes step by step migration?
Posted by oracle guy | June 8, 2009 4:13 AM
Posted on June 8, 2009 04:13
how to move oracle 10g database from linux to windows ?
Posted by vineet | June 19, 2009 11:22 AM
Posted on June 19, 2009 11:22