OraFAQ Forum: Server Administration » cross plat form migration

Home » RDBMS Server » Server Administration » cross plat form migration (oracle 10.2.0.2 HP Tru 64 AIX 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cross plat form migration [message #323579]

Wed, 28 May 2008 22:35

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.

Report message to a moderator

Re: cross plat form migration [message #323637 is a reply to message #323579]

Thu, 29 May 2008 01:50

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.

Report message to a moderator

Re: cross plat form migration [message #323790 is a reply to message #323579]

Thu, 29 May 2008 08:07

joy_division
Messages: 4963
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.

Report message to a moderator

Re: cross plat form migration [message #323825 is a reply to message #323790]

Thu, 29 May 2008 10:54

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

Report message to a moderator

Re: cross plat form migration [message #323831 is a reply to message #323579]

Thu, 29 May 2008 11:17

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: cross plat form migration [message #323838 is a reply to message #323579]

Thu, 29 May 2008 12:41

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!

Report message to a moderator

Re: cross plat form migration [message #323858 is a reply to message #323838]

Thu, 29 May 2008 16:58

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.

Report message to a moderator