Re: Oracle DB cannot restart due to missing REDO-file

On Sun, 16 Jan 2005 23:23:29 +0100, "T. Lehrmann" <Thomas.Lehrmann_at_gmx.de> wrote:

>But why the hell does Oracle need this stuff also for starting the DB if I
>won't use it (at least for the moment) because I'm not planning to recover
>my database (the DB data files *.dbf still exist).
>

Oracle uses redo log files for
- crash recovery
- hardware malfunction.

If someone bounces the server Oracle will use the online redolog files to recover the instance.
You think you don't need them, but that isn't true at all. You really should read the Oracle Concepts manual

>Isn't there a way to tell Oracle that it shoudn't give a damn about these
>files (e.g. by adjusting it in the init.ora) or, if this won't work,
This would require editing the control file. You would better not do it.

by
>telling Oracle to recreate REDO02 from REDO01 perhaps? (Somehow Oracle
>itself was apparently also able to rebuild the deleted REDO01 file.. ?!)
>

You can clear a logfile group by issuing an alter database statement (exact syntax at http://tahiti.oracle.com) As your database is probably already toast, you should make a backup prior to even trying this.

>ANY HELP IS REALLY APPRECIATED (unfortunately I need the DB, the content was
>important 4 me).

Important data is protected by proper backup procedures.

--
Sybrand Bakker, Senior Oracle DBA