Re: Copying large data from one server to another tips

Have you considered building standby on the Linux side. It works ok windows to linux last time I checked. There was a bug in 11.2.0.3 which caused some troubles for heterogeneous standby but it was fixed in 11.2.0.4 IIRC.

On Tue, 13 Jun 2017 at 01:42, Jeff Chirco <backseatdba_at_gmail.com> wrote:

> I am in the process of moving our database from Windows to Oracle Linux
> 7.3. Currently our database are on a NetApp SAN served up to Windows
> filesystem via iSCSI, Linux will is NFS. Our data warehouse is 4.7tb so I
> am trying to find a good way to transfer this data. The fortunate thing is
> that I can do it in chunks, as I an easily reload load any days missing or
> even data greater than a couple months is not used very often. I was
> trying to find ways around just using FTP from one server to another as
> there is a lot of network hops between the two with one being our main core
> switch and users might noticed some network slowness. I believe the
> traffic is QoS. We were hoping we could just mount up a NetApp SnapShot
> from windows onto Linux as then we could just copy one from the other and
> it is only going through storage network. We were able to get the iSCSI to
> mount but my SA said that Linux can't read the filesystem from Windows.
>
> Any other ideas to transfer this amount of data. I was thinking of maybe
> transport tablespace where I start with a new database with a few months of
> data and then slowing FTP old datafiles over and load them in. Might be a
> slower process but I believe would work.
>
> Oracle version is currently 11.2.0.4
>
> Thanks,
> Jeff
>

-- 
Regards
Timur Akhmadeev

--
http://www.freelists.org/webpage/oracle-l