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(a)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