topic Re: copy oracle 8i database between different platform in Operating System - HP-UX

copy oracle 8i database between different platform

awk_1 — Wed, 10 Jul 2002 05:51:10 GMT

hi all,

i know it can copy oracle 8i database to different instance but how to copy 8i database from one platform to another platform (say, from hp-ux 11 to linux)?

thx in advance,
alex

Re: copy oracle 8i database between different platform

Stefan Farrelly — Wed, 10 Jul 2002 05:56:38 GMT

We copy 8i databses fro HP server to HP server all the time without problems, but as Linux is not binary compatible with HP-UX you're going to have to install 8i for Linux first. When thats done and its up and running then copy over your database (database files, indexes, redo logs) and then get the database up and running, or export your db on your HP and copy over then import it on your Linux server.

Re: copy oracle 8i database between different platform

Sebastian Galeski_1 — Wed, 10 Jul 2002 05:57:22 GMT

Hi
i rather suggest You to export and import database. Different OS has different disk layouts for example.

regards seba

Re: copy oracle 8i database between different platform

awk_1 — Wed, 10 Jul 2002 06:13:44 GMT

thx your input. but is the exported files binary compatible with linux?

Re: copy oracle 8i database between different platform

Sebastian Galeski_1 — Wed, 10 Jul 2002 06:19:50 GMT

yes it is

Re: copy oracle 8i database between different platform

awk_1 — Wed, 10 Jul 2002 06:29:30 GMT

thx all.

Re: copy oracle 8i database between different platform

Stefan Farrelly — Wed, 10 Jul 2002 06:41:24 GMT

Dont forget to assign points to those who took the time to help you.

Re: copy oracle 8i database between different platform

Ryan Kogelheide — Wed, 10 Jul 2002 10:26:20 GMT

Re: copy oracle 8i database between different platform

Ryan Kogelheide — Wed, 10 Jul 2002 10:27:29 GMT

... and then do your export and import :)

Re: copy oracle 8i database between different platform

Marcos_9 — Thu, 11 Jul 2002 08:10:22 GMT

The only way certified by Oracle is doing and export / import.

Export the database to a file with "exp sys/change_on_install@INSTANCE FULL=Y FILE=export.dmp LOG=export.log" of course you'll have to change passwords instance name and you can use absolut paths instead of relatives

Create a database with Oracle database assistant

Make an import to the new database
"imp sys/change_on_install@INSTANCE FULL=Y FILE=export.dmp LOG=import.log"

and then check the import.

Check for ORA- messages inside this log

One good thing would be to create non standard tablespaces and non standard users because this will probably generate some errors.

If the plattforms were the same (Both Salaris, HP-UX, Linux) you could create a script to generate the database with "alter database backup controlfile to trace" and then do a binary ftp to the other host of all the datafiles. After this you can edit an run the .trc file generated.