RE: migrate database 10.1 on HP-UX to 10.2 on AIX
- From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
- To: <asif_oracle@xxxxxxxxx>, <ujang.jaenudin@xxxxxxxxx>
- Date: Mon, 13 Jul 2009 14:59:36 +0100
If both source and destination platform of same endian format, then you dont
need to convert the files. You can directly transfer the files as its and plug
them in destination database. Both HP-UX and AIX are BIG endian.
SELECT * From V$TRANSPORTABLE_PLATFORM;
Regards,
Vishal Gupta
http://www.vishalgupta.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Asif Momen
Sent: Mon 13/07/2009 12:25
To: ujang.jaenudin@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: migrate database 10.1 on HP-UX to 10.2 on AIX
Hi,
Basically, there are two requirements:
1) Upgrade from 10.1 to 10.2 and
2) Migrate from one platform to another.
I would have taken the following approach in the mentioned order:
1) Migrate to AIX
2) Upgrade to 10gR2
In this way, my source database will be intact if (for whatever reason) we have
to fallback.
How to Migrate
1) Create a mount point on AIX (assuming you have one)
2) Using NFS, mount the AIX mount point on HP with read-write access.
3) Open the source database (HP) in read-only mode
4) Convert all the HP-datafiles in parallel to AIX using RMAN's convert command
5) Unplug the AIX shared mount point from HP
6) Re-create the controlfile on AIX
7) Backup your new database
Regards
Asif Momen
http://momendba.blogspot.com
--- On Wed, 6/17/09, Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx> wrote:
From: Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx>
Subject: Re: migrate database 10.1 on HP-UX to 10.2 on AIX
To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
Date: Wednesday, June 17, 2009, 12:59 AM
sorry not to mention about datasize, it is about 1TB.
On Wed, Jun 17, 2009 at 2:06 PM, Ujang
Jaenudin<ujang.jaenudin@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
