Re: Non-Sql data extraction (recovery tools)

From: John Smith <john40855_at_gmail.com>
Date: Thu, 15 Aug 2013 13:22:51 -0500
Message-ID: <CALh2JytpM1nh81LCsfDUwAWTVxO_r08AzUzi6Q-T4NdYw8b8+g_at_mail.gmail.com>

Im sorry, I should have made that clear. Im getting errors about corruption in my alert log, and ora-600 errors when trying to do simple selects and exports. Occasionally I get object no longer exists errors also. The last backup is corrupted also.

On Thu, Aug 15, 2013 at 1:16 PM, Tim Gorman <tim_at_evdbt.com> wrote:

> One of two things are going on here...
> 1. Performing recovery from a unopenable Oracle database, when this is
> the only possible method to extract the data for reload
> * Though it isn't free, DUDE (http://www.ora600.be) is the best
> tool available at the lowest cost
> o if the data is truly of value, then the cost should
> considered in light of the value of the data
> o Extracting data directly from the datafiles for any other
> purpose or reason is foolish
> + Bypassing the consistent-read mechanism built into the
> SQL API of Oracle can yield corrupted data
> 2. Hacking into some Oracle datafiles
> * I am not interested in helping someone do this, both for the
> reasons stated above and because it might be irresponsible
> <SNIP

>
>

> --
> http://www.freelists.org/webpage/oracle-l

>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 15 2013 - 20:22:51 CEST