Redo log files requirement?

From: Yev <yev_at_NOnetideaSPAM.com>
Date: Thu, 23 Sep 1999 10:01:24 -0700
Message-ID: <GUsG3.6278$QJ.364650@typ11.nn.bcandid.com>

We are getting an custom app written in Delphi that has been connected to work with Oracle8. The app does all the referential integrity checking on the client machine (yeah, yeah, I know!). It also does not use triggers, stored procedures. So tables & indexes only.

Does Oracle8 definitely *require* redo log files? Can they even be turned off?

If our backup/recovery stratagy was to rely on the last complete "cold" backup to recover to (we have limited access to a DBA), then would the redo logs be required for recovery?

Am I right to say though, that Oracle8 requires the redo log files for PMON & SMON or to recover from a incomplete instance shutdown?

TIA Yev. Received on Thu Sep 23 1999 - 12:01:24 CDT