First, Use Oracle SQLloader to load that data into the Oracle database. Second, Update the read-only-reporting Oracle database from the other database at desired interval.
There are several methods to accomplish the second task. Method one: Run Oracle database in archive mode, after the first time load "that data" into the Oracle database, take a cold backup of the DB; use the cold backup to restore on the second server system (sun+F840) to create the reporting database. Then, use Snapmirror to ship archive logs to the reporting database system. Apply archive logs to update the reporting database at desired interval that can be done in scripts via cron job. This method is straight forward.
Method two: Use Oracle Standby Database (replication) that provide you the ability to ship archive logs via net8, apply archive logs at desired interval to update/sync with the other database; and the standby database can be in read-only mode as reporting database. You will need to follow Oracle Standby Database documentation for configuration and operation of Oracle Standby Database.
Please do not hesitate to contact me if I can provide any assistance.
Regards.
Jerry Liu Database Engineer Network Appliance, Inc.
-----Original Message----- From: Schiel, John [mailto:John.Schiel@qwest.com] Sent: Tuesday, December 19, 2000 1:02 PM To: 'toasters@mathworks.com' Subject: NetApp and Oracle
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