Re: redo lost after disk failure

From: Mladen Gogala <>
Date: 08 May 2008 22:02:40 GMT
Message-ID: <48237880$0$6430$>

On Thu, 08 May 2008 13:07:27 -0700, eliot06 wrote:

> I have this message :
> Errors in file /oracle/10.2.0/admin/mvstst/udump/ mvstst_ora_618646.trc:
> ORA-00313: ├ęchec d'ouverture des membres du groupede journaux 1, thread
> 1
> ORA-00312: journal en ligne 1 thread 1 : '/redo/mvstst/redo01.log'
> ORA-27037: impossible d'obtenir l'├ętat du fichier
> The database is in NOARCHIVE, how can i do to restore this database ? Is
> it possible ?
> Thank's

Noarchive mode means, translated in ANSI standard English, "living dangerously". You gambled and lost. C'est la vie. If the database was shut down normally and no recovery is needed, you can open the database using resetlogs option, in which case the new redo logs will be created. If shutdown abort was issued or the instance simply crashed, then you are, to quote Lewis Black, red, white and s...

Received on Thu May 08 2008 - 17:02:40 CDT

Original text of this message