Migrating from HP-UX to AIX
Joseph Silverius
We are planning to migration one of our Oracle 9i databases from
HP-UX to AIX. What are our options? Upgrading our database to 10g in
this process will be a plus. Our database size if 2.5 TB, so
export/import is the least preferred option.
Couple of weeks back, I was in an Oracle presentation and I
tossed this question to the group. I got the following options from
them. Please suggest more options and add your comments.
1. 10g has a fast export and import feature. Can we use 9i's export
and 10g's fast import or do a fast export using 10g client from a 9i
database?
2. One guy the Oracle presentation claimed that he has done an RMAN
clone across platforms. If it works, our migration effort will be
reduced considerably.
3. Upgrade the database to 10g and use transportable tablespaces to
migrate data
Thanks,
Joe
Dave
"Joseph Silverius" <jos...@gmail.com> wrote in message
news:fa2ecaa0.04083...@posting.google.com...
cant use data pump from 9i, just wont work im afraird, two very different
things.
upgrading to 10g and then using transportable tablespaces seems the best
option here
or upgrade to 10g and then use expdp and impdp - prefer TT myself
Sybrand Bakker
On 30 Aug 2004 12:10:41 -0700, jos...@gmail.com (Joseph Silverius)
wrote:
>Hi All,
> We are planning to migration one of our Oracle 9i databases from
>HP-UX to AIX. What are our options? Upgrading our database to 10g in
>this process will be a plus. Our database size if 2.5 TB, so
>export/import is the least preferred option.
>
> Couple of weeks back, I was in an Oracle presentation and I
>tossed this question to the group. I got the following options from
>them. Please suggest more options and add your comments.
>
>1. 10g has a fast export and import feature. Can we use 9i's export
>and 10g's fast import or do a fast export using 10g client from a 9i
>database?
It has *never ever* been possible to use a higher version export
against a lower version database.
The second 'alternative' is not going to work.
For the first 'alternative' you need to make sure the export file
format is identical.
>
>2. One guy the Oracle presentation claimed that he has done an RMAN
>clone across platforms. If it works, our migration effort will be
>reduced considerably.
He may claim that, but Oracle has never supported cross platform
compatibility. The only supported way to perform a platform swap is
export/import.
>
>3. Upgrade the database to 10g and use transportable tablespaces to
>migrate data
>
>Thanks,
>Joe
Please avoid posting to comp.databases.oracle, it was abolished years
ago after a ballot, and many providers do not carry it.
--
Sybrand Bakker, Senior Oracle DBA
Daniel Morgan
Upgrade to 10g then use transportable tablespaces.
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu
(replace 'x' with 'u' to respond)