Re: Block Corruption, cant start DB -SOS

> Besides, if he has no backups and no mirroring anywhere, it's
> gonna be awfully difficult to recover anything. With or without SCN.

Of course the backup have to be done, when possible. Do you have an idea how much takes backing up 1Terabyte database? A vary long time, so maybe he isnt able to do backups; but the point is...if he has backups why he isnt doing a datafile recovery? I guess he hasnt a backup. And even with a backup success isnt guaranted, because it looks like there is logical corruption.

> I'm quite sure we don't. Not that kind.

Crash recovery is performed by database after a crash or shutdown abort recovering the database with the online redo logs, so idea of mine was simply to force an incomplete crash recovery until the transaction is generating the problem,even i dont think it would be successfull it wont damage in any way the database just because it would immediatly fail doing anything to database files. Received on Fri Sep 20 2002 - 03:19:18 CDT