RE: Cross-Platform migration (10g)
Date: Fri, 11 Dec 2009 14:05:07 -0800 (PST)
Message-ID: <841983.17056.qm_at_web38204.mail.mud.yahoo.com>
we had to use datapump to move from our HPUX 64 bix to Linux 64 bit.
�
There is alot of things that isn't supportef for transportable tablespace and/or rman
�
But do double check.
�
And for datapump you can precreate your tables then just bring in the data then create the indexes, helps to save time.� Watch doing large amounts of data using the db link option. If you don't have enought bandwidth the datapump jobs fails and you have a mess!�
�
�
You can also do data streams but this requires alot of set up and care and feeding. You might have to take a database outage to put in the required parameters.
�
You could get somewhat creative with materialized views as well using it to populate data vs using data streams.
�
Just some more for you to think about.
�
K
�
- On Fri, 12/11/09, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:
From: Goulet, Richard <Richard.Goulet_at_parexel.com> Subject: RE: Cross-Platform migration (10g) To: "Michael Fontana" <michael.fontana_at_enkitec.com> Cc: wellmetus_at_gmail.com, oracle-l_at_freelists.org Date: Friday, December 11, 2009, 10:16 AM
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-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 11 2009 - 16:05:07 CST