Re: Best way to move data beween servers

In article <pan.2003.03.10.17.17.20.472759_at_yahoo.com.au>, "Howard says...
>
>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.

Mg Gawd, something I know that Howard isn't sure about!!! :)

No they are definitely not counted as the same OS. Same OS means Tru64 to Tru64, for example, and at the same OS release. There may be some flexibility around patch levels, but that's all.

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

Nope, can't be done.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Mon Mar 10 2003 - 11:28:56 CST