Re: Block Corruption, cant start DB -SOS

Candido Dessanti <termy_at_blunet.it> wrote in message news:<3D886A84.5020108_at_blunet.it>...
> SGA wrote:
> > Hello All,
> > This is what I get in alert log when trying to start DB.
> > If anyone had similar problem before and have any idea how to startup
> > the db anyway please help!
>
> A datawarehouse failing, that's really a mess.
> I guess you havent any backup of it...
>
> I have a solution but I REALLY DONT KNOW IF WORKS
> or if there are best solutions..
>
>
> open server manager, mount the database and start an incomplete recovery
> (a loss of data here)

HOLD ON.
Before you do anything - if you have no backup - get a backup of what you have before you attempt any recovery. At worst, the data unloader tool can be used. If you *really* hose the database, even $10K and DUL won't be able to help.

Exactly how this poster thinks that you are going to recover a datafile in this fashion escapes me - the block is already corrupted - and other means would likely be required (such as copying a backup of the datafile prior to the corruption and applying all of the archived redo since the datafile was backed up). If you have no backups, or this is running in noarchivelog mode, media recovery is not going to be the route you're going to take.

Metalink has docs covering what to do in the event of block corruption.

> recover database until scn (the scn you think the transaction that's
> causing the write in failed block or the scn you found in alert.log file)
>
> alter database open resetlogs;
>
> doing that you would miss all the transactions since the scn# you used
> for incomplete recovery
>
> now you would have to recover the table that causing troubles
> with the DBMS_REPAIR package
>
> here is a link and i know the package would exists in oracle 8.1.7 too
>
> http://download-uk.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/dbms_rep.htm
>
> ANOTHER SOLUTION WOULD BE CALLING ORACLE SUPPORT
now there is a good idea. I'd start with that.

Paul Received on Wed Sep 18 2002 - 18:09:28 CDT