Re: online redo log groups lost

"lve" <lve3162_at_yahoo.com> wrote in message news:93096888.0301101906.549231c8_at_posting.google.com...
> Running oracle 8.1.7 database in NOARCHIVE LOG mode.
> Lost ALL online redo log groups and ALL control files,
> Trying to recover the database using existing data files (Data files
> that were current when online redo log groups were lost).
>
> Don't have any other backups -cold or hot. Just the current data
> files.
>
> Have tried using create control file, recovere database until cancel
> using backup control file and alter database open resetlogs.
>
> Everything failed.
>
> What else can I do to recover the database?

Guess what? You're stuffed. Which is why you multiplex the online logs, to make sure they are not all lost simultaneously. Likewise, multiplexing of the control files should avoid this sort of problem.

If, despite multiplexing, the unthinkable occurred, you would then simply revert to your last backup (in your case, because you're not in archivelog mode, that would have been the end of the matter). If the control files were lost at the same time, you'd have unearthed your controlfile backup trace file, and re-created the controlfiles from scratch.

To have lost all online logs AND not have a backup... well, clearly this wasn't a very important database, so the fact that it's unrecoverable is not much of a drama is it?

Incidentally, I don't know why you mentioned "Don't have any other backups -cold or hot", because in noarchivelog mode you can ONLY take cold backups.

Regards
HJR Received on Fri Jan 10 2003 - 21:33:53 CST