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