Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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.