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

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_at_freelists.org on behalf of Asif Momen Sent: Mon 13/07/2009 12:25
To: ujang.jaenudin_at_gmail.com
Cc: oracle-l_at_freelists.org
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_at_gmail.com> wrote:

	From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
	Subject: Re: migrate database 10.1 on HP-UX to 10.2 on AIX
	To: "Oracle Discussion List" <oracle-l_at_freelists.org>
	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_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