Re: Get data after redologs corruption

From: Howard Latham <howard.latham_at_gmail.com>
Date: Thu, 27 Mar 2008 11:33:22 +0000
Message-ID: <713d96d10803270433u70cb654cl96eafe0b2f0e718d@mail.gmail.com>


We found a tool that reads tablespace datafiles - k2tor - very good!

On 27/03/2008, giantpanda_at_gmx.net <giantpanda_at_gmx.net> wrote:
>
> Hi,
>
> please note:
> This is a recovery test problem, not a current production situation.
> (Not invented, though. I heard of somebody who actually had it
> in production. Don't know what they did about it.)
>
> A virus scanner ran over the database causing it to crash (shutdown abort)
> and shredded all the redologs. And all recent backups. The datafiles seem to
> be intact. As the database was idling, they probably contain all the data,
> but are, of course, not in a consistent state.
>
> Problem: How to get the data.
>
> I was able to open the database with
> _allow_resetlogs_corruption = TRUE in init.ora and
> recover database until cancel;
> cancel immediately
> alter database open resetlogs;
>
> It crashes again when trying to do any work. After repeated attempts
> I could (once) get an export of the test schema for a fresh database,
> but this was not reliable. With a larger amount of data I guess the
> export won't work at all.
>
> Is there a better way to recover from this situation?
>
>
> Thank you very much for your help.
>
> Regards
> Ingrid Voigt
> --
> Psst! Geheimtipp: Online Games kostenlos spielen bei den GMX Free Games!
> http://games.entertainment.gmx.net/de/entertainment/games/free
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Howard A. Latham

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 27 2008 - 06:33:22 CDT

Original text of this message