Database platform migration from Windows-32bit to Linux-64bit
Posted
by [email protected]
on Oracle Blogs
See other posts from Oracle Blogs
or by [email protected]
Published on Tue, 30 Mar 2010 11:31:06 +0100
Indexed on
2010/03/30
11:23 UTC
Read the original article
Hit count: 870
They were distrustful about Linux and after came an agreement to migrate their Enterprise Manager from Windows to Linux (OMS and Repository).
How we did demonstrate how powerful and easy is RMAN to migrate databases across platforms.
- Fist of check of target platform is available from source
SQL> select platform_name from v$db_transportable_platform;
PLATFORM_NAME
-----------------------------------------------------------
Microsoft Windows IA (32-bit)
Linux IA (32-bit)
HP Tru64 UNIX
Linux IA (64-bit)
HP Open VMS
Microsoft Windows IA (64-bit)
Linux 64-bit for AMD
Microsoft Windows 64-bit for AMD
Solaris Operating System (x86)
- Check database object as directories that can change across platforms, also check external tables.
- Startup source database in read only mode
- Run the following RMAN Script
RMAN> connect target /
RMAN> convert database on target platform
convert script 'c:/temp/convert_grid.rman'
transport script 'c:/TEMP/transporta_grid.sql'
new database 'gridbd'
format 'c:/temp/gridmydb%U'
db_file_name_convert 'C:\oracle\oradata\grid','/oracle/gridbd/data2/data';
(Notice tha path change on db_file_name_convert)
- Move from source to target:
- Pfile
- New scripts
- external table files
- bfiles
- data files
- Check pfile, and ensure that the paths are OK
- Create temporary control file to connect rman
- Execute the RMAN script
RMAN> connect target /
RMAN> @/home/oracle/pboixeda/win2lnx.rman
- Shutdown the instance and remove temporary control files
- Recreate controlfile/s, take care about the used paths.
- Execute the transport script, transporta_grid.sql
- Due we were moving from a 32-bit architecture to a 64-bit architecture, there is bug reported in 386990.1 note, we had to recreate OLAP , check the note for more details.
- Alter or Recreate all necessary objects
- Launch utlrp
Hope it helps
© Oracle Blogs or respective owner