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
