RE: migrate database 10.1 on HP-UX to 10.2 on AIX

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Wed, 17 Jun 2009 20:09:44 -0400
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F29D2E359_at_US-BOS-MX011.na.pxl.int>

Did that exactly about a year ago. Transportable database is the best option. Start out either upgrading the database to 10.2 on HP and then move it to AIX (this is the method I used) or move to AIX 10.1 and then migrate upwards. Look in the rman manual ( Database Backup and Recovery Reference) under convert. Note with a database that big you might be better off converting datafiles than the entire database at one time. It allows you to parallel the activity through two sessions of rman.

Dick Goulet
Senior Oracle DBA
PAREXEL International

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ujang Jaenudin Sent: Wednesday, June 17, 2009 3:59 AM
To: Oracle Discussion List
Subject: Re: migrate database 10.1 on HP-UX to 10.2 on AIX

sorry not to mention about datasize, it is about 1TB.

On Wed, Jun 17, 2009 at 2:06 PM, Ujang
Jaenudin<ujang.jaenudin_at_gmail.com> wrote:
> dear all,
>
> we are planning to migrate and convert database from hp-ux pa-risc to
> new aix (same big endian).
>
> finding metalink note, could not point to the statement that "we can
> convert from 10.1 to 10.2 on different platform directly"
>
> got this statement from oracle docs 10.1 that we can use transportable
> tablespace approach:
> Beginning with Oracle Database 10g, a tablespace can always be
> transported to a database with the same or higher compatibility
> setting, whether the target database is on the same or a different
> platform.
>
> does anyone has this kind of experiences?
> any issues will raise during migration and after migration?
>
>
> --
> thanks and regards
> ujang | oracle dba | mysql dba
> jakarta - indonesia
>

-- 
thanks and regards
ujang | oracle dba | mysql dba
jakarta - indonesia
--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 17 2009 - 19:09:44 CDT