Re: redo lost after disk failure

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...

-- 
http://mgogala.freehostia.com