RE: Cross-Platform migration (10g)
Date: Fri, 11 Dec 2009 11:16:13 -0500
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F02C6548D_at_us-bos-mx022.na.pxl.int>
Michael,
Not sure, but form past experience moving from 32 to 64 bit all you needed to do was run catproc thereafter to recompile everything properly. But, and someone correct me if I'm wrong, I believe rman can only migrate database files across systems with the same endianesses. Namely big to big and small to small. I believe there's a package/procedure in the database that tells you if the move is supported.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
-----Original Message-----
From: Michael Fontana [mailto:michael.fontana_at_enkitec.com]
Sent: Friday, December 11, 2009 11:13 AM
To: Goulet, Richard
Cc: wellmetus_at_gmail.com; oracle-l_at_freelists.org
Subject: Re: Cross-Platform migration (10g)
Actually, RMAN cross-platform migration should cover the bitset issues as well.
- Original Message ----- From: "Richard Goulet" <Richard.Goulet_at_parexel.com> To: wellmetus_at_gmail.com, oracle-l_at_freelists.org Sent: Friday, December 11, 2009 10:01:49 AM GMT -06:00 US/Canada Central Subject: RE: Cross-Platform migration (10g)
Rodger,
You've not only got the Operating system migration, but a 32 vs 64 bit migration as well. I think that exp/imp is your only option.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
Sent: Friday, December 11, 2009 10:51 AM
To: oracle-l_at_freelists.org
Subject: Cross-Platform migration (10g)
Hi List,
I need to move a database from Windows to HP-UX. What are my options besides exp/imp (datapump)?
Source:
Little Endian - Microsoft Windows IA (32-bit)
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Target:
Big Endian - HP-UX IA (64-bit)
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
I think I could tranport user tablespace but not the entire database.
Thanks,
Roger Xu
-- Michael Fontana Sr. Technical Consultant Enkitec M: 214.912.3709 enkitec oracle_certified_partner -- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 11 2009 - 10:16:13 CST