Re: NT striping dangerous with Oracle 7 or 8?

I think you are right Steve. Our new building is supposed to have a UPS and a generator to backup up our system, so that would theoretically prevent the battery backup from running out. But if the power went out on a weekend and things didn't work with the generator we would still be toast when the battery backup ran out.

I checked into the post about disk drives write caching and I found out it was also true, but ours are set up with "write-through" type writing by default. So if we set our raid controller to write through we should be okay.

We can still lose the data currently being written, but with database logging Oracle can recover it.

• Bobby
  >
  > I sorta lost with the reasoning here, because you'd still be buggered when
  > the battery backup ran out... OK, you may have warning alarms, etc., but in
  > the middle of the night you might not be there to hear them.
  >
  > Surely a 'write through cache' is the only real solution?
  >
  > Steve Phelan.
  >
  > Eugen Nyffeler wrote in message <34FBDB7C.AE75B140_at_ubs.com>...
  > >bdurrett_at_ccci.org wrote:
  > ><snip>
  > >> Wow, so you are saying that you really can't protect your database from
  > >> losing data? If you lose writes to the redo log and to a data file
  wouldn't
  > >> you really be sunk? i.e. You couldn't even recover in that case. If you
  were
  > >> doing a lot of heavy updating and commiting transactions and the power
  went
  > >> out you could lose a bunch of stuff.
  > >>
  > >> But this is not NT specific I suppose. A Sun or HP unix box would have
  the
  > >> same issues, correct?
  > >
  > >Yeap,
  > >Any system which has no battery buffer will loos data which is only in
  > >the
  > >cache at this moment. Any system i know has this problem (Unix, NT,
  > >etc.).
  >
  >
  

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 04 1998 - 00:00:00 CST