Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle heterogeneous system copy

Fred Morin_1
Advisor

Oracle heterogeneous system copy

We have a Oracle 8.1.7 database on a Reliant UNIX server in Europe, we want to transfer this database on a HPUX RP2470 11i in Canada.
Other than a export, what is the best way to do that?
5 REPLIES
Steven E. Protter
Exalted Contributor

Re: Oracle heterogeneous system copy

Assuming the versions of the database are the same, you can clone the database.

Shut it down.

Copy all the tablespaces to the new system.

Follow the attached 32 bit to 64 bit word size conversion documentation.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Fred Morin_1
Advisor

Re: Oracle heterogeneous system copy

You means copy all datafiles, in the same stucture?
Jean-Luc Oudart
Honored Contributor

Re: Oracle heterogeneous system copy

Hi,

I don't think you can copy datafiles accross different platforms.

I suppose you have access to Metalink.
check doc id 270555.996

there are lot more around cross platform migration.


Rgds,
Jean-Luc
fiat lux
Volker Borowski
Honored Contributor

Re: Oracle heterogeneous system copy

Hi,

not really much else I guess.
If it is not that big, you could try to link source and target over the net an try some sort of replication (ssh-tunnel for sql-net connection of course to be encrypted).

Watch CHARSET problems if the source-DB is an old one.

Hope this helps
Volker
Graham Cameron_1
Honored Contributor

Re: Oracle heterogeneous system copy

Your source Reliant unix box is a different architecture to the destination HP, and you would be very lucky if oracle database files were portable between the two.

Export/Import is your only supported option.

You could compress the export file before you ship it to reduce your transatlantic network load.

If you don't have the disk space to hold the export file you could use a named pipe. There is a thread at
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x02cb506d69a7d711abdc0090277a778c,00.html
although this would have to be extended to handle cross-machine transfer.

You could also split your export file into smaller chunks, and ship them over one at a time, using the FILESIZE export option.

-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.