RE: Recovering a corrupted system tablespace without a backup
- From: "Kenneth Naim" <kennethnaim@xxxxxxxxx>
- To: "'David Litchfield'" <david@xxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <martin.a.berger@xxxxxxxxx>
- Date: Sat, 23 Oct 2010 13:43:30 -0400
I was able to get a copy of dul and unloaded and loaded the data into a new
database. Thanks' for everyone's responses, this has been a learning
experience for me. Hopefully this knowledge will go to waste though as I'd
hate to have recover another database without a backup.
Ken
-----Original Message-----
From: David Litchfield [mailto:david@xxxxxxxxxxxxxxxxxxxx]
Sent: Friday, October 22, 2010 3:08 PM
To: oracle-l@xxxxxxxxxxxxx; martin.a.berger@xxxxxxxxx; kennethnaim@xxxxxxxxx
Subject: Re: Recoverying a corrupted system tablespace without a backup
Hi Ken,
I wrote a tool called orablock that can be used to dump data from data
files... It can be downloaded from here: http://www.v3rity.com/cadfile.zip
Cheers,
David
On 22/10/2010 19:52, Kenneth Naim 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
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: Recovering a corrupted system tablespace without a backup - Kenneth Naim
