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@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@yorku.ca

Sr. Systems Administrator humans: (416) 736-2100 x.22699 Computing and Network Services machines: (416) 736-5830 Ontario, Canada, M3J-1P3