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

Thanks for the hint, Sybrand, I already read sth. about the alter database statement, but I supposed that for using it the database had too be at least online, and mine isn't, anyway I'll try this out.. and of course.. a backup would have done it.. but laziness is, besides the engine of progess for man, also a main reason for unreasonable risky behaviour and unpleasant results.. like in my case...

Anyway, thanks and regards..
Thomas

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> schrieb im Newsbeitrag news:27ulu017e9chpkcudkadu2ohgj6btmre7q_at_4ax.com...
> 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
Received on Sun Jan 16 2005 - 17:46:34 CST