Operating System - HP-UX
1748039 Members
4885 Online
108757 Solutions
New Discussion юеВ

Migrate multi-TB Oracle DB to HP-UX

 
SOLVED
Go to solution
Alzhy
Honored Contributor

Migrate multi-TB Oracle DB to HP-UX

Hola!

What are our options? Is VXFS 5.0 really OS/Platform independent that if I've my cooked storage on VxFS 5.0 on HP-UX - that I can move storage accross platforms?

What about if my Oracle DB is stored as RAW (ASM or plain raw)?

Hakuna Matata.
8 REPLIES 8
Patrick Wallek
Honored Contributor
Solution

Re: Migrate multi-TB Oracle DB to HP-UX

What version of Oracle? What version of HP-UX? From what other OS to HP-UX?

Depending on the platforms you have issues with the "Endian Format" of the datafiles.

If you are on Oracle 10g then there are "Cross-Platform Transportable Tablespaces". These allow you transfer tablespaces between different OS's. This can be done via RMAN.

Have a look through your Oracle docs for more information on the "Cross-Platform Transportable Tablespaces".
Hein van den Heuvel
Honored Contributor

Re: Migrate multi-TB Oracle DB to HP-UX

Nelson,

Are you in Vegas this week? At the very moment I write this my buddy Umesh Pahtak is doing session #1612 "Failover and Migration of Oracle Database Between HP 9000 (PA-RISC) Servers and HP Integrity (IPF) Servers"
Sounds like that would be of interest.
If you are here, then seek out Umesh, or Email him or me and at least get the slides.

hth,
Hein.
Hein van den Heuvel
Honored Contributor

Re: Migrate multi-TB Oracle DB to HP-UX

Here are some links which Harold Moss refered to durng the presenation above:

Failover of Oracle Databases between HP9000 and HP Integrity Servers(www.hp.com/go/oracle)

http://h71028.www7.hp.com/enterprise/downloads/Failover_of_Oracle_10g_DB_PA-RISC_and_IPF.pdf


Oracle database migration from PA-RISC to HP-UX 11i v2
http://h21007.www2.hp.com/dspp/files/unprotected/hpux/oracle9irel2migr.pdf


Oracle Maximum Availability Architecture (MAA) Best Practices
http://www.oracle.com/technology/deploy/availability/htdocs/maa.htm

hth,
Hein.
chris huys_4
Honored Contributor

Re: Migrate multi-TB Oracle DB to HP-UX

Alzhy
Honored Contributor

Re: Migrate multi-TB Oracle DB to HP-UX

Chris.... thanks for the linky!

Hein, yes I am here in Vegas Sir. But too late on thine reply.. Anyways, I've already alerted my DBAs to the various possibilities.

We'll be testing when I go back both XTTS and VxVM PDC/VxFS approaches.
Hakuna Matata.
TwoProc
Honored Contributor

Re: Migrate multi-TB Oracle DB to HP-UX

Nelson,

If you're moving from HP PARisc to HP Integrity - the database files don't need to be exported and imported - they are good where they are.

I would think that even your raw files can be redeployed as raw files on the destination system.

If you're doing Sun to HP - you may have to run the import/export - but I think I read some time back that Oracle made efforts to start using singular database file formats across platforms, with the exception being Intel 386ish formats, as with those, I would imagine your basically migrating little-endian to big-endian binary formats (or vice-versa, right now I forget which is which).
We are the people our parents warned us about --Jimmy Buffett
Dennis Handly
Acclaimed Contributor

Re: Migrate multi-TB Oracle DB to HP-UX

>TwoProc: I would imagine your basically migrating little-endian to big-endian binary formats

Yes, HP-UX is big-endian.
Alzhy
Honored Contributor

Re: Migrate multi-TB Oracle DB to HP-UX

We're moving multi-TB databases from HP-UX to Sun and vice versa.

It appears Oracle 10G's (luckily our version) Cross Platform Transaportable Tablespaces will do the trick. And the fact that SPARC and PARISC (IA64) have the same "Endianess" make things a little better.

http://www.oracle.com/technology/deploy/availability/htdocs/x
Hakuna Matata.