Database Migration From Windows to Linux Using RMAN

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:

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 on October 18, 2008 at 08:06 AM IST #

Hi, Alejandro, It is possible to perform this same procedure of Linux for Windows? Anderson Rodrigo Farias

Posted by Anderson Rodrigo Farias on October 22, 2008 at 07:54 AM IST #

i want process of the megration from windows to unix clearly with syntax.

Posted by somesh on October 29, 2008 at 03:41 AM IST #

is there any document that describes step by step migration?

Posted by oracle guy on June 08, 2009 at 07:13 AM IDT #

how to move oracle 10g database from linux to windows ?

Posted by vineet on June 19, 2009 at 02:22 PM IDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
      
Today