RE: Recoverying a corrupted system tablespace without a backup
- From: "Kenneth Naim" <kennethnaim@xxxxxxxxx>
- To: "'Martin Berger'" <martin.a.berger@xxxxxxxxx>
- Date: Fri, 22 Oct 2010 14:52:15 -0400
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
Other related posts:
