I'd like to pose this question here and see where it leads. If this is not the appropriate forum, please let me know what is. I'm in a group where we need to implement a data warehouse. Our design so far is to purchase two 840 filers each with one terabyte of storage using the 36gb drives. On top of that we are going to use either a 420R or Netra 1405 sun server as the database server (solaris 8, Oracle 8.1.6). What we need to do is grab files off of a 760 filer that is in CDR (comma delimited record) format and load that data into an instance of Oracle. Our goal then is to use some method of getting the data off of the 'load' server to another server that will be essentially 'read only' for reporting purposes. These so far are separate servers and I'd like to stay away from Oracle Parallel Server (OPS) at this point because of the extra maintenance and design work that would need to be done to handle this. What I would like to know is what methods of data movement some of you have used. In our quote for the filers we have asked for SnapMirror but I have some reservations on how that might work with Oracle because of the SCN's that are in each separate instance of Oracle.
John