X

Alejandro Vargas' Blog

  • ASM
    October 6, 2008

Database Migration From Windows to Linux Using RMAN

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

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

Join the discussion

Comments ( 5 )
  • Ofir Saturday, October 18, 2008
    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
  • Anderson Rodrigo Farias Wednesday, October 22, 2008
    Hi, Alejandro,
    It is possible to perform this same procedure of Linux for Windows?
    Anderson Rodrigo Farias
  • somesh Wednesday, October 29, 2008
    i want process of the megration from windows to unix clearly with syntax.
  • oracle guy Monday, June 8, 2009
    is there any document that describes step by step migration?
  • vineet Friday, June 19, 2009
    how to move oracle 10g database from linux to windows ?
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha