Re: Redo log files requirement?

Is your Database operated in Archivelog Mode( FRom svrmgrl>connect internal; Archive log list )
will show you that.

If it is, you may need the Archived Redolog files for Media Recovery( say if U'r Daily Cold backup is damaged and you lose one of the Disks..Using these files, you can REstore the Last good Cold backup and Rollforward the Archived Redolog files and recover your Database as close to the Crash as possible)..

But if you think,
ARCHIVELOG mode is presenting Performance Problems or Space Issues( Both are Easily Managable FYI ) and U'r Cold Backups are stubborn than you can change the mode back into NOARCHIVELOG mode..

If you are just talking about Online Redo Log files, YES they are definetely required for INSTANCE Recovery as you mentioned..but should NOT be used for Media Recovery ..You can always open the DATabase using RESETLOGS option(after restoring the Cold Backup) which will create a Fresh Set of Redo Log files for you...

Hope this helps..

-Thiru

Yev wrote:

> 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:33:41 CDT