Home » RDBMS Server » Server Administration » cross plat form migration (oracle 10.2.0.2 HP Tru 64 AIX 5.3)
cross plat form migration [message #323579] Wed, 28 May 2008 22:35 Go to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Experts,

i need small information about cross platform migration. i have a huge database which is on HP Tru 64. i have to migrate this database on different host which is running on AIX 5.3

my oracle database is 10.2.0.2

i need to migrate this database with out down time.
is it possible to do that?

can i use exp or expdp or transportable tablespace ?
above three methods are possible. but here is one more problem. that is latest transactions will not be there in the target database.

means if i took expdp or export at 11:00 PM today.assume it is taking 4 hours to take complete export. when i go for import i may not get 4 hours transactions.

is there any other way to do it? with out missing records from source to target.

if it is not possible how do i apply all transaction after exports is takes place.

could you please guide me.
Re: cross plat form migration [message #323637 is a reply to message #323579] Thu, 29 May 2008 01:50 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

If database size is huge then EXP/EXPDP it not a good idea and not useful.

you have to looking for some high availibity option.
like data guard etc or you need down time for migration.
Re: cross plat form migration [message #323790 is a reply to message #323579] Thu, 29 May 2008 08:07 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
skumar.dba wrote on Wed, 28 May 2008 23:35

i need to migrate this database with out down time.
is it possible to do that?



I cannot think of any case where this is possible. This is an exclusive or to me. Even if the database had one table with 1 row, there is going to be downtime.

Re: cross plat form migration [message #323825 is a reply to message #323790] Thu, 29 May 2008 10:54 Go to previous messageGo to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Thanks for reply.

if i got down time, is there any way to do that with hot backup and apply archive on top it.

any flexible way to do if get down time?

Regards,

kumar
Re: cross plat form migration [message #323831 is a reply to message #323579] Thu, 29 May 2008 11:17 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Since what needs to be done is across different OS & hardware architectures, I think the ONLY ways are either exp/imp or transportable tablespaces.

Re: cross plat form migration [message #323838 is a reply to message #323579] Thu, 29 May 2008 12:41 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi,

Your requirment is no downtime and i'm assuming that data should be sync up to a point. If so, then you can do a duplicate target database. Ff you can take a hot backup and transfer it to the new server.
I've done this with Solaris (x64) and Linux (x64) there was no issue. But if the backups are huge then this may not be feasible.
Good luck!
Re: cross plat form migration [message #323858 is a reply to message #323838] Thu, 29 May 2008 16:58 Go to previous messageGo to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
can we take hot backup from source(HP Tru 64) and restore that hot backup on target(AIX 5.3) and apply all the archives?

is there any issues will come? because here both server( HW/OS) are completely different.

is it work for me.
Re: cross plat form migration [message #323898 is a reply to message #323858] Fri, 30 May 2008 00:03 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
i think cross platform won't work. 64-bit going into a 32 bit one as far as i know HW and OS differences won't matter.
Re: cross plat form migration [message #324062 is a reply to message #323858] Fri, 30 May 2008 08:32 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
skumar.dba wrote on Thu, 29 May 2008 17:58
can we take hot backup from source(HP Tru 64) and restore that hot backup on target(AIX 5.3) and apply all the archives?

is there any issues will come? because here both server( HW/OS) are completely different.

is it work for me.



No, only transportable tablespaces can move database files across platforms.
Re: cross plat form migration [message #325482 is a reply to message #323579] Fri, 06 June 2008 05:51 Go to previous message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi

RMAN Cross-Platform Transportable Databases and Tablespaces
Previous Topic: NLS_DATE_FORMAT
Next Topic: Oracle Predefined Roles
Goto Forum:
  


Current Time: Thu Dec 08 06:37:59 CST 2016

Total time taken to generate the page: 0.12122 seconds