If all that you require is a R/O database, why not use Oracle's Hot
Standby feature? I realize that this doesn't much rely on NetApps
(although it's handy for the initial copy...), but it does the job quite
well. I've got a Hot Standby that has been up and running for 3 years,
and 2 major Oracle Upgrades without problems.
Jason
-----Original Message-----
From: George Kahler [mailto:george@YorkU.CA]
Sent: Friday, March 04, 2005 3:26 PM
To: toasters(a)mathworks.com
Subject: Oracle DSS on filer
I'm looking for help with Oracle 9i/Oracle DSS on a filer.
Some time ago I set up an environment for my DBAs to allow them to
have a DSS version of the University Student Information System
database (SIS - about 140 GB + duplex logs) based on the NetApp
document "Implementing a DataMart/DSS Oracle Databse [TR3041]."
The problem that users are complaining about is that it takes about
1/2 hr for the DBAs to create the DSS. This is created nightly at
midnight. The DBAs shutdown the database, take a snapshot of the
database volume and a snapshot of the log volume. Then they proceed to
copy control file info and about 17 GB of logs and some undo table
from the R/W database to the DSS database. They're saying that this is
necessary because when the DSS comes up it wants to do a rollback and
thus it needs the old logs/undo to do this.
Question that everyone is asking: Isn't there a way that you can tell
the DSS database to ignore the recovery (since it is a R/O database
anyway) and just start up without processing the logs and the undo ?
Thx,
------------------------------------------------------------------------
-------
George Kahler e-mail: george(a)yorku.ca
Sr. Systems Administrator humans: (416) 736-2100
x.22699
Computing and Network Services machines: (416) 736-5830
Ontario, Canada, M3J-1P3