Re: Best way to move data beween servers

On Mon, 10 Mar 2003 10:35:00 +0000, Norman Dunbar wrote:

> Morning QT,
>
> if you are wanting to move Oracle data between two different
> servers/operating systems, then you will have to go via exp/imp (unless
> RMAN allows you to do it) because of the differing OS features like
> big-endian/little endian etc. If you try to do a database clone, then
> when you try to startup you'll get a telling off from Oracle and it
> won't start.
>
> I'm not at all familiar with transportable tablespaces, but I suspect
> that they won't transport very well between OS - I'll be corrected on
> this if I'm worng, but I've never had (to have) anything to do with them
> since I did my 9i upgrade course.
>
> HTH
>
> Regards,
> Norman.

Officially, transportable tablespaces require the same O/S and the same point-and-patch release of Oracle. Whether Tru64 and Solaris count as the same OS (ie "Unix"), I couldn't say. But I seriously doubt it.

The thought of exporting 0.5TB of data doesn't bear thinking about, but you could export the structure only, and load the data via a database link.

Here's a wild and wacky thought: you can use RMAN to 'move' a dbf to a raw partition. Could you then physically append a Compaq raw partition to a Solaris box, and have RMAN clone/move it back into a dbf upon arrival? (The RMAN raw-to-dbf will work, but is raw "raw", or still O/S-specific? I don't know my Unix well enough to answer that).

Regards
HJR Received on Mon Mar 10 2003 - 11:17:21 CST