Re: Recoverying a corrupted system tablespace without a backup
- From: Howard Latham <howard.latham@xxxxxxxxx>
- To: kennethnaim@xxxxxxxxx
- Date: Fri, 22 Oct 2010 21:10:57 +0100
There was a tool that extrcted strings from databases but is gone off the
net. Ill see if we still have it installed
On 22 October 2010 19:52, Kenneth Naim <kennethnaim@xxxxxxxxx> wrote:
> I've handled block corruptions before and am familiar with the recovery
> process for corrupt blocks. As you said in this particular situation, none
> of that knowledge has yielded results. The database is down and will not
> start. I've tried restarting with various underscore corruption related
> parameters (_allow_resetlogs_corruption=TRUE,
> _allow_read_only_corruption=true). The database is in no archivelog mode
> and
> I have tried complete and incomplete media recovery using the last redo log
> which succeeds but the database will not open with same error.
>
> I tried to contact several dul utility vendors I found online, but so far
> every email has bounced and phone has been out of service. Thanks for the
> link I'll check it out.
>
> Ken
>
> -----Original Message-----
> From: Martin Berger [mailto:martin.a.berger@xxxxxxxxx]
> Sent: Friday, October 22, 2010 2:57 AM
> To: kennethnaim
> Cc: Oracle-L Group
> Subject: Re: Recoverying a corrupted system tablespace without a backup
>
> Kenneth,
>
> a good starting point for block corruption is
> Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g/11g (Doc ID
> 28814.1)
> But I'm afraid, it will not help you too much in your current situation.
>
> Can you please provide what state the instance is right now, and what
> are the error messages at your attempt to open the DB?
>
> There are several methods - most of them can bring a DB up at least
> long enough to export everything which is not corrupted.
>
>
> The only unloader I know about (except the one of oracle support) is
> from http://www.ora600.be/ [1]. But it's not free afaik.
>
> regards,
> Martin
>
> On Thu, Oct 21, 2010 at 20:12, Kenneth Naim <kennethnaim@xxxxxxxxx> wrote:
> > A client of mine has a dev database (10g on linux) that was never backed
> up
> > and due to a controller issue has a corrupted system tablespace. DBV
> shows
> 8
> > corrupted blocks. Is there a way to open the database just long enough to
> > export some key tables with some important configuration data? All the
> > tables are in one 2.1gb datafile without corrupted blocks. Are there any
> > free/cheap unloader utilities?
>
>
> [1] DISCLAIMER: no I am not nor was ever .... bla bla ...
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Howard A. Latham
Sent from my Nokia N97
Other related posts:
